Re: sqlplus connect string issue

From: hrishy <hrishys_at_yahoo.co.uk>
Date: Tue, 30 Jun 2009 09:22:04 +0000 (GMT)
Message-ID: <394600.2455.qm_at_web23704.mail.ird.yahoo.com>

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> 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> wrote:


From: Howard Latham <howard.latham_at_gmail.com>
Subject: Re: sqlplus connect string issue

To: hrishys_at_yahoo.co.uk
Cc: "oracle-l_at_freelists.org" <oracle-l_at_freelists.org>, "MarkBobak" <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>






Hi Mark


 

Nope TWO_TASK is not set.


 

regards
Hrishy

--- On Mon, 29/6/09, Bobak, Mark <Mark.Bobak_at_proquest.com> wrote:


From: Bobak, Mark <Mark.Bobak_at_proquest.com>
Subject: RE: sqlplus connect string issue
To: "hrishys_at_yahoo.co.uk" <hrishys_at_yahoo.co.uk>, "oracle-l_at_freelists.org" <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 [oracle-l-bounce_at_freelists.org] On Behalf Of hrishy [hrishys_at_yahoo.co.uk]
Sent: Monday, June 29, 2009 5:09
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/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

Received on Tue Jun 30 2009 - 04:22:04 CDT