Re: sqlplus fails when sid is specified.

Garry wrote:

> Hello all, newbie in the house :)

You are? Then I will need your credit card number for newbie verification please. ASAP. (the liquor stores are closing soon here within the next few hours)

> sqlplus username/password I can connect fine, but when connecting with
> username/password_at_SID as same user with same enviroment I recive the
> following error

It is not username/password_at_SID, but username/password_at_TNSALIAS.

Where TNSALIAS is an alias (for a SID on a port on a server) in your tnsnames.ora file.

> My listener log shows the following.
> ERROR:Enter user-name: 27-MAY-2003 12:58:37 *
> (CONNECT_DATA=(SID=<correct sid>)(GLOBAL_NAME=<sid
> name>)(CID=(PROGRAM=)(HOST=<hostname>)(USER=oracle))) *
> (ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=43567)) * establish *
> coi1 * 0

Did you edit the above log entry for posting? I.e. <correct sid> should read coi1? <hostname> should be localhost?

Either way, it seems like an error in your listener.ora file.

A valid log entry should look something like:

(CONNECT_DATA=(SID=dev)(CID=(PROGRAM=)(HOST=ufor00a5)(USER=integ))) * (ADDRESS=(PROTOCOL=tcp)(HOST=155.239.48.9)(PORT=51317)) * establish * dev * 0

Post you listener.ora file.

Er.. and don't forget that credit card number too. ;-)

--
Billy