SAP Knowledge Base Article - Preview

2247709 - ORA-12560 in sqlplus

Symptom

1. A logon to the oracle database with sqlplus fails with ORA-12560: TNS:protocol adapter error

KBA5_sqlplus.JPG

2. In the DBA Planning Calendar (DB13) scheduled jobs (backup, statistic creation, etc.) are failing with the following error:

BR0301W SQL error -12560 at location BrDbConnect-2, SQL statement:
'CONNECT /'
ORA-12560: TNS:protocol adapter error

KBA5_DB13.JPG


Read more...

Environment

Windows 2008 R2

Oracle 11g

SAP Netweaver 7.0 and higher

Product

SAP NetWeaver 7.0 ; SAP NetWeaver 7.3 ; SAP NetWeaver 7.4 ; SAP NetWeaver 7.5 ; SAP enhancement package 1 for SAP NetWeaver 7.0 ; SAP enhancement package 1 for SAP NetWeaver 7.3 ; SAP enhancement package 2 for SAP NetWeaver 7.0 ; SAP enhancement package 3 for SAP NetWeaver 7.0

Keywords

TNS-12518, TNS-12560, TNS-00530, nt main err code: 530, nt secondary err code: 258, The wait operation timed out, sqlplus, CONNECT / , 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.