How to test the Oracle database connection from SAP System

Purpose

This article will show you how to test the Oracle database connection from SAP system.

Overview

In case of SAP system was failed to startup with unknown reason. You can follow the methods below to troubleshoot if the problem caused by database connection or not.

Methods

1. For the ABAP stack system, you can execute the command: “R3trans –dx” under OS user <sid>adm to test if the database connection is working fine.  

              

If the R3trans finished with return code (0000), it means the database connection is connected without error.

If the R3trans finished with return code (0012), it means the database connection is not connected successfully. In this case, please check the trans.log for any database error.

Please note:

The trans.log which will be generated under the current the directory you execute this command.

2. For Java stack system, please follow SAP note 867176, point 8 to test if the database connection is connected using the JDBC under OS user <sid>adm. Also, you can use this method to determine the JDBC driver version installed in your system.

Command:

Windows

      java -classpath <path to driver>/<driver filename>;. JdbcCheckup

  UNIX/Linux

      java -classpath <path to driver>/<driver filename>:. JdbcCheckup

Please note:

• The location and driver name (<path to driver>/<driver filename>) is set in property rdbms. driverLocation under the config.properties file. This  config.properties file generally stored under directory /usr/sap/<SID> /JC|DVEBMGS/j2ee/configtool (UNIX) and  <DRIVE>:\usr\sap\<SID> \JC|DVEBMGS\j2ee\... (Windows).

• The program request the information needed to connect to the database ( username, password, TNSNAME entry, hostname and listener port ). The required information can be found on the Secure Store in ConfigTool:

-       jdbc/pool/ME1/User

-       jdbc/pool/ME1/Password

-       jdbc/pool/ME1/Url (DB server, port, SID are here)

 

If the database connection is successful, it will return status “Connected”. The JDBC driver version in your system is 10.2.0.5.

If the database connection is unsuccessful, it will return status “Exception in thread “main” java.sql.SQLException” with error code, example: ORA-01017.

Related SAP Notes/KBAs

SAP Note 867176- FAQ: Oracle JDBC