我是靠谱客的博主 单薄大叔,这篇文章主要介绍oracle重启后,启动监听出现Instance "PLSExtProc", status UNKNOWN,现在分享给大家,希望可以做个参考。

解决方式:oracle用户下

1.执行sqlplus / as sysdba;

2.修改local_listener参数,sql> alter system set local_listener='';

3,再重新注册服务,sql> alter system register;

4.sql>exit;

5.查看注册情况,$ lsnrctl status

Service "PLSExtProc" has 1 instance(s).
   Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "dg1.oracle.com" has 1 instance(s).
   Instance "dg", status READY, has 4 handler(s) for this service...
Service "dg1_XPT.oracle.com" has 1 instance(s).
   Instance "dg", status READY, has 4 handler(s) for this service...
Service "hr.oracle.com" has 1 instance(s).
   Instance "dg", status READY, has 4 handler(s) for this service...
Service "oa.oracle.com" has 1 instance(s).
   Instance "dg", status READY, has 4 handler(s) for this service...
service_names中定义的服务都成功动态注册到listener。
远程pl/sql连接数据库成功。


如果plsql还不能连接,请检查防火墙设置

service iptables status

如果防火墙开着,请关闭防火墙:

1)永久性生效,重启后不会复原 
开启: chkconfig iptables on 关闭: chkconfig iptables off 
2)即时生效,重启后复原 
开启: service iptables start 关闭: service iptables stop 


原文连接:http://blog.sina.com.cn/s/blog_8345cdd90100v6wx.html

最后

以上就是单薄大叔最近收集整理的关于oracle重启后,启动监听出现Instance "PLSExtProc", status UNKNOWN的全部内容,更多相关oracle重启后,启动监听出现Instance内容请搜索靠谱客的其他文章。

本图文内容来源于网友提供,作为学习参考使用,或来自网络收集整理,版权属于原作者所有。
点赞(67)

评论列表共有 0 条评论

立即
投稿
返回
顶部