Oracle11 Client installation and PLSQL and TOAD Chinese garbled Solution

Oracle 11 Client installation and PLSQL and TOAD Chinese garbled solutions 1. Download the "Instant Client Package" software from Oracle, which provides a better solution for Oracle Client greening. Is: http://www.oracle.com/technology/software/tech/oci/instantclient/htdocs/winsoft.html Downloadable packages: Download package: instantclient-basic-win32-11.2.0.1.0.zip (Latest Version) 2. decompress the package to the installation directory, for example, D: \ Program Files \, and create a two-tier folder named D: \ Program Files \ instantclient_11_2 \ under D: \ Program Files \ instantclient_11_2, create 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 oracle listening port. If you are not sure what your oracle listening port is, you 'd better use the lsnrctl status Command on the server. 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. set the system environment variable to 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 and create a variable: variable name: oracle_home variable value: D: \ Program Files \ instantclient_11_24. install PLSQL Developer 7.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" and try again. Normally, the connection is successful. Garbled characters occur after PLSQL Developer Connection. Description: after connecting to other Oracle databases using the Oracle green client, garbled information is displayed. Solution: 6. Open the installation directory of PLSQL Developer, see the directory of plsqldev.exe, create the "PLSql_run.bat" file in the PLSQL Developer folder, and enter the following content in the file:

---------------------------------------------------------------------------------------------set nls_lang=SIMPLIFIED CHINESE_CHINA.ZHS16GBKPLSQLDev.exe---------------------------------------------------------------------------------------------

 

7. Use the PLSql_run.bat file to start the PLSQL Developer tool each time you start the tool. Otherwise, garbled characters may occur. 8. TOAD Chinese garbled solution: Set the environment variable nls_lang and the variable value: AMERICAN_AMERICA.US7ASCII: 1. The connection is unsuccessful. Check the network and server firewall. 2. open "PLSQL Developer", click "cancel", go to the Tools/preferences window of PLSQL Developer, and enter Oracle/Connection. The changes are as follows: enter in Oracle Home: d: \ ORA10 OCI library input: D: \ ORA10 \ oci. try connecting the dll again. -------------------------------------------------------------------------------------------------- Chinese garbled solution: Right-click the attribute on my computer -- Advanced System settings -- Advanced -- environment variable, and create a user variable: variable name: NLS_LANG variable value: AMERICAN_AMERICA.UTF8