Re: sqlplus connect string issue
- From: hrishy <hrishys@xxxxxxxxxxx>
- To: Howard Latham <howard.latham@xxxxxxxxx>, "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>, MarkBobak <Mark.Bobak@xxxxxxxxxxxx>, Niall Litchfield <niall.litchfield@xxxxxxxxx>
- Date: Tue, 30 Jun 2009 09:17:08 +0000 (GMT)
Hi
I am sorry i did not understand your statement.Can you please rephrase
When i try
sqlplus username/password@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@xxxxxxxxx> wrote:
From: Niall Litchfield <niall.litchfield@xxxxxxxxx>
Subject: Re: sqlplus connect string issue
To: hrishys@xxxxxxxxxxx, "Howard Latham" <howard.latham@xxxxxxxxx>,
"oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>, "MarkBobak"
<Mark.Bobak@xxxxxxxxxxxx>
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@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> wrote:
>
>
> From: Howard Latham <howard.latham@xxxxxxxxx>
> Subject: Re: sqlplus connect string issue
> To: hrishys@xxxxxxxxxxx
> Cc: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>, "MarkBobak"
> <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>
>
>
>
>
>
>
> Hi Mark
>
> Nope TWO_TASK is not set.
>
> regards
> Hrishy
>
> --- On Mon, 29/6/09, Bobak, Mark <Mark.Bobak@xxxxxxxxxxxx> wrote:
>
>
> From: Bobak, Mark <Mark.Bobak@xxxxxxxxxxxx>
> Subject: RE: sqlplus connect string issue
> To: "hrishys@xxxxxxxxxxx" <hrishys@xxxxxxxxxxx>, "oracle-l@xxxxxxxxxxxxx"
> <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 [oracle-l-bounce@xxxxxxxxxxxxx] On
> Behalf Of hrishy [hrishys@xxxxxxxxxxx]
> Sent: Monday, June 29, 2009 5:09
> 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/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
>
>
>
>
>
>
--
Sent from Google Mail for mobile | mobile.google.com
Niall Litchfield
Oracle DBA
http://www.orawin.info
Other related posts:
