ORA-27101: shared memory realm does not exist
698957Apr 29 2009 — edited May 11 2009I know this has been answered many times but I can just not make it work. I installed Oracle and all ran fine, very small DB, until the server was rebooted. I had to uninstall and reinstall to get it working again. When the server was rebooted I received the error again.
Any help would be greatly appreciated...ed
Here's the details.
I'm running Oracle 10.2 on Win2003 Server
I have oracle installed in c:\ora102
I have not changed any init files.
I have 2 environment variables set:
ORACLE_HOME=C:\ora102
ORACLE_SID=ORACLE
I tried upper and lower case for the oracle_sid value
--------------------------
Listener.ora:
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = ORACLE)
(ORACLE_HOME = C:\ora102)
(PROGRAM = extproc)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
(ADDRESS = (PROTOCOL = TCP)(HOST = Win2003Server)(PORT = 1521))
)
)
----------------------------
c:\>tnsping local
TNS Ping Utility for 32-bit Windows: Version 10.2.0.1.0 - Production on 29-APR-2009 10:34:47
Copyright (c) 1997, 2005, Oracle. All rights reserved.
Used parameter files:
C:\ora102\network\admin\sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = Win2003Server)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = oracle)))
OK (20 msec)
-------------------------
c:\>sqlplus system/foobar@local
SQL*Plus: Release 10.2.0.1.0 - Production on Wed Apr 29 10:37:26 2009
Copyright (c) 1982, 2005, Oracle. All rights reserved.
ERROR:
ORA-28547: connection to server failed, probable Oracle Net admin error
------------------------------
c:\>sqlplus sys/foobar as sysdba
SQL*Plus: Release 10.2.0.1.0 - Production on Wed Apr 29 10:33:18 2009
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to an idle instance.
SQL> show parameter local listener
ORA-01034: ORACLE not available