AnsweredAssumed Answered

PPOracleDB.properties entries for connecting to 2 node oracle RAC cluster?

Question asked by binja01 Employee on Aug 2, 2017
Latest reply on Aug 3, 2017 by binja01

Hi Folks,

 

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.

Outcomes