Instant client required

From Navicat Wiki
Jump to: navigation, search

Apply OS : Windows, Mac, Linux

Apply Navicat Product : Navicat for Oracle, Navicat Premium

Apply Navicat Version No. : All


Instant Client package is required for Basic and TNS connection type. To download Instant Client package (Instant Client Package - Basic), please go to http://www.oracle.com/technetwork/database/features/instant-client/index-097480.html

Note: Navicat version 9 or above, instant client is bundled in Navicat.


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.


Windows

Installation Instructions

Note: Navicat version 10 or below, Navicat only support 32-bit instant client.

  1. Download the appropriate Instant Client packages for your platform. 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

    InstantClientSite.jpg

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

    InstantClientInstalls.jpg

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

    InstantClientOptions.jpg

  4. Restart Navicat.

Mac

Installation Instructions

Note: Navicat version 10 or below, Navicat only support 32-bit instant client.

  1. Download the appropriate Instant Client packages for your platform. All installations REQUIRE the Basic or Basic Lite package.

    Hint:
    • MAC OSX any versions running on PPC cpu should use PPC Navicat and PPC Instant Client.
    • MAC OSX 10.4 or below running on INTEL cpu should use PPC Navicat and PPC Instant Client.
    • MAC OSX 10.5 up running on INTEL cpu should use X86 Navicat and x86 Instant Client.

  2. Just simply unzip the packages and copy all files under /usr/lib or ~/lib. (Copy all files under /usr/lib for Mac OS X 10.3, otherwise, copy all files under /usr/lib or ~/lib for Mac OS X 10.4 or above.)

    Tips: Besides, you can place the instant client in anywhere you like and then specify the path in Preference.

    PreferencesEnv.gif
  3. Restart Navicat.

Linux

Installation Instructions

Note: Navicat version 11.1 or below, Navicat only support 32-bit instant client.

  1. Download Instant Client packages for Microsoft 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

    OCI linux 1.png

  2. Unzip the packages into a single directory such as "/home/test/instantclient_11_1".

    OCI linux 2.png

  3. In Options -> OCI, choose the oci.dll in the directory you defined in Step 2 ("/home/test/instantclient_11_1").

    OCI linux 3.png

  4. Restart Navicat.