The error message "pldeveloper" appears when PL/SQL Developer connects to a 64-bit database.

The error message "pldeveloper" appears when PL/SQL Developer connects to a 64-bit database.

Original Works are from the blog of "Deep Blue blog". You are welcome to reprint them. Please note the following source when reprinting them. Otherwise, you will be held legally liable for copyright.

Deep Blue blog: http://blog.csdn.net/huangyanlong/article/details/41479997

After 64bit oracle11g database is installed, connect to the database using PL/SQL to solve the problem of "Chinese character" garbled

Field Environment

Operating System	WINDOWS 2008 64bit
Database Version	Oracl11g 64bit 11.2.0.3
PL/SQL version	10.0.20.97

Note: PL/SQL can only connect to 32-bit databases. Therefore, if you need to connect to a 64-bit database, you need to install a 32-bit client.

Implementation

Connect to the oracle11g database using PL/SQL.

A summary of my previous experience I have referred to during deployment: http://blog.csdn.net/huangyanlong/article/details/18466053

However, this production database encountered an error.

An error occurs during use as follows:

Error: Garbled characters.

Solution

Check the database language settings:

SQL> select userenv ('language') nls_lang from dual;

NLS_LANG

----------------------------------------------------

SIMPLIFIED CHINESE_CHINA.ZHS16GBK

Right-click "my computer"-"properties"-"advanced"-"environment variables"-"system environment variables ":

1>. Select "Path"-click "edit" and add "D: \ soft \ app \ Administrator \ product \ instantclient_11_2;

2>. click "new", set the variable name to "TNS_ADMIN", and set the variable value to "D: \ soft \ app \ Administrator \ product \ instantclient_11_2;", and click "OK ";

3>. Click "new", set the variable name to "NLS_LANG", set the variable value to "SIMPLIFIED CHINESE_CHINA.ZHS16GBK", and click "OK ";

Run PL/SQL Developer again. The Chinese characters are displayed correctly, as shown below:

Summary

When PL/SQL Developer is used to install a 32-bit client, the 64-bit database is successfully connected. However, Chinese characters are garbled. In WINDOWS, the corresponding environment variables need to be set.

Search for materials on the network

The following is a summary of how to use PL/SQL Developer to connect to a 64-bit database on the Internet. I will repost it here and share it with my friends.

Reprinted below:

1) install Oracle 11g 64-bit

2) install a 32-bit Oracle client (instantclient-basic-win32-11.2.0.1.0)

: Http://www.oracle.com/technetwork/cn/topics/winsoft-095945-zhs.html

 

Download instantclient-basic-win32-11.2.0.1.0.zip (it must be a 32-bit version. Do not download it on the Oracle official website.) decompress it to the Product in the Oracle Installation Directory (the local name is instantclient_11_2 ): d: \ app \ ZC \ product \ instantclient_11_2.

 

Copy a Directory D: \ app \ ZC \ product \ 11.2.0 \ dbhome_1 \ NETWORK under the root directory of the database installation to the Oracle Client Directory D: \ app \ ZC \ product \ instantclient_11_2 (in fact, only NETWORK \ ADMIN \ tnsnames is required. ora)

3) install PL/SQL Developer

Install PL/SQL Developer and set OCI Library and Oracle_Home in perference-> Connection. For example, set the local machine:

Oracle Home: D: \ app \ ZC \ product \ instantclient_11_2

OCI Library: D: \ app \ ZC \ product \ instantclient_11_2 \ oci. dll

4) set the environment variables (modify the PATH and TNS_ADMIN environment variables) for the NLS_LANG environment variables, it is best to set them to be consistent with the database. First, query the character set information from the database:

SQL> select userenv ('language') nls_lang from dual;

NLS_LANG

----------------------------------------------------

SIMPLIFIED CHINESE_CHINA.ZHS16GBK

Right-click "my computer"-"properties"-"advanced"-"environment variables"-"system environment variables ":

1>. Select "Path"-click "edit" and add "D: \ app \ ZC \ product \ instantclient_11_2;

2>. Click "new", set the variable name to "TNS_ADMIN", and set the variable value to "D: \ app \ ZC \ product \ instantclient_11_2;". Click "OK ";

3>. Click "new", set the variable name to "NLS_LANG", set the variable value to "SIMPLIFIED CHINESE_CHINA.ZHS16GBK", and click "OK ";

Click "OK" to exit.

Start PL/SQL Developer and run it normally.

 

Original Works are from the blog of "Deep Blue blog". You are welcome to reprint them. Please note the following source when reprinting them. Otherwise, you will be held legally liable for copyright.

Deep Blue blog: http://blog.csdn.net/huangyanlong/article/details/41479997