ocijdbc14 jar error in webm 9.5

Hi all,

We were trying to do a connection test for Prod env DB in oracle 11g which has a cluster.
We got the following error
Error encountered
[ART.118.5042] Adapter Runtime (Connection): Unable to enable connection resource AP_CSM.Adapter.Connections:jdbcConnectionCSM.
[ART.118.5063] Adapter Runtime (Connection): Unable to start connection AP_CSM.Adapter.Connections:jdbcConnectionCSM: after 1 attempt(s).
no ocijdbc10 in java.library.path

No ocijdbc10.

the prev version webm 7,1 connects to the same DB and we have all jars in the new env too.
Is there any other place we need to do any thing ?

Regrads,
Priya

What is your new IS version?

I believe incase it is IS822 should connect fine to Oracle 11g R2…

Is it a IS JDBC pool are you configuring or JDBC Adapter connection and if yes can you try with driveType=thin

HTH
RMG

As per the error message it says ocijdbc10 is missing…

Make sure you don’t have spaces at the leading and trailing while configuring the JDBC adapter in IS

Also share the screen shot of your connection page.

We usually place the JARs in IntegrationServer/lib folder and sometimes inside WmJDBC Adapter package too…

Can you list the JAR that you have under IntegrationServer/lib?

Did you restart the IS after placing the appropriate JARS.

As per error message it is a JDBC-Adapter connection.

As already suggested by RMG and Mahesh you should use driverType=thin, which will work without having the native OCI portion available.

As wM 9.5 is running in JVM 1.7 you should use a ojdbc6.jar or ojdbc7.jar available from OTN (Oracle Technology Network). You will need to register there for free.

Here is the Link to the downloads section of OTN:
http://www.oracle.com/technetwork/indexes/downloads/index.html

Additionally you should have a look a 6-5_JDBC_Adapter_Install_and_Users_Guide.pdf available from http://techcommunity.softwareag.com/ecosystem/communities/public/_communities/documentation

For the case that you really need the OCI variant, there needs to be an oci*.dll or oci*.so (depends on OS), which should be placed under IntegrationServer/lib.
Remember to restart the server afterwards.

Good Luck.

Regards,
Holger

Hi,

I suspect, as there is no change in DB, issue might persists with Path. Kindly check and let us know needed corrections and let us know the update.

Thanks,

Hi All,

Have resolved it the following way:

  1. First we saw that Oracle Client was needed on the server as we were trying to connect to Cluster.
  2. The JDBC Adpater seeked only for Oracle Client 10.0.2.
  3. The client was not available for download but we had an instant client of version 10 with needed ocijdbc10 and dependent files.
  4. We created a CLASAPATH to the folder containing these files and the connection worked.

PS: The jars files were already copied during installation.But in the test env, there was just one DB to connect to.
But tomorrow we are going live, and we are pointing the servers to Live DBs.
So when we did the check yestaerday, we found the issue while connecting to PROD cluster.

All is well, as of now :slight_smile:

Thanks,
Priya

OK sounds good…glad to hear issue resolved and the update

HTH,
RMG