Service "orcl" has 1 instance(s). Instance "orcl", status UNKNOWN, has 1 handler(s) for this service... The command completed successfully 命令:[oracle@gpdb ~]$ sqlplus / as sysdba SQL> startup SQL> alter system register; SQL> quit [oracle@gpdb ~]$ lsnrctl status 输出: LSNRCTL for ...
3.然后直接google Instance "orcl", status UNKNOWN, has 1 handler(s) for this service... 网上说可能是/etc/hosts问题,参考:http://gaoshan.blog.51cto.com/742525/477281 我的hosts 是 192.168.0.10 fansyPC 没有问题,但是需要 127.0.0.1 localhost 这一句?加上后,重新启动完成。 最后附上一个官网教程:...
先看看 lsnrctl status 的输出信息: Services Summary... Service "PLSExtProc" has 1 instance(s). Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service... Service "catadb" has 2 instance(s). Instance "catadb", status UNKNOWN, has 1 handler(s) for this service... In...
1.lsnrctl status# 我注意到,这里的红框标注的CAD,CLRExtProc和 listener.ora中是一致的 另外,这里的status是unknown。表示: An UNKNOWN status means that the instance is registered statically in the listener.ora file rather than dynamically with service registra tion. Therefore, the status is non known....
Service “POD” has 1 instance(s). Instance “POD”, status READY, has 1 handler(s) for this service… Service “POD1″ has 1 instance(s). Instance “POD”, status UNKNOWN, has 1 handler(s) for this service… Service “PODS” has 1 instance(s). ...
19、Instance “orcl”, status UNKNOWN, has 1 handler(s) for this service… 解决办法: (1)由于实例没有注册到监听服务中去,于是注册实例 SQL> alter system register; 1. (2)查看监听配置是否有问题 (3)查看日志 $ tail -30/u01/app/diag/tnslsnr/localhost/listener/alert/log.xml ...
Also, apparently when I ran the $ lsnrctl status LISTENER, I got the output as status UKNOWN because dynamic registraion was turned OFF. Service "DB2" has 1 instance(s). Instance "DB2", status UNKNOWN, has 1 handler(s) for this service... So, 2 databases on the...
Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service... Service "HERPDEVDBXDB" has 1 instance(s). Instance "herpdevdb", status READY, has 1 handler(s) for this service... Service "herpdevdb" has 1 instance(s). Instance "herpdevdb", status R...
动态注册,是与静态注册相对应的一种注册方法,不需要指定instance_name和service_name,而是在数据库例程启动时,通过例程的后台进程PMON定期向监听器注册服务。 动态注册情况下,监听程序知道例程服务的状态。 那么,如何区分数据库是动态注册还是静态注册呢? 使用lsnrctl的status命令 ...