I assume you are trying to connect to Oracle RAC.

did you check the tnsnames.ora file? after upgrade you need to manually restore it....

Hi Asaf,

Thanks for the reply.

Yes we restored the tnsnames.ora file also we restored jdbc.properties file as well.

Regards,

Pranav R N

Hi Asaf,

Thanks for the reply.

Yes we restored the tnsnames.ora file also we restored jdbc.properties file as well.

Regards,

Pranav R N

then please submit support case for further investigation.

Hi Pravan,

as you never posted that the issue has been resolved I thought I'll give it a shot:

there was a change from APM 9.51 to APM 9.60

9.5x
====
<HPBSM>\conf\jdbc.drivers.properties

ddoracle.class=com.mercury.jdbc.oracle.OracleDriver
ddoracle.url=jdbc:mercury:oracle:TNSNamesFile=E:\\HPBSM\\conf\\bsm-tnsnames.ora;TNSServerName=${sid}

<HPBSM>\conf\\bsm-tnsnames.ora
TOPAZI =(DESCRIPTION =(ADDRESS =(PROTOCOL = TCP)(Host = myhost.mydomain.mycom)(Port = 1234))
(CONNECT_DATA =(SERVICE_NAME = APM)(SERVER = DEDICATED)))

<HPBSM>\odb\conf\jdbc.properties

Oracle = ddoracle
cmdb.url =jdbc:mercury:oracle:TNSNamesFile=E:\\HPBSM\\conf\\bsm-tnsnames.ora;TNSServerName=APM

9.60
====
- mcoracle.jar no longer exists in folder <HPBSM>\lib
thus the path has to be changed
from for example
ddoracle.class=com.mercury.jdbc.oracle.OracleDriver
to for example
ddoracle.class=oracle.jdbc.driver.OracleDriver

Also the file TNSNamesFile is no longer being used, the data is now passed directly via ddoracle.url

OOTB
<HPBSM>\conf\jdbc.drivers.properties

old
ddoracle.url=jdbc:oracle:thin:@${host}:${port}:${sid}

new
ddoracle.url=jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=myhost.mydomain.mycom)(PORT=1234))(LOAD_BALANCE=off)(FAILOVER=off))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=APM)))

also you need to perform the similar steps for ODB / RTSM:

<HPBSM>\odb\conf\jdbc.properties
doesn't exist on a new APM 9.60 installation, you hopefully can copy if it from your still around 9.51 installation and then modify it:

old

Oracle = ddoracle
cmdb.url =jdbc:mercury:oracle:TNSNamesFile=E:\\HPBSM\\conf\\bsm-tnsnames.ora;TNSServerName=APM

new
Oracle = ddoracle
cmdb.url=jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=myhost.mydomain.mycom)(PORT=1234))(LOAD_BALANCE=off)(FAILOVER=off))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=APM)))

Greetings
Siggi

P.S. The kudos go to ChristianD who disovered this ;-)-