IT忍者神龜之Instant client required，忍者神龜instant
pply 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.
- 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
- 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").
- Restart Navicat.
Mac
Installation Instructions
Note: Navicat version 10 or below, Navicat only support 32-bit instant client.
- 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.
- 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.
- Restart Navicat.
Linux
Installation Instructions
- Download Instant Client packages for Microsoft Windows (32-bit). 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 "/home/test/instantclient_11_1".
- In Options -> OCI, choose the oci.dll in the directory you defined in Step 2 ("/home/test/instantclient_11_1").
- Restart Navicat.
1、原因：
ORA-12737: Instant Client Light: unsupported server character set CHS16GBK
Google，解釋如下：
ORA-12737:
Instant Client Light: unsupported server character set string
Cause: The character set specified is not allowed for this operation or is invalid. Instant Client Light has only minimal character sets.
Action: Do not use Instant Client Light for this character set
2、首先，我們開啟“tools”-->"options"菜單，見到如下介面，依據OCI library(oci.dll) 路徑，導航到 navicat oci 目錄下，備份裡面的檔案（通過在該目錄建立bak檔案夾，將“%dir%/Navicat Lite\instantclient_10_2”路徑下的所有dll檔案剪下到bak檔案夾）。
3、在oracle 用戶端安裝目錄bin/目錄下，找到如下幾個.dll檔案
4、將上面所列檔案放置到“%dir%/Navicat Lite\instantclient_10_2” 目錄下，重新啟動navcat即可。
oracle Instant Client 與oracle client 有什不同？
只需要安裝（準確的說是配置）oracle instant client即可（最好下載帶sqlplus的），一般只用於串連，oracle client是具有管理作用的用戶端了
怎配置instant client
我覺得應該這樣：
64位的 Oracle Server 就按照在 windows Server上；此時Oracle的任何服務都是應該正常的。
然後，如果需要在64位機器上使用 32位的程式，使用 instantclient；不要配置系統內容變數；就用bat程式來執行你的32位的程式（這樣不會影響你的Oracle Server）。
比如：
64位Windows下，使用PL/SQL Developer串連Oracle：
•1. 下載32位Oracle InstantClient，並展開到某目錄，例如C:\instantclient-basic-nt-11.2.0.2.0；
•2. 將系統的tnsnames.ora拷貝到該目錄下；
•3. 在PLSQL Developer中設定Oracle_Home和OCI Library：
ToolsPreferencesOracleConnection：
Oracle_Home：C:\instantclient-basic-nt-11.2.0.2.0
OCI Library：C:\instantclient-basic-nt-11.2.0.2.0\oci.dll
•4. 在PLSQL Developer目錄下建立如下bat檔案，替換其捷徑，啟動PLSQL Developer：
@echo off
set path=C:\instantclient-basic-nt-11.2.0.2.0
set ORACLE_HOME=C:\instantclient-basic-nt-11.2.0.2.0
set TNS_ADMIN=C:\instantclient-basic-nt-11.2.0.2.0
set NLS_LANG=AMERICAN_AMERICA.ZHS16GBK
start plsqldev.exe
