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.vejra...@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.sha...@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.sha...@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.ke...@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+unsubscr...@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+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/django-users?hl=en.
