cancel
Showing results for 
Search instead for 
Did you mean: 

how to install OJDBC driver for oracle in PI7.1

Former Member
0 Kudos

Hi,

I am getting the following error for JDBC adapter communication .

Error during database connection to the database URL 'jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=x.x.x.x)(PORT=x.x.x.x)))(CONNECT_DATA=(SERVICE_NAME=cpuerp)(SERVER=dedicated)))' using the JDBC driver 'JDBC DRIVER: oracle.jdbc.driver.OracleDriver': 'com.sap.aii.adapter.jdbc.sql.DriverManagerException: Can not establish connection:: SAPClassNotFoundException: JDBC DRIVER: oracle.jdbc.driver.OracleDriver'

Would like to install the OJDBC14.jar for oracle in PI 7.1 Can anybody help to let me know how to install the OJDBC.jar file in PI7.1?

Thanks

Regards

suk4023

Accepted Solutions (0)

Answers (5)

Answers (5)

Former Member
0 Kudos

Hi,

SAPClassNotFoundException: oracle.jdbc.driver.OracleDriver' --> This error clearly implies that the OracleDriver has not been installed properly on your XI server.

Follow this..

JDBC Driver Deployment Guide...

http://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/70ffd890-0201-0010-708f-d5dad2dfc...

Regds,

Pinangshuk.

Former Member
0 Kudos

Hi,

The Basis would like to have the document for installation of ojdbc14.jar file on AIX server. All documents are for windows server..Can anybody give the installation procedure for installation of ojdbac14.jar file on the AIX server ...........

Thanks

Regards

suk4023

Former Member
0 Kudos

Hi Sukande,

Deployment procedure is same irrespective of operating system.

On AIX, you have to copy the file com.sap.aii.adapter.lib.sda to your desktop and modify using winrar as explained in the below article and copy the modified file back to the respective path on AIX server.

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/00b4a020-4ae6-2c10-5a95-fed4ad9a4...

Thanks,

Siva Kumar

Former Member
0 Kudos

If you have multiple server nodes, make sure the file com.sap.aii.adapter.lib.sda exists on all nodes.

This should happen automatically through synchronisation. On PI 7.0 i once had a problem where this did not work

and the file was only availabe on one node.

Former Member
0 Kudos

Hi

Have you deployed the com.sap.aii.adapter.lib.sda and Java will restart during the update. Make sure the JDBC JAR files exist in the com.sap.aii.adapter.lib.sda and also check the deploy log for errors.

Thanks

Kiran Nekkanti

Former Member
0 Kudos

Hi ,

The oracle jdbc driver (OJDBC14.jar) is installed but still the problem persist. Any other solution......???

Regards

suk4023

prateek
Active Contributor
0 Kudos

If it is the same error, then it would mean that the drivers are not yet installed correctly. Redo the process.

Regards,

Prateek

GabrielSagaya
Active Contributor
0 Kudos

Please refer to sap note 831162

Check whether the JDBC driver deployment ojdbc14.jar is performed using a special SDA file named com.sap.aii.adapter.lib.sda correctly

prateek
Active Contributor
0 Kudos