11g and Newer: ORA-609 TNS-12537 and TNS-12547 or TNS-12170 in DB Alert.log
Last updated on JUNE 20, 2018
Applies to:Oracle Net Services - Version 22.214.171.124 to 126.96.36.199 [Release 11.1 to 12.2]
Oracle Database - Enterprise Edition - Version 188.8.131.52 to 184.108.40.206 [Release 12.1]
Information in this document applies to any platform.
The issue documented here is limited in scope to 11g and newer releases.
The following errors are intermittently posted to the alert.log of a database instance that is at or newer than 11gR1. All releases that are newer than 11g would be affected.
ORA-609 Opiodr Aborting Process Unknown Ospid <nnnn>
ORA-609 Opiodr Aborting Process Unknown Ospid
The ORA-609 might be accompanied by either the TNS-12537, TNS-12637 or the TNS-12547 and might also include the following timeout messages:
Fatal NI connect error 12170.
TNS-12535: TNS:operation timed out
ns secondary err code: 12560
nt main err code: 505
This might be a new installation of the database. The ORA-609 error code was introduced in 11g. Also introduced in 11g is the ADR diagnostic method which results in TNS errors such as this to be thrown in the alert versus the sqlnet.log.
If this database has been in operation for a while, it is possible this error has arisen when an increase in the number of connections or workload has increased.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms