原来PORT是1521,现在只改成1522,就发现SQLPLUS就无法连接ORACLE了,改成1521就是OK的,DB是9204的,望高手指点,不胜感谢!ERROR:
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exis
HP-UX Error: 2: No such file or directory
------------------------------------------------------
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = oralceserver)(PORT = 1521))
)
)SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /disk/myoralce)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = benqadm)
(ORACLE_HOME = /disk/myoralce)
(SID_NAME = myoralce)
)
)
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exis
HP-UX Error: 2: No such file or directory
------------------------------------------------------
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = oralceserver)(PORT = 1521))
)
)SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /disk/myoralce)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = benqadm)
(ORACLE_HOME = /disk/myoralce)
(SID_NAME = myoralce)
)
)
你的tns同时也改了1522吗?
CLIENT的TNS也改动了!
改成其他不知道会有什么影响.