Re: cx_Oracle error: ImproperlyConfigured

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.