Oracle 11 Client installation and PLSQL and toad Chinese garbled characters

Http://wanwentao.blog.51cto.com/2406488/456195

Oracle 11 Client installation and PLSQL and toad Chinese garbled characters

1. Download from Oracle officialThe "Instant Client package" software provides a better solution for greening the Oracle client.

For: http://www.oracle.com/technology/software/tech/oci/instantclient/htdocs/winsoft.html

Downloadable packages include:

Download package:

Instantclient-basic-win32-11.2.0.1.0.zip (Latest Version)

2. decompress the package to the installation directory.For example, under D: \ Program Files \, create a folder named D: \ Program Files \ instantclient_11_2 \ under D: \ Program Files \ instantclient_11_2 \ and create a folder named tnsnames in Admin. ora file,

The input format is as follows:

Owen_192.168.2.35 = 192.168.2.35: 1522/Owen

Here, 1522 is the listening port of Oracle. If you are not sure what the listening port of your Oracle is, you 'd better use

Let's take a look at the lsnrctl status Command.

Here, you can modify it based on your actual situation. Pay attention to the space issue in the middle. If there are more or fewer spaces, errors will occur.

In fact, in the second step, create a two-tier network \ ADMIN folder, and then create a tnsnames. ora file in admin, which is not required. This is just to facilitate login.

3. configure system environment variables

Enter D: \ Program Files \ instantclient_11_2 at the beginning of the PATH variable value, or add:; D: \ Program Files \ instantclient_11_2 at the end.

Create a variable named ORACLE_HOME. The variable value is D: \ Program Files \ instantclient_11_2.

4. Install PLSQL developer7.1 or another version. Be sure not to install the tool in the directory with "(x86)" during installation, which is prone to errors.

5. Run"PLSQL developer". Connect and try it. Normally, the connection is successful.

Garbled characters After PLSQL Developer Connection Processing

Problem description: After you connect to other Oracle databases using the Oracle green client, garbled information is displayed.

Solution:

6. Open the installation directory of PLSQL developer and see the directory with plsqldev.exe,

Create a "plsql_run.bat" file in the PLSQL developer folder and enter the following content in the file:

Bytes ---------------------------------------------------------------------------------------------

 

Set nls_lang = simplified chinese_china.zhs16gbk

Plsqldev.exe

 

Bytes ---------------------------------------------------------------------------------------------

 

7. EnableUse the plsql_run.bat file to start the PLSQL developer tool. Otherwise, garbled characters may occur.

 

8. Toad Chinese garbled Solution
Set the environment variable nls_lang. The variable value is american_america.us7ascii.

Check Method for unsuccessful running:

1. The connection fails. Check the network and server firewall.

2. Open "PLSQL developer" and click "cancel" to go to

In the tools/preferences window, go to Oracle/connection. The changes are as follows:

Enter D: \ ora10 in Oracle Home.

Input: D: \ ora10 \ OCI. dll in OCI Library

Try again.

 

Bytes --------------------------------------------------------------------------------------------------

Chinese garbled solutions:

On my computer, right-click Properties> advanced system Settings> advanced> environment variables to create user variables:
Variable name: nls_lang
Variable value: american_america.utf8