How to find XI server has oracle driver installed or not ?

[Former Member]

Dear all,

Please provide me steps to find if XI server is having oracle driver installed or not for JDBC activities.

Thanks

Gauarv

[Former Member]

I found Driver is not present. But folder level access is not present for me.!!!

[Former Member]

Did you find resolution to this ?

I installed this using the howto guide on SDN. packaged using drivertool and then depoyed using SDM.

Getting the same error as above..

I checked all the things mentioned in this message, everything looks ok to me.

Thx

MFB

[Former Member]

HI

I am not able to connect

Error when attempting to get processing resources: com.sap.aii.af.service.util.concurrent.ResourcePoolException: Unable to create new pooled resource: DriverManagerException: Cannot establish connection to URL 'jdbc:oracle:thin:@usrnsplmp012.palm.com:1521:PCART': SAPClassNotFoundException: oracle.jdbc.driver.OracleDriver

Thanks

Gaurav

[Former Member]

It seems driver is not installed properly. Ask XI Basis person to check for you.

- Pinkle

[Former Member]

HI

I dont have access to Visual Admin as well as usr/sap folder..

In this situation what all options i have..

Thanks

Gaurav

[Former Member]

Try configuring JDBC comm channel and send data. See whether you are getting any error or success.

- Pinkle

[Former Member]

Hi Gauarv,

The easy way is copy aii_af_jmsproviderlib.sda file from

\usr\sap\PX6\DVEBMGS01\SDM\root\origin\sap.com\com.sap.aii.af.jmsproviderlib\SAP AG\3\7.0009.20060728142055.0000

Rename .sda to .zip and open the file. if you can see file ojdbc14.zip meaning your XI server already installed with oracle jdbc driver.

Regards

Fernand

[Former Member]

HI Gaurav,

Follow the steps:

Go to Visual admin:

1) chose table cluster->server->libraries->com.sap.aii.af.jmsproviderlib

2) Check in window jar container,if JMS/JDBC libraries are uploaded correctly

3) Look ar jars contained

3) look at \usr\sap\<sysID>\JCOO\j2ee\cluster\server-\bin

Also check the deployment in Visual Admin

1) choose tab cluster->server->service->classloader viewer

2_ Look tab in runtime component-> libraries-> com.sap.aii.af.jmsproviderlib for JDBC/JMS lib.

Thnx

Chirag Gohil