IT忍者神龟之Instant client required，忍者神龟instan

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.

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
   
   
   
   
2. Unzip the packages into a single directory such as "C:\instantclient_11_1".
   
   
   
   
3. In Options -> OCI, choose the oci.dll in the directory you defined in Step 2 ("C:\instantclient_11_1\oci.dll").
   
   
   
   
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.
   
   
3. Restart Navicat.

Linux

Installation Instructions

1. 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
   
   
   
   
2. Unzip the packages into a single directory such as "/home/test/instantclient_11_1".
   
   
   
   
3. In Options -> OCI, choose the oci.dll in the directory you defined in Step 2 ("/home/test/instantclient_11_1").
   
   
   
   
4. 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即可（最好下载带sqlplus的），一般只用于连接，oracle 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：
ToolsPreferencesOracleConnection：
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