2012-08-07

ある日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でリスナーの「再構成」でもいいのかな?
コメントを投稿