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

[Graham H. <g.h...@gm...>]

>From the looks of things, Jani's suggestion - to add the apache user to the
dba group, should fix this issue.

gpasswd -a apache dba

then restart apache.

2010/3/17 juhui <ph...@gm...>

> I have added $ORACLE_HOME/lib to ld.so.conf  when I install cx_oracle. and
> cx_Oracle runs well under python shell module .
> follow you advice I added these two lines to /etc/sysconfig/httpd
> LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/home/oracle/product/10.2.0/lib:/usr/lib
>
> ORACLE_HOME=/home/oracle/product/10.2.0
> then restart apache.
>
> the error still happen.
> ：（
>
> 在 2010年3月17日 下午10:24，Graham Hagger <g.h...@gm...>写道：
>
> On a RHEL/CentOS system, add the path to the $ORACLE_HOME/lib directory to
>> /etc/ld.so.conf and run ldconfig as root.  That'll ensure the libraries are
>> picked up correctly by 90% of the software that needs them.
>>
>> For apache to work properly (and thus php etc) set the appropriate
>> environment variables (ORACLE_HOME, TNS_ADMIN, NLS_LANG etc) in
>> /etc/sysconfig/httpd
>>
>> Hope that helps,
>>
>> Graham
>>
>> 2010/3/17 Jani Tiainen <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...
>>> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>>>
>>
>>
>>
>> ------------------------------------------------------------------------------
>> 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
>>
>>
>
>
> --
> 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
>
>