11 February 2011

ORA-609 : opiodr aborting process unknown ospid

Error:-
Fatal NI connect error 12170.

  VERSION INFORMATION:
        TNS for Linux: Version 11.1.0.7.0 - Production
        Oracle Bequeath NT Protocol Adapter for Linux: Version 11.1.0.7.0 - Production
        TCP/IP NT Protocol Adapter for Linux: Version 11.1.0.7.0 - Production
  Time: 11-FEB-2011 15:15:25
  Tracing not turned on.
  Tns error struct:
    ns main err code: 12535

TNS-12535: TNS:operation timed out
    ns secondary err code: 12606
    nt main err code: 0
    nt secondary err code: 0
    nt OS err code: 0
  Client address: <unknown>
ORA-609 : opiodr aborting process unknown ospid

Solution :-

Sqlnet.ora: SQLNET.INBOUND_CONNECT_TIMEOUT=120
 

TNS errors in the alert.log by setting the following listener.ora file parameter:
 
INBOUND_CONNECT_TIMEOUT_listener_name=120
DIAG_ADR_ENABLED_listener_name=OFF

 

No comments: