Configuring Enterprise Dashboard Database - ORA-12505, TNS:listener does not currently know of SID given in connect descriptor

book

Article ID: 224925

calendar_today

Updated On:

Products

Service Virtualization

Issue/Introduction

I want to configure the Enterprise Dashboard database to be able to use Oracle. I followed the article:

https://techdocs.broadcom.com/us/en/ca-enterprise-software/devops/devtest-solutions/10-6/administering/database-administration/external-enterprise-dashboard-database-configuration.html#

and get the following error:

[main] ERROR org.hibernate.hql.spi.id.IdTableHelper - Unable to use JDBC Connection to create Statement
org.apache.commons.dbcp.SQLNestedException: Cannot create PoolableConnectionFactory (Listener refused the connection with the following error:
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor

The oracle user which I use has the create view system privilege and the Oracle was installed with UTF8 encoding. Please find in attachment the enterprise dashboard logfile. Also, I tested the connection inside DbVisualizer and was successful.

Environment

Release : 10.6

Component :

Resolution

TNSNAMES.ORA file had and incorrect value it in it for the database he was pointing to.  He discussed this with his DBA and this was the result:

 

lisadb.pool.common.url=jdbc:oracle:thin:@[HOST]:1521:[SID]

 

I should write:

 

lisadb.pool.common.url=jdbc:oracle:thin:@[HOST]:1521/[SID]

 

By correcting that, I was able to setup properly Enterprise Dashboard. We can close this ticket.