SAP Knowledge Base Article - Preview

2152158 - Intermittent Oracle connectivity issue

Symptom

The database connection is lost and cannot be reestablished. You receive ORA-03114 and ORA-03113 combined with DBIF_REPO_SQL_ERROR dumps in the SAP session.

In the logs you see the following messages:

TNS-12542: TNS:address already in use
 TNS-12560: TNS:protocol adapter error
  TNS-00512: Address already in use
   Linux Error: 98: Address already in use

The line in the bottom may vary according to your operating system.


Read more...

Environment

  • SAP systems with Oracle database
  • Not restricted to a product or product version
  • Any Linux or Unix Operating System

Product

SAP NetWeaver 2004 ; 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

connectivity, shortdump, dump, network, lsnrctl, tnslsnr, end-of-file, communication, channel, not, connected , KBA , BC-DB-ORA , Oracle , BC-DB-ORA-RAC , Real Application Clusters (RAC) , 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.