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 RDBMS any version
  • Not restricted to any SAP Product
  • Operating System independent

Product

SAP NetWeaver all versions

Keywords

ORA-12170, TNS-12535, connection timeout, network error, TNS, oracle connection, TNS:connect timeout, network issue, listener, connectivity problem, network latency, TNS configuration, sqlnet.ora, tnsnames.ora, connection refused, network unreachable, client connectivity, troubleshooting, database network , 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.