sqlplus fails when sid is specified.

From: Garry <speedy_at_gonzales.co.uk>
Date: 27 May 2003 05:09:11 -0700
Message-ID: <6eb67e5.0305270409.31bca22f@posting.google.com>

Hello all, newbie in the house :)

Wondering if anyone has had similar problem....

When connecting to oracle using method

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

ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist Linux Error: 2: No such file or directory

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

OS:Redhat: 7.2
Kernel Version:2.4.7-10
Oracle version:9i 9.0.1 (most recent patch set) Install type:standard

Any help would be greatly appreciated.

Thanks in advance.

Garry. Received on Tue May 27 2003 - 07:09:11 CDT