navicat for Oracle配置

Connection Type

    * Basic
      In Basic mode, Navicat Oracle connects to Oracle through the Oracle Call Interface (OCI). OCI is an application programming interface that allows an application developer to use a third-generation language's native procedure or function calls to access the Oracle database server and control all phases of SQL statement execution. OCI is a library of standard database access and retrieval functions in the form of a dynamic-link library.
    * TNS
      In TNS mode, Navicat Oracle connects to Oracle server using an alias entry from a tnsnames.ora file.



Download the appropriate Instant Client packages for your platform (must be 32-bit version, even you are using 64-bit Windows). All installations REQUIRE the Basic or Basic Lite package.

Note:

    * For Oracle 9i or above, you need Instant Client 11 or below
    * For Oracle 8 and 8i server, you need Instant Client 10 or below


Unzip the packages into a single directory such as "C:\instantclient_11_1".

In Options -> OCI, choose the oci.dll in the directory you defined in Step 2 ("C:\instantclient_11_1\oci.dll").