Re: sqlplus connect string issue

Your local SQLPLUS is from 9i HOME? The HOME from which the database is running?

Thanks

--
LSC


On Tue, Jun 30, 2009 at 11:22 AM, hrishy <hrishys_at_yahoo.co.uk> wrote:



> Hi

>

> Yes this box has several oarcle homes.

>

> On this box the database mysid is running from 9i oracle home, but the

> listener is from 10g oracle home.

>

>

>

> regards

> Hrishy

>

> --- On *Tue, 30/6/09, LS Cheng <exriscer_at_gmail.com>* wrote:

>

>

> From: LS Cheng <exriscer_at_gmail.com>

> Subject: Re: sqlplus connect string issue

> To: hrishys_at_yahoo.co.uk

> Cc: "Howard Latham" <howard.latham_at_gmail.com>, "oracle-l_at_freelists.org" <

> oracle-l_at_freelists.org>, "MarkBobak" <Mark.Bobak_at_proquest.com>

> Date: Tuesday, 30 June, 2009, 6:20 AM

>

> Hi

>

> Are your databases running from several ORACLE_HOME?

>

> Can you do ps -ef | grep pmon | grep mysid and look from which ORACLE_HOME

> is mysid running?

>

> Thanks

>

> --

> LSC

>

>

> On Tue, Jun 30, 2009 at 6:16 AM, hrishy <hrishys_at_yahoo.co.uk<http://uk.mc237.mail.yahoo.com/mc/compose?to=hrishys_at_yahoo.co.uk>

> > wrote:

>

>>   Hi All

>>

>> Database mysid is running on localhost

>>

>> tnsping mysid

>> Used TNSNAMES adapter to resolve the alias

>> Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (COMMUNITY

>> = tcp.world) (PROTOCOL = TCP) (Host = remotehost.com) (Port = 1522)))

>> (CONNECT_DATA = (SID = mysid)))

>> OK (0 msec)

>>

>> database spfile says its registered on a listener that is running on port

>> 1527

>> if do a show parameter listener on the database

>>

>> There is a non default named listener running on localhost on port 1527

>> which is a 10g listener.

>> regards

>> Hrishy

>> --- On *Mon, 29/6/09, Howard Latham <howard.latham_at_gmail.com<http://uk.mc237.mail.yahoo.com/mc/compose?to=howard.latham_at_gmail.com>

>> >* wrote:

>>

>>

>> From: Howard Latham <howard.latham_at_gmail.com<http://uk.mc237.mail.yahoo.com/mc/compose?to=howard.latham_at_gmail.com>

>> >

>> Subject: Re: sqlplus connect string issue

>> To: hrishys_at_yahoo.co.uk<http://uk.mc237.mail.yahoo.com/mc/compose?to=hrishys_at_yahoo.co.uk>

>> Cc: "oracle-l_at_freelists.org<http://uk.mc237.mail.yahoo.com/mc/compose?to=oracle-l_at_freelists.org>"

>> <oracle-l_at_freelists.org<http://uk.mc237.mail.yahoo.com/mc/compose?to=oracle-l_at_freelists.org>>,

>> "MarkBobak" <Mark.Bobak_at_proquest.com<http://uk.mc237.mail.yahoo.com/mc/compose?to=Mark.Bobak_at_proquest.com>

>> >

>> Date: Monday, 29 June, 2009, 3:38 PM

>>

>>

>>  Can you do a tnsping ahnd post the results

>> ?

>>

>> 2009/6/29 hrishy <hrishys_at_yahoo.co.uk<http://uk.mc237.mail.yahoo.com/mc/compose?to=hrishys_at_yahoo.co.uk>

>> >

>>

>>>   Hi Mark

>>>

>>> Nope TWO_TASK is not set.

>>>

>>> regards

>>> Hrishy

>>>

>>> --- On *Mon, 29/6/09, Bobak, Mark <Mark.Bobak_at_proquest.com<http://uk.mc237.mail.yahoo.com/mc/compose?to=Mark.Bobak_at_proquest.com>

>>> >* wrote:

>>>

>>>

>>> From: Bobak, Mark <Mark.Bobak_at_proquest.com<http://uk.mc237.mail.yahoo.com/mc/compose?to=Mark.Bobak_at_proquest.com>

>>> >

>>> Subject: RE: sqlplus connect string issue

>>> To: "hrishys_at_yahoo.co.uk<http://uk.mc237.mail.yahoo.com/mc/compose?to=hrishys_at_yahoo.co.uk>"

>>> <hrishys_at_yahoo.co.uk<http://uk.mc237.mail.yahoo.com/mc/compose?to=hrishys_at_yahoo.co.uk>>,

>>> "oracle-l_at_freelists.org<http://uk.mc237.mail.yahoo.com/mc/compose?to=oracle-l_at_freelists.org>"

>>> <oracle-l_at_freelists.org<http://uk.mc237.mail.yahoo.com/mc/compose?to=oracle-l_at_freelists.org>

>>> >

>>> Date: Monday, 29 June, 2009, 10:22 AM

>>>

>>>

>>> If the TWO_TASK environment variable is not set, then a login w/

>>> username/password will connect to the local database running out of

>>> $ORACLE_HOME and identified by $ORACLE_SID.

>>>

>>> If the TWO_TASK environment variable is set, then a login w/

>>> username/password will connect to a database identified by connect string

>>> with the value of $TWO_TASK.  In other words, it's the same as typing

>>> username/password_at_$TWO_TASK.

>>>

>>> Note that if TWO_TASK is set, it will always override ORACLE_SID.

>>>

>>> Hope that helps,

>>>

>>> -Mark

>>> ________________________________________

>>> From: oracle-l-bounce_at_freelists.org<http://uk.mc237.mail.yahoo.com/mc/compose?to=oracle-l-bounce_at_freelists.org>[

>>> oracle-l-bounce_at_freelists.org<http://uk.mc237.mail.yahoo.com/mc/compose?to=oracle-l-bounce_at_freelists.org>]

>>> On Behalf Of hrishy [hrishys_at_yahoo.co.uk<http://uk.mc237.mail.yahoo.com/mc/compose?to=hrishys_at_yahoo.co.uk>

>>> ]

>>> Sent: Monday, June 29, 2009 5:09

>>> To: oracle-l_at_freelists.org<http://uk.mc237.mail.yahoo.com/mc/compose?to=oracle-l_at_freelists.org>

>>> Subject: sqlplus connect string issue

>>>

>>> Hi

>>>

>>> For one of my databases i am unable to connect using

>>> sqlplus user/password

>>> but when i try

>>> sqlplus username/password_at_connect-string<mailto:username<http://uk.mc237.mail.yahoo.com/mc/compose?to=username>

>>> /password_at_connect-string>  it connects

>>>

>>> The error message i get using sqlplus username/password is

>>> ORA-01017: invalid username/password; logon denied

>>>

>>> There are many other databases on this server and they work fine.

>>> The thing that is different about this database is

>>>

>>> The tnsnames.ora has an entry for this database pointing to another host

>>> on port 1522.

>>> The local listener parameter on the database says the database is

>>> registered for a listener on port 1527

>>>

>>> i did a truss -o log sqlplus username/password but clueless on what i

>>> should look or fix so i can connect using just sqlplus username/password

>>> without the connection string.

>>>

>>> regards

>>> Hrishy

>>>

>>>

>>>

>>>

>>>

>>>

>>>

>>

>>

>> --

>> Howard A. Latham

>>

>>

>>

>>

>

>


--
http://www.freelists.org/webpage/oracle-l