I want to configure the Enterprise Dashboard database to be able to use Oracle. I followed the article:
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.
Release : 10.6
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:
I should write:
By correcting that, I was able to setup properly Enterprise Dashboard. We can close this ticket.