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 ?
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.
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.
First we saw that Oracle Client was needed on the server as we were trying to connect to Cluster.
The JDBC Adpater seeked only for Oracle Client 10.0.2.
The client was not available for download but we had an instant client of version 10 with needed ocijdbc10 and dependent files.
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.