Navicat Connecting Oracle Error ora-12737:instant Client light:unsupported server character Set CHS16GBK "

The original is as follows Http://blog.163.com/[email protected]/blog/static/7023477720142154449893/? collcc=1318255100&

This tool can be used with any Oracle database server of version 8i or above and supports most of the latest Oracle version features, including catalogs, tablespaces, synonyms, manifested views, triggers, sequences, types, and more. The image below is in Oracle, and MySQL and SQL Server are basically the same as it is. Let's take a look at the Oracle version!

See this interface, I believe a lot of people will like, this interface is very concise, no superfluous things, I think for the daily operation can basically meet the requirements of the operation of the database is very convenient, I believe to see a glance, basically will. Here is my installation and configuration of this software. Hope to be helpful to those who need it.
One, Navicat for Oracle installation:
1, double-click on its installation file, appears the interface shown below, here I choose a custom installation, click "Next" to continue the installation,:

2, in the interface that appears, select the target folder of the installation, here I selected in the D disk, click "Next" to continue,:

3. In the interface that appears, select the components to install and click the Install button:

4, after a few seconds, the software successfully installed, next click the Finish button to launch the tool,:

Second, Navicat for Oracle configuration
1, start the tool, the following Start screen appears, click the "Connect" option to connect to the database,:

6. In the New Connection dialog box, enter any connection name, select the default connection type, enter the server address where the Oracle database resides, and here I choose "localhost", enter the port number "1521" of Oracle, Enter the SID of the database or the service name of the database, enter the user name and password, here I use "Scott", click the "Connect Test" button to test to see if it is successful:

7, when I choose to start testing, there was an error: "Ora-12737:instant Client light:unsupported Server character Set CHS16GBK", this error is very typical, is because the server's encoding does not support the cause, but if I changed the server character set encoding, this is unrealistic, so the Internet to find a solution, finally know that as long as the Oracle official website to download a version of the OCI file, the original OCI file coverage can be resolved under the It's just a little bit bigger. The file at the end of the blog has been provided, the following is the file replacement process, the downloaded file is a compressed file, Remove the 4 files: Oci.dll,orannzsbb11.dll,oraocci11.dll,oraociei11.dll (this file is the most important), follow the steps below to replace the file. Select the Options command under the Tools menu to open the interface for the options:

8, in the "other" under the selection of OCI, on the right of the first file browsing, select the location of the Oci.dll, the default location is "installation directory \instantclient_10_2", remove the four files from the compressed file into the directory,:

9, after this configuration, restart the software, and a step forward connection configuration, test connection, which is the connection succeeded,:

10, after the success can see the "Scott" user's table, can be very convenient to operate the database.

The database I'm using is oracle10g, and we're downloading the instant client tool, which has 11 and 10 versions and uses 11 for oracle9i and above. The other uses version 10.

To attach the software used:
Navicat for Oracle Tools download:
Http://xiazai.xiazaiba.com/Soft/N/Navicat_for_Oracle_10.0.11.0_XiaZaiBa.exe
Tools to resolve character sets download:
Http://download.oracle.com/otn/nt/instantclient/112030/instantclient-basic-nt-11.2.0.3.0.zip
Reference article:
Http://wenku.baidu.com/view/319c742e4b73f242336c5fe2.html
Http://hi.baidu.com/3170716/item/14b2d0f224022e0a84d278bc

Connect to an Oracle database using NAVICAT, PL/SQL developer
Download instant Client to Oracle website This process is no longer said, the download after the completion of the decompression.

Configuration navicat: "Basic/tns"
Click on the Navicat tool-"options-" other-"OCI
OCI Library: Select the Oci.dll in the instant client that you just downloaded
Create a new Oracle connection
Basic
Connection name: "Custom"
Connection type: Basic
Host name or IP address: the hostname or IP address to connect to
Port: Database port
Service name or SID: Depending on your situation, if you choose a service name, write the database's global database name,
If SID is selected, write the SID of the database.
The user name password will not be said.
Tns
Connection name: "Custom"
Connection type: TNS
Network SERVICE Name: IP address: [Port]/sid[database name] (such as: 127.0.0.1:1521/ORCL if it is the default port 1521, then the port number can also not write, write directly like 127.0.0.1/ORCL)
The user name password will not be said.

Configuration plsql:
Configuring the Plsql is a little bit more complex, and you need to configure the environment variables.

After downloading the instant client, the path is configured to the environment variable path. such as F:\software\instantclient_10_2\
If the data in the database table is in Chinese, configure the query character set again, and then configure an environment variable.
Create a new
Variable name: Nls_lang
Variable value: Simplified Chinese_china. Zhs16gbk
Note: The value of the variable do not ignore the middle of the space, and why not Al32utf8, is because with Al32utf8 in the query timestamp type of field value will be garbled, other types will also have not carefully measured, anyway with zhs16gbk most insurance, certainly works.
Open Plsql, enter the user name, password, database and Navicat in the TNS configuration mode of the network service name input format is identical.
Another: You can also create a new network/admin/in the Instant client directory Tnsnames.ora file, in the network service name configuration, configuration and configuration of the Oracle NET service name configuration, the format is as follows, can be changed according to their own needs. After the configuration is complete, the Navicat TNS's Network service name and the Plsql database drop-down box will come out of your configured service name for you to choose "Remember to restart the client, otherwise it will fail."

Service name =
(DESCRIPTION =
(Address_list =
(address = (PROTOCOL = TCP) (HOST = addresses) (port = ports))
)
(Connect_data =
(SID = Write Sid here)
(SERVER = dedicated)
)
)
Service Name 2 =
(DESCRIPTION =
(Address_list =
(address = (PROTOCOL = TCP) (HOST = 2) (port = 2))
)
(Connect_data =
(SID = write here SID2)
(SERVER = dedicated)
)
)

Navicat Connecting Oracle Error ora-12737:instant Client light:unsupported server character Set CHS16GBK "