Skip to Content
author's profile photo
Former Member

Can not establish connection Oracle DB

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

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

3 Answers

  • Best Answer
    author's profile photo
    Former Member
    Posted on May 04, 2011 at 06:37 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    Posted on May 04, 2011 at 06:35 AM

    Looks like typo

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

    Regards,

    Pinkle

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    Posted on May 04, 2011 at 07:05 AM

    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

    Add comment
    10|10000 characters needed characters exceeded