Re: sqlplus connect string issue

From: hrishy <hrishys_at_yahoo.co.uk>
Date: Tue, 30 Jun 2009 09:17:08 +0000 (GMT)
Message-ID: <713323.47263.qm_at_web23708.mail.ird.yahoo.com>

Hi
 
I am sorry i did not understand your statement.Can you please rephrase  
When i try
 
sqlplus username/password_at_mysid it connects. But when i try
export ORACLE_SID=mysid
sqlplus username/password it does not connect

• On Tue, 30/6/09, Niall Litchfield <niall.litchfield_at_gmail.com> wrote:

From: Niall Litchfield <niall.litchfield_at_gmail.com> Subject: Re: sqlplus connect string issue To: hrishys_at_yahoo.co.uk, "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, 7:16 AM

I don't see anywhere that you have verified that ORACLE_SID is set correctly.

On 6/30/09, 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
>
>
>
>
>
>

-- 
Sent from Google Mail for mobile | mobile.google.com

Niall Litchfield
Oracle DBA
http://www.orawin.info



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

Received on Tue Jun 30 2009 - 04:17:08 CDT