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

Products

• Service Virtualization

Issue/Introduction

Want to configure the Enterprise Dashboard database to be able to use Oracle. 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 being used has the create view system privilege and the Oracle was installed with UTF8 encoding.  Tested the connection inside DbVisualizer and was successful.

Cause

TNSNAMES.ORA file had an incorrect value in it.

Environment

All supported releases and platforms of DevTest.

Resolution

TNSNAMES.ORA file had an incorrect value for SID and Servicename in it for the database is pointing to.  

 

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

Should be

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