Thread: [cx-oracle-users] CentOS 5, Oracle 11g RPM Binary install - libclntsh.so.11.1:

Brought to you by: atuining

cx-oracle-users

[cx-oracle-users] CentOS 5, Oracle 11g RPM Binary install - libclntsh.so.11.1:

From: Jeff M. <je...@te...> - 2012-09-11 20:07:08

Hi,

I have a fully functional Oracle 11g server install. Its a 32bit machine running CentOS 5.8

I installed this : http://prdownloads.sourceforge.net/cx-oracle/cx_Oracle-5.1.2-11g-py24-1.i386.rpm?download

By doing "rpm -i cx_Oracle-5.1.2-11g-py24-1.i386.rpm"

Then as a regular user I set the following environment variables (i run source env.sh..)

[jmacdonald@devoracle python]$ cat env.sh 
ORACLE_BASE=/u01/app/oracle
ORACLE_SID=orcl
ORACLE_HOME=/u01/app/oracle/product/11.2.0.3/dbhome_1
PATH=$PATH:$ORACLE_HOME/bin
LD_LIBRARY_PATH=/u01/app/oracle/product/11.2.0.3/dbhome_1/lib/
export ORACLE_BASE ORACLE_SID ORACLE_HOME PATH LD_LIBRARY_PATH

Then when I run my teeny tiny testing script, I get the following:

[jmacdonald@devoracle python]$ python connect.py 
Traceback (most recent call last):
  File "connect.py", line 2, in ?
    import cx_Oracle
ImportError: libclntsh.so.11.1: cannot open shared object file: No such file or directory
[jmacdonald@devoracle python]$ locate libclntsh.so.11.1
/u01/app/oracle/product/11.2.0.3/dbhome_1/inventory/Scripts/ext/lib/libclntsh.so.11.1
/u01/app/oracle/product/11.2.0.3/dbhome_1/inventory/backup/2012-01-30_10-26-09PM/Scripts/ext/lib/libclntsh.so.11.1
/u01/app/oracle/product/11.2.0.3/dbhome_1/lib/libclntsh.so.11.1

I'm kinda stuck. Any suggestions?

Thanks

Re: [cx-oracle-users] CentOS 5, Oracle 11g RPM Binary install - libclntsh.so.11.1:

From: Dwayne K. <dw...@kr...> - 2012-09-11 20:15:53

I've had this in the past.  If I remember correctly, adding the
$ORACLE_HOME/lib to LD_LIBRARY_PATH fixed it

Since you're running 32 bit (having done this myself in a long time), check
to see if there's a lib32 directory underneath $ORACLE_HOME.  If so, you
may need to put that in LD_LIBRARY_PATH instead.

HTH

Dwayne



On Tue, Sep 11, 2012 at 3:54 PM, Jeff MacDonald <je...@te...> wrote:

> Hi,
>
> I have a fully functional Oracle 11g server install. Its a 32bit machine
> running CentOS 5.8
>
> I installed this :
> http://prdownloads.sourceforge.net/cx-oracle/cx_Oracle-5.1.2-11g-py24-1.i386.rpm?download
>
> By doing "rpm -i cx_Oracle-5.1.2-11g-py24-1.i386.rpm"
>
> Then as a regular user I set the following environment variables (i run
> source env.sh..)
>
> [jmacdonald@devoracle python]$ cat env.sh
> ORACLE_BASE=/u01/app/oracle
> ORACLE_SID=orcl
> ORACLE_HOME=/u01/app/oracle/product/11.2.0.3/dbhome_1
> PATH=$PATH:$ORACLE_HOME/bin
> LD_LIBRARY_PATH=/u01/app/oracle/product/11.2.0.3/dbhome_1/lib/
> export ORACLE_BASE ORACLE_SID ORACLE_HOME PATH LD_LIBRARY_PATH
>
> Then when I run my teeny tiny testing script, I get the following:
>
> [jmacdonald@devoracle python]$ python connect.py
> Traceback (most recent call last):
>   File "connect.py", line 2, in ?
>     import cx_Oracle
> ImportError: libclntsh.so.11.1: cannot open shared object file: No such
> file or directory
> [jmacdonald@devoracle python]$ locate libclntsh.so.11.1
> /u01/app/oracle/product/
> 11.2.0.3/dbhome_1/inventory/Scripts/ext/lib/libclntsh.so.11.1
>
> /u01/app/oracle/product/11.2.0.3/dbhome_1/inventory/backup/2012-01-30_10-26-09PM/Scripts/ext/lib/libclntsh.so.11.1
> /u01/app/oracle/product/11.2.0.3/dbhome_1/lib/libclntsh.so.11.1
>
> I'm kinda stuck. Any suggestions?
>
> Thanks
>
>
>
>
> ------------------------------------------------------------------------------
> Live Security Virtual Conference
> Exclusive live event will cover all the ways today's security and
> threat landscape has changed and how IT managers can respond. Discussions
> will include endpoint security, mobile security and the latest in malware
> threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
> _______________________________________________
> cx-oracle-users mailing list
> cx-...@li...
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>

Re: [cx-oracle-users] CentOS 5, Oracle 11g RPM Binary install - libclntsh.so.11.1:

From: Jeff M. <je...@te...> - 2012-09-12 16:31:58

See below, already done. Also, there isn't a lib32 directory anywhere.


Jeff.

On 2012-09-11, at 5:15 PM, Dwayne King <dw...@kr...> wrote:

> I've had this in the past.  If I remember correctly, adding the $ORACLE_HOME/lib to LD_LIBRARY_PATH fixed it
> 
> Since you're running 32 bit (having done this myself in a long time), check to see if there's a lib32 directory underneath $ORACLE_HOME.  If so, you may need to put that in LD_LIBRARY_PATH instead.
> 
> HTH
> 
> Dwayne
> 
> 
> 
> On Tue, Sep 11, 2012 at 3:54 PM, Jeff MacDonald <je...@te...> wrote:
> Hi,
> 
> I have a fully functional Oracle 11g server install. Its a 32bit machine running CentOS 5.8
> 
> I installed this : http://prdownloads.sourceforge.net/cx-oracle/cx_Oracle-5.1.2-11g-py24-1.i386.rpm?download
> 
> By doing "rpm -i cx_Oracle-5.1.2-11g-py24-1.i386.rpm"
> 
> Then as a regular user I set the following environment variables (i run source env.sh..)
> 
> [jmacdonald@devoracle python]$ cat env.sh
> ORACLE_BASE=/u01/app/oracle
> ORACLE_SID=orcl
> ORACLE_HOME=/u01/app/oracle/product/11.2.0.3/dbhome_1
> PATH=$PATH:$ORACLE_HOME/bin
> LD_LIBRARY_PATH=/u01/app/oracle/product/11.2.0.3/dbhome_1/lib/
> export ORACLE_BASE ORACLE_SID ORACLE_HOME PATH LD_LIBRARY_PATH
> 
> Then when I run my teeny tiny testing script, I get the following:
> 
> [jmacdonald@devoracle python]$ python connect.py
> Traceback (most recent call last):
>   File "connect.py", line 2, in ?
>     import cx_Oracle
> ImportError: libclntsh.so.11.1: cannot open shared object file: No such file or directory
> [jmacdonald@devoracle python]$ locate libclntsh.so.11.1
> /u01/app/oracle/product/11.2.0.3/dbhome_1/inventory/Scripts/ext/lib/libclntsh.so.11.1
> /u01/app/oracle/product/11.2.0.3/dbhome_1/inventory/backup/2012-01-30_10-26-09PM/Scripts/ext/lib/libclntsh.so.11.1
> /u01/app/oracle/product/11.2.0.3/dbhome_1/lib/libclntsh.so.11.1
> 
> I'm kinda stuck. Any suggestions?
> 
> Thanks
> 
> 
> 
> ------------------------------------------------------------------------------
> Live Security Virtual Conference
> Exclusive live event will cover all the ways today's security and
> threat landscape has changed and how IT managers can respond. Discussions
> will include endpoint security, mobile security and the latest in malware
> threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
> _______________________________________________
> cx-oracle-users mailing list
> cx-...@li...
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
> 
> ------------------------------------------------------------------------------
> Live Security Virtual Conference
> Exclusive live event will cover all the ways today's security and 
> threat landscape has changed and how IT managers can respond. Discussions 
> will include endpoint security, mobile security and the latest in malware 
> threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/_______________________________________________
> cx-oracle-users mailing list
> cx-...@li...
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users

Re: [cx-oracle-users] CentOS 5, Oracle 11g RPM Binary install - libclntsh.so.11.1:

From: James C. M. <Jam...@or...> - 2012-09-11 22:19:58

On 12/09/12 05:54 AM, Jeff MacDonald wrote:
> Hi,
>
> I have a fully functional Oracle 11g server install. Its a 32bit machine running CentOS 5.8
...
> [jmacdonald@devoracle python]$ cat env.sh
> ORACLE_BASE=/u01/app/oracle
> ORACLE_SID=orcl
> ORACLE_HOME=/u01/app/oracle/product/11.2.0.3/dbhome_1
> PATH=$PATH:$ORACLE_HOME/bin
> LD_LIBRARY_PATH=/u01/app/oracle/product/11.2.0.3/dbhome_1/lib/
> export ORACLE_BASE ORACLE_SID ORACLE_HOME PATH LD_LIBRARY_PATH
>
> Then when I run my teeny tiny testing script, I get the following:
...
> I'm kinda stuck. Any suggestions?

I think you need to have a copy of the lib in your ORACLE_HOME
as well as in $ORACLE_HOME/lib. That's the config I've got, which
appears to have been created by the instant client installer
(based on the timestamps).


James C. McPherson
--
Oracle
http://www.jmcpdotcom.com/blog

Re: [cx-oracle-users] CentOS 5, Oracle 11g RPM Binary install - libclntsh.so.11.1:

From: Jeff M. <je...@te...> - 2012-09-12 16:34:52

On 2012-09-11, at 7:19 PM, James C. McPherson <Jam...@or...> wrote:

> On 12/09/12 05:54 AM, Jeff MacDonald wrote:
>> Hi,
>> 
>> I have a fully functional Oracle 11g server install. Its a 32bit machine running CentOS 5.8
> ...
>> [jmacdonald@devoracle python]$ cat env.sh
>> ORACLE_BASE=/u01/app/oracle
>> ORACLE_SID=orcl
>> ORACLE_HOME=/u01/app/oracle/product/11.2.0.3/dbhome_1
>> PATH=$PATH:$ORACLE_HOME/bin
>> LD_LIBRARY_PATH=/u01/app/oracle/product/11.2.0.3/dbhome_1/lib/
>> export ORACLE_BASE ORACLE_SID ORACLE_HOME PATH LD_LIBRARY_PATH
>> 
>> Then when I run my teeny tiny testing script, I get the following:
> ...
>> I'm kinda stuck. Any suggestions?
> 
> I think you need to have a copy of the lib in your ORACLE_HOME
> as well as in $ORACLE_HOME/lib. That's the config I've got, which
> appears to have been created by the instant client installer
> (based on the timestamps).


Copying libclntsh.so.11.1 to the $ORACLE_HOME worked.  Thanks!

jeff.



> 
> 
> James C. McPherson
> --
> Oracle
> http://www.jmcpdotcom.com/blog