I want to understand as to how do we configure PowerPack for Oracle Database APM agent for Oracle RAC databases?
We have a 2 node Oracle 12cR2 RAC cluster and the JDBC connection string goes something like this:
(DESCRIPTION= (RETRY_COUNT = 2)(CONNECT_TIMEOUT = 3) (ADDRESS_LIST= (LOAD_BALANCE=off)
(FAILOVER=on) (ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.12.52)(PORT = 1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.12.62)(PORT = 1521)) (CONNECT_DATA= (SERVER = DEDICATED)
(SERVICE_NAME = tmsrv) ))
I tried providing the hostname/port/servicename entries as per the PPOracleDB.properties file comments.
Unfortunately, this doesn't work and I always get the "Service cannot identify the connect identifier specified" error.
I have a java app using JDBC to connect to the same RAC DB on the same host and it is able to connect if we provide the JDBC URL given above.
Need to know the exact configuration which needs to be provided for connecting to Oracle RAC DB as given above.