Sunday, August 5, 2012

ORA-12638: credential retrieval failed


The SQLNET.ora file is a configuration file available in ORACLE_HOME\NETWORK\ADMIN location. The parameter "SQLNET.AUTHENTICATION_SERVICES" available in the SQLNET.ora file is used to specify the authentication services.

If you are facing error ORA-12638 it may be due to the wrong authentication service mentioned in the parameter. Change the parameter value from "nts" to "none" and try.

 sqlnet.authentication_services= (nts)  
 Change the above to  
 sqlnet.authentication_services= (none)  


Here the "nts" specifies the windows native authentication, which is used in the windows. with this parameter and ORA_DBA role a windows user can login into the database without database username and password.

No comments:

Post a Comment