PL SQL 12.0.7 Installation and registration code, Chinese package, connect Oracle remote database, Chinese garbled problem processing

First, on the official website to download the corresponding version of PL SQL, the machine is 64-bit download 64-bit, URL: Https://www.allroundautomations.com/downloads.html#PLS

Click the application. exe file to install.

Installation is successful, open, there will be a need to register the pop-up window, enter the following registration code, only for Plsql Developer 12.0. Version 7,

Plsql Developer 12.0.7 Registration code
Product Code:4vkjwhfeh3ufnqnmpr9brvcuyujrx3n3le
Serial number:226959
Password:xs374ca

Install end, go to Oracle official website to download database corresponding version of the client, here is 12.0.7, I downloaded the 64-bit instantclient_12_1 and sqlplus compression package, remember to use 64-bit version!!!! If you do not have an Oracle account, register one.

Website: http://www.oracle.com/technetwork/topics/winx64soft-089540.html

Download complete and unzip to PL SQL installation path, respectively,

At this point, open you will find that your plsql_developer can not connect to the database properly, there is no initialization of the database content:

In the \instantclient_12_1 \network\admin "directory, create a new" Tnsnames.ora "file with the following contents:

(There is no "network\admin" directory structure in the "instantclient_12_1" directory, so you have to create them manually)

The contents of the file are as follows:

ORCL =  (DESCRIPTION = (    ADDRESS = (PROTOCOL = TCP) (HOST = localhost) (PORT = 1521))    (Connect_data =      (SERVER = dedicated)      (service_name = ORCL)))  

Note: If it is connected to a remote database, then the host is equal to your remote database address, IP address;  service_name name is the name of the connection server, if you want to connect multiple libraries, you can add multiple, but the name cannot be the same, such as: ORCL,ORCL1 ...

After opening the Plsql_developer, cancel the login and enter the main interface.

1. Click-Configure (Configure)--Preferences (Preferences)--Connection: (Explanation: The following version may be set in the tool tools Preferences connection)

2. Set the Oracle home directory name to extract the Instantclient_12_1 directory: C:\XX\XX\XX\instantclient_12_1

3.OCI Library changed to path with Instantclient_12_1: C:\XX\XX\XX\instantclient_12_1\oci.dll

Then, the app--OK--closes plsql_developer, restarts, and logs on successfully.

In addition, if there is a problem with Chinese garbled, you can

View registry Values Hkey_local_machine\software\oracle\key_oradb12home1

Enter the registry: Win+r, enter regedit, then return, click HKEY_LOCAL_MACHINE--->software---> ORACLE--->home, find Nls_lang (if not new), See if the value data is: Simplified Chinese_china. Zhs16gbk

Once setup is complete, restart the PL/SQL tool to solve the problem, create a new table, insert Chinese, and test for success.

If not, try the following;

New environment variable: computer--Properties--Advanced system settings--environment variables--NEW:

Variable name: Nls_lang

Variable value: Simplified Chinese_china. Zhs16gbk

This should be able to display the normal Chinese, if not yet, continue Google Bar, do not stop ...

Like a small partner in Chinese can download a PL SQL Chinese package

Chinese Patch:
Baidu Cloud Disk Link: Https://pan.baidu.com/s/1gfeXLnH Password: 3583

One, double-click to run the patch

Second, choose your plsql Developer installation directory

Finished, restart your plsql Developer effect is out, 12 of the version of Chinese is not all Chinese, there are a small part of the English display.

PL SQL 12.0.7 Installation and registration code, Chinese package, connect Oracle remote database, Chinese garbled problem processing