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.
All supported releases and platforms of DevTest.
TNSNAMES.ORA file had an incorrect value in it.
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]