Oracle Plsql Client Connection Oracle12.2 A workaround for the permissions issue and the use of the green version of the Oracle client.

1. Colleague feedback log in without reporting errors when logging into the latest oracle12.2 database:

2. Remember to check the data, Oracle increased the encryption level of the client connection database in 12.2 earlier Oracle client such as 11.2.0.1 version (released in 2007) connection 12.2 will pop up such a hint, the solution is generally said on the internet Modify the server-side sqlnet file or the client that is upgrading Oracle

3. In the server side can not change (a lazy one is not to reduce the characteristics, etc.)

We recommend that you use an updated version of the Oracle client to connect to the 12.2 database.

Specific measures:

1. Download Oracle's Instant client and Oracle's latest version of Plsql (note Plsql already has a 64-bit compiled version) 11.5 version is still very good and has Chinese (oneself lazy, English level general)

2. Unzip the Oracle's instant client to a directory of things that it does not frequently delete

3. Installation of Plsql and Chinese registration, etc...

4. Modify the content within the preferences:

Increase the directory location of the immediate client:

Or just like me. Modify the PATH environment variable for WIN10

Then you can use the ....

Character Set garbled resolution:

Sometimes character sets are garbled:

Add a variable inside the system variable:

Nls_characterset = ZHS16GBK
Nls_lang = American_america. Zhs16gbk

Most of the time can solve the problem of garbled login can be configured to directly enter the IP address without the tube NETCA:

User name password database input Ip:port/instanceid is available.

Can remember very many connections:

It is more convenient to use.

Oracle Plsql Client Connection Oracle12.2 A workaround for the permissions issue and the use of the green version of the Oracle client.