Oracle-Error: opiodr aborting process unknown ospid ( ) as a result of ORA-609

Background:

After shutdown and restarted the oracle instance by an executive, client can’t connect to database instance though database is up and running and listener service is up.

OS: Windows Server 2012 x64, Oracle: 11g R2, Data Guard Configured

Workaround:

From the alert_SID.log file found the below error raised after shutdown and consecutive startup and when the user is trying to connect from Toad or other client.

Fatal NI connect error 12560, connecting to:
 (LOCAL=NO)

  VERSION INFORMATION:
 TNS for 64-bit Windows: Version 11.2.0.1.0 - Production
 Oracle Bequeath NT Protocol Adapter for 64-bit Windows: Version 11.2.0.1.0 - Production
 Windows NT TCP/IP NT Protocol Adapter for 64-bit Windows: Version 11.2.0.1.0 - Production
  Time: 12-MAR-2018 10:46:02
  Tracing not turned on.
  Tns error struct:
    ns main err code: 12560
    
TNS-12560: TNS:protocol adapter error
    ns secondary err code: 0
    nt main err code: 0
    nt secondary err code: 0
    nt OS err code: 0
opiodr aborting process unknown ospid (7392) as a result of ORA-609
Mon Mar 12 10:46:10 2018

Tried recreating LISTENER file, increased the value for SQLNET.INBOUND_CONNECT_TIMEOUT, INBOUND_CONNECT_TIMEOUT_LISTENER but no help. Finally resolved by changing the Log On User for the Oracle service to Local System Account instead of .\Administrator( with the help from www.ora00600.com)

To Change the Log On:

  1. Go to Strat > Control Panel > Services
  2. Search for Oracle service
  3. Go to properties of the Oracle service
  4. Navigate to Log On tab
  5. Select Local system Account for the value of Log on as:
  6. Select ok
  7. Restart the database service.

 

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.