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

Search for additional results

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