Can not establish connection Oracle DB

[Former Member]

Hi PI Gurus,

We have a sender JDBC CC, its working absolutely fine in PI dev.

when I check this CC in PI Qality it is giving me error as:

Error during database connection to the database URL 'jdbc:oracle:thin:@204.145.15.141:1521:PERM' using the JDBC driver 'oracle.jdbc.driver.Oracledriver': 'com.sap.aii.adapter.jdbc.sql.DriverManagerException: Can not establish connection:: SAPClassNotFoundException: oracle.jdbc.driver.Oracledriver'

It clearly says that driver is not installed, thats why connection is not getting established. Our BASIS team installed the drivers twice copied from Dev systems, still the same error is coming.

Can anyone throw some light on this, is any problem with the version?

Thanks,

Krishna

[Former Member · Accepted solution]

Hi Krishna,

Can you check two things:

1. whether the host name of the jdbc server u are tryin to access is present in the PI Quality system hosts file

2. Whether connectivity port is correctly opened with the jdbc server, i.e connectivity exists and is tested.

Regards,

Souvik

[Former Member]

Thanks to all of you..

when I changed oracle.jdbc.driver.OracleDriver

from

oracle.jdbc.driver.Oracledriver

it worked. I dont understand then how come it is still working in PI-Dev.

Thanks,

Krishna

[Former Member]

Looks like typo

try oracle.jdbc.driver.OracleDriver instead of oracle.jdbc.driver.Oracledriver in comm channel definition.

Regards,

Pinkle