listener.ora内容如下:
LISTENER=
(ADDRESS_LIST=
(ADDRESS=
(PROTOCOL=tcp)
(HOST=10.123.56.36)
(PORT=1521)
)
)
SID_LIST_LISTENER=
(SID_LIST=
(SID_DESC=
(SID_NAME=ora7)
(ORACLE_HOME=/oracle)
)
)
TRACE_LEVEL_LISTENER=OFF
STARTUP_WAIT_TIME_LISTENER=0
LISTENER=
(ADDRESS_LIST=
(ADDRESS=
(PROTOCOL=tcp)
(HOST=10.123.56.36)
(PORT=1521)
)
)
SID_LIST_LISTENER=
(SID_LIST=
(SID_DESC=
(SID_NAME=ora7)
(ORACLE_HOME=/oracle)
)
)
TRACE_LEVEL_LISTENER=OFF
STARTUP_WAIT_TIME_LISTENER=0
如果监听出问题, 通常我们是这样处理的
lsnrctl status查看状态.
查看listen.log有什么报错.
在服务中将listener设置为自动启动.