Windows服务器崩溃后,数据库实例能够启动,但是数据库监听启动不了。具体报错如下
监听该对象时出错: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=WIN-73VSFA4MV24)(POR
T=1521)))
TNS-12560: TNS: 协议适配器错误
TNS-00584: 有效节点检查配置错误
我将HOST改为192.168.1.7(局域网ip)127.0.0.1和localhost都报同样的错误
我的监听文件如下
# listener.ora Network Configuration File: C:oracleproduct10.2.0db_1networkadminlistener.ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:oracleproduct10.2.0db_1)
(PROGRAM = extproc)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = WIN-73VSFA4MV24)(PORT = 1521))
)
)
我想请教各位大神出现这样的问题我该从哪里着手,一般情况下oracle出错检查的大致步骤是怎么样的。
在此感谢各位关注的大神
收起