Oracle ORA-12638 : credential retrieval failed

Oracle ORA-12638 : credential retrieval failed

Oracle ORA-12638 : 신용 검색에 실패했습니다

 

프로그램 설치 후 디비 접속시 위와 같은 에러 발생하면

 

sqlnet.ora의 SQLNET.AUTHENTICATION_SERVICES= (NTS) 을 주석처리 한다

 

 

#SQLNET.AUTHENTICATION_SERVICES= (NTS)  

 

 

 

Cause

The database and client always cross authenticate each other if  NTS authentication is negotiated.
This is regardless of whether the user will ultimately  be authenticated by the database using a user name and password or OS credentials.  NTS authentication happens at the start of the handshake.  For NTS authentication to succeed both the client OS user and the database server must be in the same domain or in two domains which trust each other.

Solution

Either create trust between the two domains or change the client or server SQLNET.AUTHENTICATION_SERVICES such that NTS in not negotiated in the connection handshake. NTS is only negotiated if both client and server have SQLNET.AUTHENTICATION_SERVICES  set to NTS in their sqlnet.ora files. NTS can be disabled by setting the SQLNET.AUTHENTICATION_SERVICES to NONE in either the client or server sqlnet.ora.

 

SQLNET.AUTHENTICATION_SERVICES=NONE