Shared memory realm does not exist

ORA-27101 Shared memory realm does not exist 之解決

 

在试图登录pl/sql时,输入用户名（system/pwd)后，Oracle报告下列错误：
ERROR:
ORA-27101 Shared memory realm does not exist
ORA-01034 ORACLE not available  

或者在em登录的时候报告下列错误：
错误: NMO 未 setuid-root (只适用于 Unix)


查阅了相关
ORA-27101 Shared memory realm does not exist
ORA-01034 ORACLE not available  
的说明，解释为ORACLE_HOME或者ORACLE_SID设置不正确。
但检查bash_profile以后没有发现错误;
錯誤點，沒有開啟oracle服務；
解決辦法，直接開啟oracle相關數據庫的服務；
或按照下面的步驟操作:
lsnrctl start
sqlplus '/as sysdba'
sql> startup
emctl start dbconsole
isqlplusctl start

 

 

解决过程：

[oracle@jw ~]$ lsnrctl status

LSNRCTL for Linux: Version 9.2.0.4.0 - Production on 13-12011 14:42:57

Copyright (c) 1991, 2002, Oracle Corporation.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))

TNS-01169: The listener has not recognized the password

[oracle@jw ~]$ sqlplus '/as sysdba'

SQL*Plus: Release 9.2.0.4.0 - Production on 23 14:43:32 2011

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

Connected to an idle instance.

SQL> startup

ORACLE instance started.

Total System Global Area 1544624768 bytes

Fixed Size                   453248 bytes

Variable Size            1207959552 bytes

Database Buffers          335544320 bytes

Redo Buffers                 667648 bytes

Database mounted.

Database opened.