1911531 - ORA-12170 or TNS-12535 during connection to Oracle | SAP Knowledge Base Article

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, 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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.