PL/SQL Developer remote connection to Oracle database

Modify the database configuration file: Tnsnames.ora "My database location: D:\app\Icey-evil\product\11.2.0\dbhome_1\NETWORK\ADMIN"

Add the following to the server address:

10.88. 250.28 =  =    =10.88.        250.281521)      ))) (= ORCL    )   ))    

Description: HOST = 10.88.250.28 is the Oracle server that needs to be connected Ip,service_name = ORCL is a connected db instance, Port = 1521 is the Oracle Server listener.

Configuration complete, with the PL/SQL developer tool for remote connection, database is the added TNS service name, here is 10.88.250.28.

Issues that occur during the remote connection:

1.ORA-12638: Identity Certificate retrieval failed

Workaround:

Check the relevant information, say Sqlnet.authentication_services= (NTS) in the local file Sqlnet.ora, or change it to sqlnet.authentication_services= (NONE).

According to the above method, the local file Sqlnet.ora modified, reconnect, is still ORA-12638.

The individual changes the sqlnet.authentication_services= (NTS) in the file Sqlnet.ora on the server to Sqlnet.authentication_services= (NONE) and then reconnect and the connection succeeds.

On the whole, it seems to be a sqlnet.authentication_services problem, but in the case of PL/SQL Developer Connection ORA-12638, useful navicat premium for remote connection Oracle, The connection is successful, so after PL/SQL developer Remote Connection succeeds, the file on the server is Sqlnet.ora sqlnet.authentication_services= (NONE) Change back to Sqlnet.authentication_services= (NTS), at this time, normally, PL/SQL developer Remote Connection will still be ORA-12638, the fact is that the connection is successful! So...... No solution ...

　　"Sqlnet. Authentication_services indicates which authentication method is used by Oracle, NTS indicates a local operating system certification, and none indicates that the password file will be used for authentication. When none is set, the local operating system certification will not be licensed and Oracle will use password file authentication "

2. PL/SQL Developer after landing prompt:

inch hkey_local_machine\software\oracle\key_oradb11g_home1.

Workaround: Modify the Registry

Win+r-> cmd->regedit->enter;

Find Key_local_machine\software\oracle\key_oradb11g_home1

"A 32-bit program installed in Hkey_local_machine\software\wow6432node\oracle\key_oradb11g_home1,wow64 on a 64-bit operating system in win 64-bit Systems"

Find the Nls_lang key, the original value is: Simplified Chinese_china. Zhs16gbk

Change it to: simplified Chinese_china. Al32utf8

Reopen PL/SQL Developer, log in, Ok.

　　

PL/SQL Developer remote Connection to Oracle database