On May 2, 1:51 pm, [EMAIL PROTECTED] (Jared Still) wrote:
> On Fri, 2008-04-25 at 09:08 -0700, Dunston Rocks wrote:
> > $ENV{TNS_ADMIN} =
> > 'C:\oracle\product\10.2.0\client_2\NETWORK\ADMIN\tnsnam
> > es.ora'; # Also tried replacing these with POSIX-Style paths
> > $ENV{ORACLE_HOME} = "C:\oracle\product\10.2.0\client_2";
> > $ENV{NLS_LANG} = "AMERICAN_AMERICA.WE8DEC";
>
> Get rid of them backslashes, that's DOS stuff! :)
>
> you can use ENV{ORACLE_HOME} = "C:/oracle/product/10.2.0/client_2"
>
> or (IIRC) ENV{ORACLE_HOME} = "C:\\oracle\\product\\10.2.0\\client_2"
>
> Personally, I always use the first form.
>
> HTH
>
> Jared
Hi,
My experience is not exactly the same, but I had the same error. The
NLS errors, I think, is ared herring - it was in my case.
You need to make sure that oracle.so (libclntsh.so.10.1) can be found.
In my Fedora installation, I did this via /etc/ld.so.conf. The next
thing is to make sure that the ultimate file pointed to by Oracle.so
has permissions rwxr-xr-x
My install of Oracle, for reasons unknown to me, had this file set to
rwxr-x--- which doesn't work for 'others'.
Also, the previous poster's suggestion about backslashes versus
slashes is a good avenue to pursue...
good luck,
phil
