ORA-609 : Opiodr aborting process unknown ospid

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.

Do you want to learn Oracle Database for Beginners, then read the following articles.

Oracle Tutorial | Oracle Database Tutorials for Beginners ( Junior Oracle DBA )