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_at_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 - 21:53:00 CEST

This message: [ Message body ]
Next message: Marc A. Lefebvre US-775: "Need help with RATIO and ROUND"
Previous message: JamesLane: "Materialized View/Snapshot without Triggers?"
Maybe in reply to: David: "Cannot connect with OCI driver and Oracle 9i (9.2)"
In reply to Dave Hau: "Re: Cannot connect with OCI driver and Oracle 9i (9.2)"
Next in thread: David: "Re: Cannot connect with OCI driver and Oracle 9i (9.2)"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message