ImportError: libclntsh.so.10.1: cannot open shared object file: Permission denied

[gmax2006]

Hi,

I am using RedHat Linux 4. and I developed an oracle 10g based
application by using cx_Oracle (cx_Oracle-4.1-10g-py23-1.i386.rpm) and
Python 2.3.4.

When I run the application through direct console connection, It works
perfect.

But, when I schedule a crontab job to run the application, It logs this
error:

Traceback (most recent call last):
File "/home/nsm1/NSM1/NSM1.py", line 5, in ?
import cx_Oracle
ImportError: libclntsh.so.10.1: cannot open shared object file:
Permission denied
How can I fix the problem?

Any help would be appreciated,
Max

BTW:

I have the following settings in my /etc/profile file:

#-------------------------------------------
ORACLE_BASE=/home/oracle/oracle/product
ORACLE_HOME=$ORACLE_BASE/10.2.0/db_1
LD_LIBRARY_PATH=$ORACLE_HOME/lib
PATH=$PATH:$ORACLE_HOME/bin
ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data
export ORACLE_BASE ORACLE_HOME ORACLE_SID LD_LIBRARY_PATH PATH
#-------------------------------------------

[Damjan]

I am using RedHat Linux 4. and I developed an oracle 10g based

application by using cx_Oracle (cx_Oracle-4.1-10g-py23-1.i386.rpm) and
Python 2.3.4.

When I run the application through direct console connection, It works
perfect.

But, when I schedule a crontab job to run the application, It logs this
error:

Traceback (most recent call last):
File "/home/nsm1/NSM1/NSM1.py", line 5, in ?
import cx_Oracle
ImportError: libclntsh.so.10.1: cannot open shared object file:
Permission denied

....

I have the following settings in my /etc/profile file:

#-------------------------------------------
ORACLE_BASE=/home/oracle/oracle/product
ORACLE_HOME=$ORACLE_BASE/10.2.0/db_1
LD_LIBRARY_PATH=$ORACLE_HOME/lib
PATH=$PATH:$ORACLE_HOME/bin
ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data
export ORACLE_BASE ORACLE_HOME ORACLE_SID LD_LIBRARY_PATH PATH
#-------------------------------------------

These environment variables are important for running any programs that use
the oracle client libraries. The problem you have is that when you run the
script from cron these environment variables are not set.

Now, there are several ways how to handle this:
1. create a shell script that you call from cron, and it it set the
environment variables and then call you python program

2. modify the environment in your python program (via os.environ) and then
import cx_Oracle

3. modify your system so that no environment variables are neccesseary -
actually this is not possible, but what I have is, symbolic links
in /usr/lib to the libraries in $ORACLE_HOME/lib, thus I don't need the
LD_LIBRARY_PATH variable, and the only other variable I need is the
ORACLE_HOME, which is /usr/share/oracle on my system and it contains
bin/ install/ lib/ network/ ocommon/ oracore/ rdbms/ sqlplus/


--
damjan

[dccarson]

I have a similar question (importing cx_Oracle, but not related to
cron). I would like to use solution #2 below and it does not work. If
I set LD_LIBRARY_PATH before running python, it works. If I try to set
it via os.environ, it does not work.

I have tried this in an interactive Python shell. I can print the
value of os.environ["LD_LIBRARY_PATH"] and it is correct, but the
import fails. The cx_Oracle.so file is found, but when it tries to
load the necessary Oracle library (libclntsh.so.9.0), I get the
message:

ImportError: libclntsh.so.9.0: cannot open shared object file: No
such file or directory

Is there something else I have to do when changing os.environ before
trying the import?

Thanks,
David
P.S. Please post, as I don't read this e-mail account.

Damjan wrote:

These environment variables are important for running any programs that use
the oracle client libraries. The problem you have is that when you run the
script from cron these environment variables are not set.

Now, there are several ways how to handle this:
1. create a shell script that you call from cron, and it it set the
environment variables and then call you python program

2. modify the environment in your python program (via os.environ) and then
import cx_Oracle

3. modify your system so that no environment variables are neccesseary -
actually this is not possible, but what I have is, symbolic links
in /usr/lib to the libraries in $ORACLE_HOME/lib, thus I don't need the
LD_LIBRARY_PATH variable, and the only other variable I need is the
ORACLE_HOME, which is /usr/share/oracle on my system and it contains
bin/ install/ lib/ network/ ocommon/ oracore/ rdbms/ sqlplus/


--
damjan

[Damjan]

I have a similar question (importing cx_Oracle, but not related to

cron). I would like to use solution #2 below and it does not work. If
I set LD_LIBRARY_PATH before running python, it works. If I try to set
it via os.environ, it does not work.

I have tried this in an interactive Python shell. I can print the
value of os.environ["LD_LIBRARY_PATH"] and it is correct, but the
import fails. The cx_Oracle.so file is found, but when it tries to
load the necessary Oracle library (libclntsh.so.9.0), I get the
message:

ImportError: libclntsh.so.9.0: cannot open shared object file: No
such file or directory

Is there something else I have to do when changing os.environ before
trying the import?

Well, all the oracle stuff is installed in /usr/lib/oracle on my computers
(or /usr/share/oracle ... depends when and how I installed it),
but I also always make the symbolic links in /usr/lib too.

I guess once Python is started (and the C level library loader) you can't
change LD_LIBRARY_PATH anymore.

What I ussually set in os.environ is ORACLE_HOME because the oracle library
still needs to find some additional files too.
BTW cx_Oracle seems to only need /usr/lib/libnnz10.so
and /usr/lib/libclntsh.so.10.1 but I also have these links in /usr/lib:
libclntsh.so -oracle/lib/libclntsh.so*
(this is a link to the .so.10.1 file)
libclntsh.so.10.1 -oracle/lib/libclntsh.so.10.1*
libnnz10.so -oracle/lib/libnnz10.so*
libocci.so -oracle/lib/libocci.so*
(this is a links to the .so.10.1 file
libocci.so.10.1 -oracle/lib/libocci.so.10.1*
libociei.so -oracle/lib/libociei.so*

This is with oracle instant client 10 libraries.

>These environment variables are important for running any programs that
use the oracle client libraries. The problem you have is that when you
run the script from cron these environment variables are not set.

Now, there are several ways how to handle this:
1. create a shell script that you call from cron, and it it set the
environment variables and then call you python program

2. modify the environment in your python program (via os.environ) and
then import cx_Oracle

3. modify your system so that no environment variables are neccesseary -
actually this is not possible, but what I have is, symbolic links
in /usr/lib to the libraries in $ORACLE_HOME/lib, thus I don't need the
LD_LIBRARY_PATH variable, and the only other variable I need is the
ORACLE_HOME, which is /usr/share/oracle on my system and it contains
bin/ install/ lib/ network/ ocommon/ oracore/ rdbms/ sqlplus/


--
damjan

--
damjan