今天在ITPUB上看到有贴关于ORA-01034的,测试了一下,发现是下面的问题造成:
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /home/db/oracle/product/10.2.0/)
(PROGRAM = extproc)
)
(SID_DESC =
(SID_NAME = fwxtprd)
(ORACLE_HOME = /home/db/oracle/product/10.2.0/)
)
)
listener.ora里面这两条描述不能够有最后的/,改为以下:
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /home/db/oracle/product/10.2.0)
(PROGRAM = extproc)
)
(SID_DESC =
(SID_NAME = fwxtprd)
(ORACLE_HOME = /home/db/oracle/product/10.2.0)
)
)
我测试的结果:
SQL> conn lcbj/lcbj@support
ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
SVR4 Error: 2: No such file or directory
SQL>
修改后,重启监听:
SQL> conn lcbj/lcbj@support
已连接。
SQL>
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/16628454/viewspace-578171/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/16628454/viewspace-578171/