ある日listenerが応答しなくなった
Oracleで無理やりなことしてたら、ある日Listenerが応答しなくなっちゃいました。
$ lsnrctl stop $ lsnrctl start Service "PLSExtProc" has 1 instance(s). Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service... $ lsnrctl status TNS-12541: TNS:no listener TNS-12560: TNS:protocol adapter error TNS-00511: No listener Linux Error: 111: Connection refusedって出ちゃう。
netcaでリスナー作り直してもダメ。 Listenerを再構成
$ sqlplus / as sysdba SQL> alter system register; System altered. SQL> exit確認
$ lsnrctl status Services Summary... Service "PLSExtProc" has 1 instance(s). Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service... Service "hoge" has 1 instance(s). Instance "hoge", status READY, has 1 handler(s) for this service... Service "hogeXDB" has 1 instance(s). Instance "hoge", status READY, has 1 handler(s) for this service... Service "hoge_XPT" has 1 instance(s). Instance "hoge", status READY, has 1 handler(s) for this service...netcaでリスナーの「再構成」でもいいのかな?
コメント