ORA-12638: Credential retrieval failed

ORA-12638: Credential retrieval failed in Oracle 19c

Error: ORA-12638: Credential retrieval failed

While connecting SQLPLUS sys@servicename AS SYSDBA will throw the error ORA-12638.

Refer to the article: https://docs.oracle.com/en/database/oracle/oracle-database/21/nfcon/windows-authentication-no-longer-uses-ntlm-by-default-355195897.html

For Microsoft Windows installations with AUTHENTICATION_SERVICES=NTS, starting with this release, the SQLNET.NO_NTLM parameter setting in the sqlnet.ora file will default to TRUE. In previous releases, the default for this parameter was FALSE. NTLM is the Windows Networks LAN Manager authentication service.

With NTS value, the oracle use window domain username/password, that user is not authenticated to login into your Oracle Server.

Solution: To overcome this error we have to update the Client-side SQLNET.ora file by disabling the authentication_service or No_NTLM solutions Choose either of the following:

SQLNET.NO_NTLM=FALSE

OR 

SQLNET.AUTHENTICATION_SERVICES=NONE

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.