Re: Cannot connect with OCI driver and Oracle 9i (9.2)

From: Joseph Weinstein <joe.remove_this_at_bea.com.remove_this>
Date: Tue, 24 Jun 2003 12:53:00 -0700
Message-ID: <3EF8AC1C.439775E2@bea.com.remove_this>

The problem (if as you say, you can connect via the thin driver) is that for the OCI-based driver, you must specify the DBMS according to the entry in the tnsnames.ora file, not by machine name as for the thin driver. I assume you have your ORACLE_HOME environment variable set correctly, and have an entry in the tnsnames.ora file for the DBMS you want to connect to.
Joe Weinstein at BEA

David wrote:

> Dave Hau <davehau_nospam_123_at_nospam_netscape.net> wrote in message news:<3EF76D38.2040704_at_nospam_netscape.net>...
> > You need two more shared object files:
> >
> > libclntsh.so.9.0
> > libwtc9.so
>
> Thanks, but it doesn't seem to be the problem since I do have these
> files in /oracle/lib (which is in my LD_LIBRARY_PATH).
Received on Tue Jun 24 2003 - 14:53:00 CDT