ORA-12505, TNS:listener does not currently know of SID given in connect descriptor in dashboard_engine log

Document ID : KB000035397
Last Modified Date : 04/02/2019
Show Technical Document Details
Issue:

I am having difficulty getting my dashboard_engine to connect to Oracle
 

The data_engine.log entries such as these:

Jan 27 13:51:57:766 ERROR [main, GenericDBProvider:47] Failed to log connection information: Listener refused the connection with the following error:
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor

Jan 27 13:52:00:124 INFO [main, DashboardConfiguration:1101] JDBC connection URL template: jdbc:oracle:thin:{1}/{2}@{0}:{7}:{3}

Environment:

This is general information applicable to most versions of UIM.

Resolution:
The probe is coded to use a template to build the connection string.  The default template is:

jdbc:oracle:thin:{1}/{2}@{0}:{7}:{3}

This template may not work in the your environment.

You can specify your own template in dashboard_engine.cfg by adding the following parameter to the <data> section of the file:

jdbc_url_template = jdbc:oracle:thin:{1}/{2}@//{0}:{7}/{3}

The available parameters in braces have the following meaning:
Data Source/Server Name = {0}
User ID/User Name = {1}
Password = {2}
Initial Catalog/Database Name = {3}
Network Library = {4}
Language = {5}
Integrated Security=SSPI true/false = {6}
Port (Oracle) = {7}


When the probe builds the actual connection string from this template, it populates the values for these parameters by querying data_engine probe.