IT Ninja Turtles Instant client required, Ninja Turtles instant
Pply OS:Windows, Mac, and 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 CALS 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 shocould use PPC Navicat and PPC Instant Client.
- Mac osx 10.4 or below running on INTEL cpu shocould use PPC Navicat and PPC Instant Client.
- Mac osx 10.5 up running on INTEL cpu shocould 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. cause:
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. First, open the "tools" --> "options" menu and see the following interface, according to the OCI library (oci. dll) path, navigate to the navicat oci directory, back up the files in it (by creating a bak folder in this directory, cut all dll files in the path "% dir %/Navicat Lite \ instantclient_10_2" to the bak folder ).
3. Find the following. dll files in the bin/directory of the oracle client installation directory:
4. Place the files listed above in the "% dir %/Navicat Lite \ instantclient_10_2" directory and restart navcat.
What is the difference between oracle Instant Client and oracle client?
You only need to install the oracle instant client (which is accurate to the configuration) (it is best to download the client with sqlplus). It is generally only used for connection, and the oracle client is a management client.
How to configure instant client
I think it should be like this:
64-bit Oracle Server is deployed on windows Server. In this case, any Oracle service should be normal.
Then, if you need to use a 32-bit program on a 64-bit machine, use instantclient; do not configure system environment variables; use the bat program to execute your 32-bit program (this will not affect your Oracle Server ).
For example:
In 64-bit Windows, use PL/SQL Developer to connect to Oracle:
• 1. Download the 32-bit Oracle InstantClient and expand it to a directory, such as C: \ instantclient-basic-nt-11.2.0.2.0;
• 2. Copy the system tnsnames. ora to this directory;
• 3. Set Oracle_Home and OCI Library in PLSQL Developer:
Tools configure Preferences configure Oracle connector 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. Create the following bat file in the PLSQL Developer directory, replace the shortcut, and start 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