jdbc response probe failed to start after creating oracle database connection

Document ID : KB000093642
Last Modified Date : 01/05/2018
Show Technical Document Details
Introduction:
A connection profile to an Oracle 11g database was created using the following connection values:

Database URL:  jdbc:oracle:thin:@(description=(address=(protocol=tcp)(host=<database hostname>)(Port=<port>))(connect_data=(service_name=<databse name>)))
User:  <user name> as sysdba
Password::  <valid password for the specified user>

The connection test passed, but when this connection was used in an active monitoring profile, the probe never connected to the database and eventually failed.
Question:
What are the valid strings that can be used for the Database URL and User components of a connection profile in the jdbc_response probe in order to monitor an Oracle database?
Environment:
UIM Server:  8.51
jdbc_response : 1.24
Answer:
Valid form of the Database URL:

jdbc:oracle:thin:@IP address:Port Number/Database Name
jdbc:oracle:thin:@database server name:Port Number/Database Name


Valid forms for the connection User name:

<user name>
<user name> as sysdba
Additional Information: