ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

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


Article ID: 35397


Updated On:


DX Unified Infrastructure Management (Nimsoft / UIM) NIMSOFT PROBES


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}


This is general information applicable to most versions of UIM.


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


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.