Hi 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@xxxxxxxxxxx> 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@xxxxxxxxx>* wrote: > > > From: LS Cheng <exriscer@xxxxxxxxx> > Subject: Re: sqlplus connect string issue > To: hrishys@xxxxxxxxxxx > Cc: "Howard Latham" <howard.latham@xxxxxxxxx>, "oracle-l@xxxxxxxxxxxxx" < > oracle-l@xxxxxxxxxxxxx>, "MarkBobak" <Mark.Bobak@xxxxxxxxxxxx> > 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@xxxxxxxxxxx<http://uk.mc237.mail.yahoo.com/mc/compose?to=hrishys@xxxxxxxxxxx> > > 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@xxxxxxxxx<http://uk.mc237.mail.yahoo.com/mc/compose?to=howard.latham@xxxxxxxxx> >> >* wrote: >> >> >> From: Howard Latham >> <howard.latham@xxxxxxxxx<http://uk.mc237.mail.yahoo.com/mc/compose?to=howard.latham@xxxxxxxxx> >> > >> Subject: Re: sqlplus connect string issue >> To: >> hrishys@xxxxxxxxxxx<http://uk.mc237.mail.yahoo.com/mc/compose?to=hrishys@xxxxxxxxxxx> >> Cc: >> "oracle-l@xxxxxxxxxxxxx<http://uk.mc237.mail.yahoo.com/mc/compose?to=oracle-l@xxxxxxxxxxxxx>" >> <oracle-l@xxxxxxxxxxxxx<http://uk.mc237.mail.yahoo.com/mc/compose?to=oracle-l@xxxxxxxxxxxxx>>, >> "MarkBobak" >> <Mark.Bobak@xxxxxxxxxxxx<http://uk.mc237.mail.yahoo.com/mc/compose?to=Mark.Bobak@xxxxxxxxxxxx> >> > >> Date: Monday, 29 June, 2009, 3:38 PM >> >> >> Can you do a tnsping ahnd post the results >> ? >> >> 2009/6/29 hrishy >> <hrishys@xxxxxxxxxxx<http://uk.mc237.mail.yahoo.com/mc/compose?to=hrishys@xxxxxxxxxxx> >> > >> >>> Hi Mark >>> >>> Nope TWO_TASK is not set. >>> >>> regards >>> Hrishy >>> >>> --- On *Mon, 29/6/09, Bobak, Mark >>> <Mark.Bobak@xxxxxxxxxxxx<http://uk.mc237.mail.yahoo.com/mc/compose?to=Mark.Bobak@xxxxxxxxxxxx> >>> >* wrote: >>> >>> >>> From: Bobak, Mark >>> <Mark.Bobak@xxxxxxxxxxxx<http://uk.mc237.mail.yahoo.com/mc/compose?to=Mark.Bobak@xxxxxxxxxxxx> >>> > >>> Subject: RE: sqlplus connect string issue >>> To: >>> "hrishys@xxxxxxxxxxx<http://uk.mc237.mail.yahoo.com/mc/compose?to=hrishys@xxxxxxxxxxx>" >>> <hrishys@xxxxxxxxxxx<http://uk.mc237.mail.yahoo.com/mc/compose?to=hrishys@xxxxxxxxxxx>>, >>> "oracle-l@xxxxxxxxxxxxx<http://uk.mc237.mail.yahoo.com/mc/compose?to=oracle-l@xxxxxxxxxxxxx>" >>> <oracle-l@xxxxxxxxxxxxx<http://uk.mc237.mail.yahoo.com/mc/compose?to=oracle-l@xxxxxxxxxxxxx> >>> > >>> 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@$TWO_TASK. >>> >>> Note that if TWO_TASK is set, it will always override ORACLE_SID. >>> >>> Hope that helps, >>> >>> -Mark >>> ________________________________________ >>> From: >>> oracle-l-bounce@xxxxxxxxxxxxx<http://uk.mc237.mail.yahoo.com/mc/compose?to=oracle-l-bounce@xxxxxxxxxxxxx>[ >>> oracle-l-bounce@xxxxxxxxxxxxx<http://uk.mc237.mail.yahoo.com/mc/compose?to=oracle-l-bounce@xxxxxxxxxxxxx>] >>> On Behalf Of hrishy >>> [hrishys@xxxxxxxxxxx<http://uk.mc237.mail.yahoo.com/mc/compose?to=hrishys@xxxxxxxxxxx> >>> ] >>> Sent: Monday, June 29, 2009 5:09 >>> To: >>> oracle-l@xxxxxxxxxxxxx<http://uk.mc237.mail.yahoo.com/mc/compose?to=oracle-l@xxxxxxxxxxxxx> >>> 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@connect-string<mailto:username<http://uk.mc237.mail.yahoo.com/mc/compose?to=username> >>> /password@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 >> >> >> >> > >