"shared memory realm not available" on Orc9i, W2k

From: The CQMMAN <cqmman_at_yahoo.co.uk>
Date: 22 Jun 2004 08:40:54 -0700
Message-ID: <65017aa5.0406220740.556c9bf2@posting.google.com>

Hello,

When I try to connect to my Oracle instance on the W2K server that it is installed on, using SQLPLUS (ie, SQLPLUS user/password_at_instance), I get:

ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist

If I try again at the "Enter user-name:" prompt with "user/password", I then get:

ERROR:
ORA-12560: TNS:Protocol adapter error

On the server, the OracleOraHome92TNSListener service and the OracleServiceInstance service are both running.

The TNSNAMES.ORA is pointing to the localhost and port 1521 (and TCP), and the Listener.ora seems to be OK because it has TCP as a protocol, the machinename as the host, and 1521 as the port. It also has a second address as IPC with a key of EXTPROC0.

I didn't have a variable set for the oracle_sid, so I set this manually (set oracle_sid=instance from a commandline) but there was no change on that.

Oracle is 9.2.0.1.0, and it is running W2K service pack 4.

Not being an expert, I am not really sure what else to check so any hints would be most welcome. I hope I haven't missed any vital piece of info!

Cheers Received on Tue Jun 22 2004 - 10:40:54 CDT