SAP Knowledge Base Article - Preview

1911531 - ORA-12170 or TNS-12535 during connection to Oracle

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 database
  •  SAP release independent
  •  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.