天天看點

oracle監聽無響應解決

    今天現場維護人員報告說資料庫連接配接不上,PLSQL連接配接無響應。登陸資料庫伺服器後輸入lsnrctl status就卡住了。

查下監聽日志,主要是以下内容:

TNS-12525: TNS:listener has not received client's request in time allowed

TNS-12535: TNS:operation timed out

  TNS-12606: TNS: Application timeout occurred

TNS-12518: TNS:listener could not hand off client connection

TNS-12571: TNS:packet writer failure

  TNS-12560: TNS:protocol adapter error

   TNS-00530: Protocol adapter error

    Linux Error: 104: Connection reset by peer

27-NOV-2012 15:43:26 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=__jdbc__)(USER=oracle))(SERVICE_NAME=orcl)) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.10.1.200)(PORT=61018)) * establish * orcl * 0

資料庫警告日志中也出現ora-609内容:

Fatal NI connect error 12537, connecting to:

(LOCAL=NO)

VERSION INFORMATION:

TNS for Linux: Version 11.2.0.1.0 - Production

Oracle Bequeath NT Protocol Adapter for Linux: Version 11.2.0.1.0 - Production

TCP/IP NT Protocol Adapter for Linux: Version 11.2.0.1.0 - Production

Time: 29-FEB-2012 20:45:05

Tracing not turned on.

Tns error struct:

ns main err code: 12537

TNS-12537: TNS:connection closed

ns secondary err code: 12560

nt main err code: 0

nt secondary err code: 0

nt OS err code: 0

opiodr aborting process unknown ospid (12792) as a result of

ORA-609

重新開機監聽後問題重制。

解決方法,參考百度和谷歌的結果:

注釋掉/etc/resolve.conf 中對DNS解析内容。

重新開機監聽,OK.