天天看點

[Oracle] opiodr aborting process unknown ospid (***) as a result of ORA-609

今天線上資料庫(版本11.2.0.1)無法建立新連接配接,但原有的連接配接不受影響,alert.log報如下錯誤:

opiodr aborting process unknown ospid (22997) as a result of ORA-609

但在listener.log裡卻顯示連接配接已建立

03-APR-2014 16:05:44 * (CONNECT_DATA=(SERVICE_NAME=orcl2.localdomain)(CID=([email protected])(HOST=lx151)(USER=gl))) * (ADDRESS=(PROTOCOL=tcp)(HOST=10.10.100.151)(PORT=52903)) *establish * orcl2.localdomain * 0

在sqlnet.log裡報12537錯誤

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: 03-APR-2014 15:24:30

  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

當用lsnrctl status檢視監聽器狀态時,卡住

通過查詢官方文檔,知道這是個bug,後來根據網上搜尋的解決辦法,連結:http://forums.oracle.com/forums/thread.jspa?messageID=4489745

删除主機檔案/etc/resolv.conf,果然恢複了,具體原因不清楚,這隻是一個臨時的解決辦法,要想徹底解決,應該要更新。