Local Oracle client connects to remote database with Plsql developer , log in when reported ORA-12638: resolution of failure of identity certificate retrieval
Locate the installation directory: C:\oracle\BIToolsHome_1\network\ADMIN Open Sqlnet.ora
Find sqlnet in there . Authentication_services= (NTS)
Change it to: sqlnet. Authentication_services= (Beq,none)
or comment out : #SQLNET. Authentication_services= (NTS)
Reason:
Sqlnet. Authentication_services= (NTS)
Specify to start one or more authentication services
Authentication Service refers to Oracle Authentication service, when you log in to Oracle, sometimes you do not need to enter the user name, sometimes you need to enter the user name, you need to enter a password. When do you need to enter everything? This is related to the authentication service specified here. The following three types of values are generally available:
-
- NONE: The role is not allowed through the OS system user login database, need to provide user name and password;
- All: The function is to allow all login methods;
- NTS: The role is to allow local operating system user authentication;
NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
指定CLIENT NAME解析方法的次序,默认是NAMES.DIRECTORY_PATH=(tnsnames, onames, hostname)
PL/SQL Developer log in when reported ORA-12638: resolution of failure to retrieve identity certificate