LinuxQuestions.org
Visit Jeremy's Blog.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.

Notices


Reply
  Search this Thread
Old 06-03-2007, 12:35 AM   #1
mitesh
LQ Newbie
 
Registered: Aug 2006
Posts: 1

Rep: Reputation: 0
Linux Environment : Can't open lib '/opt/oracle/instantclient/libsqora.so.10.1


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
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
LXer: Opinion: Microsoft, Sun, Oracle can't sidestep Linux, open source ... LXer Syndicated Linux News 0 11-04-2006 06:03 PM
LXer: Blue-chip multinationals opt for open source LXer Syndicated Linux News 0 08-18-2006 08:33 PM
LXer: Open ENTERPRISE: Oracle: The biggest Linux vendor you've never ... LXer Syndicated Linux News 0 06-14-2006 04:03 AM
LXer: Oracle Leverages Itself into Major Open Source Components including Sendmail, Apache, Linux LXer Syndicated Linux News 0 02-15-2006 10:31 AM
How to Startup Oracle Listener In the Linux Cluster Environment research2004 Linux - Enterprise 1 05-01-2004 11:30 PM

LinuxQuestions.org > Forums > Linux Forums > Linux - Software

All times are GMT -5. The time now is 02:48 PM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration