Hi All,

We are getting below error while one of the ODBC connection try to connect to the Database.

Linux Server is Red Hat 64 bit environment.

[6/1/07 14:29:55:315 CDT] 00000034 SystemOut O UserId:APCTEVAL ServiceName:NbaContractEvaluationBP DEBUG [QuartzScheduler_Worker-51] (com.csc.dip.jvpms.core.JvpmsLog4j:debug:?) - compute P_Result => ReturnCode: 1 Message: [unixODBC][Driver Manager]Can't open lib '/opt/oracle/instantclient/libsqora.so.10.1' : /opt/oracle/instantclient/libsqora.so.10.1: cannot open shared object file: No such file or directory RefField: sue

Here is the current set of things that we verified

1. The .bash_profile for root has the right stuff in it

export ORACLE_HOME=/opt/oracle/instantclient
export PATH=$ORACLE_HOME:$PATH
export LD_LIBRARY_PATH=/opt/nba/bin:$ORACLE_HOME:$LD_LIBRARY_PATH
export TNS_ADMIN=$ORACLE_HOME

2. We verified that the correct version of the Oracle ODBC drivers are installed
-r--r--r-- 1 oracle dba 1545954 Dec 20 09:35 ojdbc14.jar
-rwxr-xr-x 1 oracle dba 137905 Dec 20 09:35 libocijdbc10.so
-rwxr-xr-x 1 oracle dba 72456247 Dec 20 09:35 libociei.so
-rwxr-xr-x 1 oracle dba 1664148 Dec 20 09:35 libocci.so.10.1
-rwxr-xr-x 1 oracle dba 3808761 Dec 20 09:35 libnnz10.so
-rwxr-xr-x 1 oracle dba 20870419 Dec 20 09:35 libclntsh.so.10.1
-rwxr-xr-x 1 oracle dba 66545 Dec 20 09:35 genezi
-r--r--r-- 1 oracle dba 1600090 Dec 20 09:35 classes12.jar
-rwxr-xr-x 1 oracle dba 7741 Dec 20 09:35 sqlplus
-r--r--r-- 1 oracle dba 3457 Dec 20 09:35 odbc_update_ini.sh
-r-xr-xr-x 1 oracle dba 58416 Dec 20 09:35 ODBCRelnotesUS.htm
-r-xr-xr-x 1 oracle dba 91881 Dec 20 09:35 ODBCRelnotesJA.htm
-r--r--r-- 1 oracle dba 21548 Dec 20 09:35 ODBC_IC_Readme_Linux.html
-rwxr-xr-x 1 oracle dba 859868 Dec 20 09:35 libsqora.so.10.1
-rwxr-xr-x 1 oracle dba 992929 Dec 20 09:35 libsqlplus.so
-rwxr-xr-x 1 oracle dba 1435529 Dec 20 09:35 libsqlplusic.so
-r--r--r-- 1 oracle dba 1525 Dec 20 09:35 glogin.sql
-rw-r----- 1 oracle dba 475 May 31 16:06 sqlnet.ora
-rw-r--r-- 1 oracle dba 385 May 31 16:06 ldap.ora


in the /opt/oracle/instantclient directory

3. We verified the the odbc.ini and the odbcinst.ini..they match our dev files



4. We verified that the VPMS so are the same version
-rwxrwxr-x 1 nbaadmin nbaadmin 9333 Feb 13 07:57 libjvpms.so
-rw-r--r-- 1 nbaadmin nbaadmin 1339 Feb 13 07:57 nbaSetupCmdLine.sh
-rw-r--r-- 1 nbaadmin nbaadmin 852 Feb 13 07:57 nbaLaunchClient.sh
-rw-r--r-- 1 nbaadmin nbaadmin 327 Feb 13 07:57 nbaAdministrativeConsole.sh
-rwxrwxr-x 1 nbaadmin nbaadmin 265657 Feb 13 07:57 libvpms.so
-rwxrwxrwx 1 nbaadmin nbaadmin 594 Feb 13 12:58 odbcinst.ini
-rwxrwxrwx 1 nbaadmin nbaadmin 874 Feb 13 12:58
odbc.ini


5. We also verifed that the directories were showing up in the JVM start up log to verify WAS startup
************ Start Display Current Environment ************
WebSphere Platform 6.0 [ND 6.0.2.17 cf170648.10] running with process name SyststNBACell01\SyststNBANode01\sysNBANewBusiness1 and process id 4921
Host Operating System is Linux, version 2.6.9-42.0.3.ELsmp
Java version = J2RE 1.4.2 IBM build cxia32142-20060421 (SR5) (JIT enabled: jitc), Java Compiler = jitc, Java VM name = Classic VM
was.install.root = /opt/WebSphere/AppServer60
user.install.root = /opt/WebSphere/AppServer60/profiles/SyststNBANode01Profile
Java Home = /opt/WebSphere/AppServer60/java/jre
ws.ext.dirs = /opt/WebSphere/AppServer60/java/lib:/opt/WebSphere/AppServer60/profiles/SyststNBANode01Profile/classes:/opt/WebSphere/AppServer60/classes:/opt/WebSphere/AppServer60/lib:/opt/WebSphere/AppServer60/installedChannels:/opt/WebSphere/AppServer60/lib/ext:/opt/WebSphere/AppServer60/web/help:/opt/WebSphere/AppServer60/deploytool/itp/plugins/com.ibm.etools.ejbdeploy/runtime:/opt/nba/runtimeJars
Classpath = /opt/WebSphere/AppServer60/profiles/SyststNBANode01Profile/properties:/opt/WebSphere/AppServer60/properties:/opt/WebSphere/AppServer60/lib/bootstrap.jar:/opt/WebSphere/AppServer60/lib/j2ee.jar:/opt/WebSphere/AppServer60/lib/lmproxy.jar:/opt/WebSphere/AppServer60/lib/urlprotocols.jar:/opt/nba/configuration/config
Java Library path = /opt/WebSphere/AppServer60/java/jre/bin:/opt/WebSphere/AppServer60/java/jre/bin/classic:/opt/WebSphere/AppServer60/java/jre/bin:/opt/WebSphere/AppServer60/bin:/opt/mqm/java/lib:/opt/wemps/lib:/opt/nba/bin:/opt/oracle/instantclient:/usr/lib
************* End Display Current Environment *************



But are still getting the following error

[6/1/07 14:29:55:315 CDT] 00000034 SystemOut O UserId:APCTEVAL ServiceName:NbaContractEvaluationBP DEBUG [QuartzScheduler_Worker-51] (com.csc.dip.jvpms.core.JvpmsLog4j:debug:?) - compute P_Result => ReturnCode: 1 Message: [unixODBC][Driver Manager]Can't open lib '/opt/oracle/instantclient/libsqora.so.10.1' : /opt/oracle/instantclient/libsqora.so.10.1: cannot open shared object file: No such file or directory RefField: sue

Thanks in advance

Mitesh