I got ” ORA-609 : Opiodr aborting process unknown ospid ” error in Oracle.
ORA-609 : Opiodr aborting process unknown ospid
Details of error are as follows.
ORA-00609: could not attach to incoming connection ORA-12537: TNS:connection closed ORA-609 : opiodr aborting process unknown ospid (2436_7464)
ORA-609 : opiodr aborting process unknown ospid (21631120_1)
Opiodr aborting process unknown ospid
This ORA-609 errors are related with the client disconnecting before the connection can be established fully. Timeout parameters INBOUND_CONNECT_TIMEOUT_<listener_name> in the LISTENER.ORA file and SQLNET.INBOUND_CONNECT_TIMEOUT in the SQLNET.ORA need to be reviewed.
If using the default of 60 seconds, (no explicit setting), then it is likely these parameters will need to be increased.
- Review and check network settings for the server machine where the database is running. Ensure settings are all correct and as expected and DNS servers are available
- If the server platform is Microsoft Windows, check the Windows Services for TNS listener and database ensure each service is started using the same account.
To solve this error, set SQLNET.INBOUND_CONNECT_TIMEOUT=180 in Sqlnet.ora.
and set INBOUND_CONNECT_TIMEOUT_listener_name=120 in Listener.ora under $ORACLE_HOME/network/admin.
912 views last month, 5 views today