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

[juhui <ph...@gm...>]

thanks you all.
I added the apache user to dba group. it doesn't work.
I find the stupid xx set the directory permission to  drwx------ 。。
after change the related dirs permission。
*The error information changed!*

Unable to acquire Oracle environment handle

is this issue cause by mismach cx_Oracle version and oracle client version?



在 2010年3月17日 下午10:44，Graham Hagger <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
>>
>>
>
>
> ------------------------------------------------------------------------------
> 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