Re: [cx-oracle-users] "Unable to acquire Oracle environment handle" with cx_Oracle 4.1.2 oracle 10g

[Anthony T. <ant...@gm...>]

On 1/16/06, Oliver-Mark Cordes <oc...@as...> wrote:
> On Mon, 16 Jan 2006, Anthony Tuininga wrote:
>
> > This error occurs when the Oracle client that cx_Oracle was compiled
> > with does not match the client that is currently in use. You have to
> > make sure that these match. So perhaps you can give a little more
> > information. What Oracle client are you using. Are you building your
> > own cx_Oracle or using a precompiled one -- if so, which one. What are
> > the values for ORACLE_HOME and LD_LIBRARY_PATH and where is your
> > Oracle client installed. If you run "ldd cx_Oracle.so" what is the
> > result? Specifically which libclntsh.so is it linked against? Hope
> > this helps track it down.
> >
>
> > [...]
>
> No, this does not help :-(
>
> I just found the the solution. In the ORACLE_HOME variable an ending "/"
> will cause the problem. LD_LIBRARY_PATH and ORACLE_HOME has indeed the
> same value, but somehow the Oracle libs don't link ending slashes ...
>
> Is there a possibility to check the environment valiables in cx_Oracle
> first? The would help to track down the problem!

Glad to hear you got it sorted out. As for adding the check for the
environment variables -- I'm sure it could be arranged but its not a
very high priority for me since you're the first person that's
actually ran into this problem in this particular way and this is
clearly an Oracle problem. Now if you provide me a patch, of
course.... :-)

> Best wishes,
>         Oliver
>
>
>
> -------------------------------------------------------
> This SF.net email is sponsored by: Splunk Inc. Do you grep through log fi=
les
> for problems?  Stop!  Download the new AJAX search engine that makes
> searching your log files as easy as surfing the  web.  DOWNLOAD SPLUNK!
> http://ads.osdn.com/?ad_id=3D7637&alloc_id=3D16865&op=3Dclick
> _______________________________________________
> cx-oracle-users mailing list
> cx-...@li...
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>