Download and extract the utility attached to this solution article to a temporary directory, please follow the below steps:
 

1. Define JAVA_HOME to point to JRE 7 or higher
   1. For example the Java used with BMC_INST_JAVA_HOME
   2. Or for versions prior to 9.0.21, the JRE supplied with the Control-M install (eg: $EM_HOME/ctm_em/JRE)
2. Change directory(cd) to the extracted 'utils' directory from the attached utility.
3. Executes './run.sh'
4. It will invoke utility and display the Main Menu:
   • Main menu
   • --------
   • 1) Database connection
   • 2) Run query
   • 3) Properties
   • Press 'q' to quit
5. Now choose 1 and it will display
   • Connection menu
   • ---------------
   • 1) Database type...      CHOOSE
   • 2) Connection string:    jdbc:oracle:thin:@{Oracle Database Host}:{Oracle listening port}/{Oracle Service Name}
   • 3) Username:             system
   • 4) Password:
   • 5) Driver path:        /opt//emuser/ctm_em/classes/ojdbc8.jar
   • 6) Driver class:         oracle.jdbc.driver.OracleDriver
   • 7) Query:                SELECT 1 FROM DUAL
   • 8) Test connection
6. Now choose 1 and choose Oracle
7. Choose 2 and input Database host, Port ,and Service Name of the ORACLE server. Take note of the '/' after Oracle listening port.
8. Choose 3 and enter the username of the Oracle Admin user
9. Choose 4 and enter the password of the Oracle Admin user
10. Choose 5 and set path to ojdbc8.jar or ojdbc version that comes with the product installation.
11. Choose 8 to test connection

Note for Linux machines:

In the run.sh script, the script first checks if the OS has java available.  It will only use JAVA_HOME if the OS does not have a default java.  If the OS java is too high, like 21, this utility will not work as expected.  In this scenario, the following command can be ran from the utils directory instead

<full path to java that you want to use> -Xnoagent -Xrunjdwp:transport=dt_socket,address=8787,server=y,suspend=n -cp ./.jar com.bmc.util.jdbcUtil.MainUtility $

For example 

/temp/installLocation/Setup_files/JRE/bin/java -Xnoagent -Xrunjdwp:transport=dt_socket,address=%A_PORT%,server=y,suspend=n -cp ./.jar com.bmc.util.jdbcUtil.MainUtility $

Additionally, for the ojdbcx.jar file, it is ideal to use the jar file from <install package>/Setup_files/lib