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
[img]http://wiki.navicat.com/wiki/images/c/cd/InstantClientSite.jpg[/img]
Unzip the packages into a single directory such as "C:\instantclient_11_1".
[img]http://wiki.navicat.com/wiki/images/0/02/InstantClientInstalls.jpg[/img]
In Options -> OCI, choose the oci.dll in the directory you defined in Step 2 ("C:\instantclient_11_1\oci.dll").
[img]http://wiki.navicat.com/wiki/images/5/54/InstantClientOptions.jpg[/img]
* 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
[img]http://wiki.navicat.com/wiki/images/c/cd/InstantClientSite.jpg[/img]
Unzip the packages into a single directory such as "C:\instantclient_11_1".
[img]http://wiki.navicat.com/wiki/images/0/02/InstantClientInstalls.jpg[/img]
In Options -> OCI, choose the oci.dll in the directory you defined in Step 2 ("C:\instantclient_11_1\oci.dll").
[img]http://wiki.navicat.com/wiki/images/5/54/InstantClientOptions.jpg[/img]