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
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 188.8.131.52.0 - Production Oracle Bequeath NT Protocol Adapter for 64-bit Windows: Version 184.108.40.206.0 - Production Windows NT TCP/IP NT Protocol Adapter for 64-bit Windows: Version 220.127.116.11.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:
- Go to Strat > Control Panel > Services
- Search for Oracle service
- Go to properties of the Oracle service
- Navigate to Log On tab
- Select Local system Account for the value of Log on as:
- Select ok
- Restart the database service.