1、监听启动相关命令
lsnrctl stop;
lsnrctl start;
lsnrctl stat;
2、监听启动后无法访问,提示ORA-12541错误,tnsping无法连接,监听无法启动错误,处理步骤如下:
a、判断监听是否启动;
b、检查listener.ora文件,检查里面的host是否为制定IP,如果不是则需要改为IP;
c、重新启动监听,测试是否可以连接,如果不能连接,则检查d;
d、在listenr.ora文件中增加如下:
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = E:\oracle\ora92)
)
(SID_DESC =
(SID_NAME = oradb)
(ORACLE_HOME = E:\oracle\ora92)
)
(SID_DESC =
(SID_NAME = mesdb)
(ORACLE_HOME = E:\oracle\ora92)
)
)
e、重启监听