Re: cx_Oracle error: ImproperlyConfigured

Yes you are correct, that the reason i have replaced the below line in "app.wsgi", but that does not works.

#os.environ["LD_LIBRARY_PATH"] = "/opt/app/oracle/products/11.2.0/lib"

#os.environ["ORACLE_HOME"] = "/opt/app/oracle/products/11.2.0"

os.environ["LD_LIBRARY_PATH"] = "/opt/app/oracle/products/10.2.0/lib"

os.environ["ORACLE_HOME"] = "/opt/app/oracle/products/10.2.0"

Thanks,

On Fri, Apr 29, 2011 at 2:10 AM, Jirka Vejrazka <jirka.vejrazka@gmail.com> wrote:

Kamal, this is exactly the same error you were getting before. Are you
sure that you have ORACLE_HOME properly set on your new client and in
the right environment?

 Cheers

 Jirka

On 28/04/2011, kamal sharma <kamalp.sharma@gmail.com> wrote:
> Hi Again,
>
> I have finished my implementation with the local db, but now stuck in major
> issue.When i try to login to the local oracle database then it is working
> perfectly fine.I am able to read the data from the db installed in the
> same UNIX machine.
>
> But when i tried to login a db installed in remote machine, which is
> installed in the client side, then getting following error.
>
> Traceback (most recent call last):
>   File "test_db.py", line 8, in ?
>     connection = cx_Oracle.Connection("%s/%s@%s" % ('user', 'user123',
> 'db'))
> cx_Oracle.DatabaseError: ORA-01804: failure to initialize timezone
> information
>
> Also at the client machine the Oracle is (10.2.0)
> "/opt/app/oracle/products/10.2.0", but in my machine it
> is /opt/app/oracle/products/11.2.0 (11.2.0).
>
>
> Earlier i was using like this in my CGI-Perl code, now i have to migrate
> this in Django-Python module to use the below logic.How we can solve this
> problem?
>
> # Add ORACLE_HOME for 10g Oracle client.
> BEGIN { $ENV{ORACLE_HOME} = '/opt/app/oracle/products/10.2.0' }
>
> Any help will be highly appreciated.
>
> Thanks,
> Kamal
>
> On Tue, Apr 26, 2011 at 10:22 PM, kamal sharma
> <kamalp.sharma@gmail.com>wrote:
>
>> Thanks to all for supporting this to fix the issue.
>>
>> So issue is resolved by adding these 2 lines in "app.wsgi"
>>
>> os.environ["LD_LIBRARY_PATH"] = "/opt/app/oracle/products/11.2.0/lib"
>> os.environ["ORACLE_HOME"] = "/opt/app/oracle/products/11.2.0"
>>
>> Thanks again for helping to fix this issue. Its really a superb forum to
>> fix the issue so quickly. :-)
>>
>> Regards,
>> Kamal
>>
>> On Sun, Apr 24, 2011 at 7:58 PM, Ian <ian.g.kelly@gmail.com> wrote:
>>
>>> On Apr 23, 12:29 pm, kamal sharma <kamalp.sha...@gmail.com> wrote:
>>> > No it was .profile of mine. Now I have set the LD_LIBRARY_PATH in
>>> app.wsgi
>>> > as mentioned below and when I print the os.environ in the beginning of
>>> > views.py then it shows that newly added value.
>>>
>>> It's clear that your LD_LIBRARY_PATH is fine at this point, since the
>>> library must be loaded in order to get the ORA-01804 error.  The
>>> problem, as Jirka and I have suggested, is that the rest of your
>>> Oracle installation is still not visible to the process, which is
>>> preventing the client from reading its data files.  Why this is the
>>> case is unclear without knowing more details about your system.  Is
>>> the Oracle directory readable by the WSGI user?  Is the WSGI process
>>> running inside a chroot jail?
>>>
>>> --
>>> You received this message because you are subscribed to the Google Groups
>>> "Django users" group.
>>> To post to this group, send email to django-users@googlegroups.com.
>>> To unsubscribe from this group, send email to
>>> django-users+unsubscribe@googlegroups.com.
>>> For more options, visit this group at
>>> http://groups.google.com/group/django-users?hl=en.
>>>
>>>
>>
>

--
You received this message because you are subscribed to the Google Groups "Django users" group.
To post to this group, send email to django-users@googlegroups.com.
To unsubscribe from this group, send email to django-users+unsubscribe@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/django-users?hl=en.