Re: [cx-oracle-users] TemplateSyntaxError: Caught ImproperlyConfigured while rendering: Error loading cx_Oracle module: libclntsh.so.10.1: cannot open shared object file: No such file or directory

[Jani T. <re...@gm...>]

On 03/17/2010 04:21 PM, juhui wrote:
> thanks for you reply.
> I have added
> LD_LIBRARY_PATH & ORACLE_HOME to /etc/profile.
> and the values are:
>
> ro...@la...:[/root]echo $LD_LIBRARY_PATH
> /home/oracle/product/10.2.0/lib:/usr/lib
> ro...@la...:[/root]echo $ORACLE_HOME
> /home/oracle/product/10.2.0
> ro...@la...:[/root]ls -l
> /home/oracle/product/10.2.0/lib/libclntsh.so.10.1
> -rwxr-x--- 1 oracle dba 21188349 May 13 2009
> /home/oracle/product/10.2.0/lib/libclntsh.so.10.1
>
> is it Permission issue?
> Exception Value: Error loading cx_Oracle module: libclntsh.so.10.1:
> cannot open shared object file: Permission denied

^^^
As exception states...

Most probably Apache runs under other user than oracle and that user is
not part of dba group.

So either expand permissions or add apache user to dba group.

>
>
> 在 2010年3月17日 下午10:06，Jani Tiainen <re...@gm...
> <mailto:re...@gm...>>写道：
>
>     On 03/17/2010 03:53 PM, juhui wrote:
>     > hi
>     >
>     > I am using a redhat-4 64 bit box. I have installed
>     > apache+python+mod_python+django+cx_Oracle。
>     >
>     > I can run import cx_Oracle in python shell model. And my project
>     > depends on cx_Oracle runs well with manage.py runserver.
>     >
>     > when I try run Django project with apache+python_mod with oracle
>     > database. I got MOD_PYTHON ERROR .
>     >
>     > the error info is:
>     >
>     > TemplateSyntaxError: Caught ImproperlyConfigured while rendering:
>     > Error loading cx_Oracle module: libclntsh.so.10.1: cannot open
>     shared
>     > object file: No such file or directory
>     >
>
>     Your apache doesn't get all necessary environment variables to find
>     Oracle shared libraries, namely libclntsh.so.10.1 this time. You might
>     need to add to your apache config LD_LIBRARY_PATH (or somewhere else
>     where apache will pick it up) to point your oracle installation dir.
>
>     Also you might need ORACLE_HOME to point in the correct place as well.
>
>     --
>
>     Jani Tiainen
>
>
>     ------------------------------------------------------------------------------
>     Download Intel&#174; Parallel Studio Eval
>     Try the new software tools for yourself. Speed compiling, find bugs
>     proactively, and fine-tune applications for parallel performance.
>     See why Intel Parallel Studio got high marks during beta.
>     http://p.sf.net/sfu/intel-sw-dev
>     _______________________________________________
>     cx-oracle-users mailing list
>     cx-...@li...
>     <mailto:cx-...@li...>
>     https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>
>
>
>
> -- 
> LB can FlY
>
>
> ------------------------------------------------------------------------------
> Download Intel&#174; Parallel Studio Eval
> Try the new software tools for yourself. Speed compiling, find bugs
> proactively, and fine-tune applications for parallel performance.
> See why Intel Parallel Studio got high marks during beta.
> http://p.sf.net/sfu/intel-sw-dev
>
>
> _______________________________________________
> cx-oracle-users mailing list
> cx-...@li...
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>