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>:usrsap<SID> JC|DVEBMGSj2ee... (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