cx-oracle-users

[cx-oracle-users] ImportError: libclntsh.so.10.1: cannot open shared object file: Permission denied

[Ali M. <map...@ya...>]

Hi,

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

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

But, when I schedule a crontab job to run the application, I receive 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,
Alan

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
#-------------------------------------------

Re: [cx-oracle-users] ImportError: libclntsh.so.10.1: cannot open shared object file: Permission denied

[Anthony T. <ant...@gm...>]

Hmm, is the key in the phrase "permission denied"? It seems to have
found everything but it doesn't have the ability to actually load that
or other shared libraries that it references.

On 7/20/06, Ali Moeen <map...@ya...> wrote:
> Hi,
>
> I am using RedHat Linux 4. and I developed an oracle 10g based application
> by using cs_Oracle (cx_Oracle-4.1-10g-py23-1.i386.rpm) and Python 2.3.4.
>
> When I run the application through direct console connection, I works
> perfect.
>
> But, when I schedule a crontab job to run the application, I receive 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,
> Alan
>
> 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
> #-------------------------------------------
>
>
>
>
> -------------------------------------------------------------------------
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to share your
> opinions on IT & business topics through brief surveys -- and earn cash
> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
>
> _______________________________________________
> cx-oracle-users mailing list
> cx-...@li...
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>
>
>

Re: [cx-oracle-users] ImportError: libclntsh.so.10.1: cannot open shared object file: Permission denied

[<map...@ya...>]

  The “permission denied” doesn’t happen when I login to terminal and run the application. It just happen when I run the application through crontab scheduled jobs!
  

Anthony Tuininga <ant...@gm...> wrote: Hmm, is the key in the phrase "permission denied"? It seems to have
found everything but it doesn't have the ability to actually load that
or other shared libraries that it references.

On 7/20/06, Ali Moeen  wrote:
> Hi,
>
> I am using RedHat Linux 4. and I developed an oracle 10g based application
> by using cs_Oracle (cx_Oracle-4.1-10g-py23-1.i386.rpm) and Python 2.3.4.
>
> When I run the application through direct console connection, I works
> perfect.
>
> But, when I schedule a crontab job to run the application, I receive 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,
> Alan
>
> 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
> #-------------------------------------------
>
>
>
>
> -------------------------------------------------------------------------
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to share your
> opinions on IT & business topics through brief surveys -- and earn cash
> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
>
> _______________________________________________
> cx-oracle-users mailing list
> cx-...@li...
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>
>
>

-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys -- and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
cx-oracle-users mailing list
cx-...@li...
https://lists.sourceforge.net/lists/listinfo/cx-oracle-users

Re: [cx-oracle-users] ImportError: libclntsh.so.10.1: cannot open shared object file: Permission denied

[Anthony T. <ant...@gm...>]

If the crontab scheduled job is running as the same user as the user
you login to on the terminal then I have no idea what might be going
on. Anyone else?

On 7/20/06, map...@ya...
<map...@ya...> wrote:
>
> The "permission denied" doesn't happen when I login to terminal and run the
> application. It just happen when I run the application through crontab
> scheduled jobs!
>
>
> Anthony Tuininga <ant...@gm...> wrote:
>
>  Hmm, is the key in the phrase "permission denied"? It seems to have
> found everything but it doesn't have the ability to actually load that
> or other shared libraries that it references.
>
> On 7/20/06, Ali Moeen wrote:
> > Hi,
> >
> > I am using RedHat Linux 4. and I developed an oracle 10g based application
> > by using cs_Oracle (cx_Oracle-4.1-10g-py23-1.i386.rpm) and Python 2.3.4.
> >
> > When I run the application through direct console connection, I works
> > perfect.
> >
> > But, when I schedule a crontab job to run the application, I receive 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,
> > Alan
> >
> > 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
> > #-------------------------------------------
> >
> >
> >
> >
> >
> -------------------------------------------------------------------------
> > Take Surveys. Earn Cash. Influence the Future of IT
> > Join SourceForge.net's Techsay panel and you'll get the chance to share
> your
> > opinions on IT & business topics through brief surveys -- and earn cash
> >
> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
> >
> > _______________________________________________
> > cx-oracle-users mailing list
> > cx-...@li...
> >
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
> >
> >
> >
>
> -------------------------------------------------------------------------
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to share your
> opinions on IT & business topics through brief surveys -- and earn cash
> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
> _______________________________________________
> cx-oracle-users mailing list
> cx-...@li...
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>
>
> -------------------------------------------------------------------------
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to share your
> opinions on IT & business topics through brief surveys -- and earn cash
> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
>
> _______________________________________________
> cx-oracle-users mailing list
> cx-...@li...
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>
>
>

Re: [cx-oracle-users] ImportError: libclntsh.so.10.1: cannot open shared object file: Permission denied

[Mark H. <mh...@pi...>]

Anthony Tuininga wrote:
> If the crontab scheduled job is running as the same user as the user
> you login to on the terminal then I have no idea what might be going
> on. Anyone else?

try running strace yourprog... in the cron job.  You will get lots of
verbose output, but you might get a better notion as to exactly where
the .so load is failing.

For example, you might have a .profile that sets your LD_LIBRARY_PATH
properly for interactive use, but you might be hitting some other .so
when running non-interactively.

HTH,
Mark

-- 
Mark Harrison
Pixar Animation Studios