Symptom
- During connection to Oracle, the following message appears in the workprocess trace:
C OCIServerAttach(OCI_DEFAULT) failed with SQL error 12170:
C ORA-12170: TNS:Connect timeout occurred
C *** ERROR => CONNECT failed with sql error '12170'
[dbsloci.c 15455]
- Alert log shows error messages similar to the following:
Fatal NI connect error 12170.
TNS-12535: TNS:operation timed out
ns secondary err code: 12560
nt main err code: 505
TNS-00505: Operation timed out
nt secondary err code: 110
nt OS err code: 0
OR
Fatal NI connect error 12537, connecting to:
(LOCAL=NO)
TNS-12537: TNS:connection closed
ns secondary err code: 12560
nt main err code: 0
nt secondary err code: 0
nt OS err code: 0
opiodr aborting process unknown ospid (<pid>) as a result of ORA-609
Read more...
Environment
- Oracle RDBMS any version
- Not restricted to any SAP Product
- Operating System independent
Product
SAP NetWeaver all versions
Keywords
ORA, 12170, TNS, 12535, 12537, 19c, 12c, 11g, 10.2 , KBA , BC-DB-ORA , Oracle , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.