一个小问题,折腾了近两个小时,把它记录下来
windows客户端连接远程数据库,总是出现
SQL> conn hr@mydata237
请输入口令:
ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux Error: 2: No such file or directory
cat /oracle/10g/network/admin/listener.ora
# listener.ora Network Configuration File: /oracle/10g/network/admin/listener.ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = mydata)
(ORACLE_HOME = /oracle/10g)
(
SID_NAME = extproc)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.237)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
)
原来是这里的sid_name没有修改,现在修改好
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = mydata)
(ORACLE_HOME = /oracle/10g)
(SID_NAME = mydata)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.237)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
)
再测试下,
SQL> conn hr@mydata237
请输入口令:
已连接。
ok了
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/15142212/viewspace-673596/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/15142212/viewspace-673596/