查看tnsnames.ora文件中查询库SID,例如为:SID = test
ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
可以检查下
是否 缺少
LISTENER_TEST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
)
或者,检查 LISTENER_TEST (SID)与对应的的数据库SID不一致
TEST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = test)
)
)