Re: sqlplus connect string issue
Date: Tue, 30 Jun 2009 09:22:04 +0000 (GMT)
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.
- 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
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?
-- LSC On Tue, Jun 30, 2009 at 6:16 AM, hrishy <hrishys_at_yahoo.co.uk> wrote: Hi AllReceived on Tue Jun 30 2009 - 04:22:04 CDT
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