TNS/ORA-12631 : 이름 검색에 실패(Username retrieval failed)

 

ORA-12631 : 이름 검색에 실패

TNS-12631 Username retrieval failed

 

어느 날 갑자기 혹은 PC를 교체하여 똑같은 환경을 구성했음에도... 위와 같은 오류가 발생하는 경우에는 아래와 같이 조치하면 해결할 수 있습니다. 

 

 

sqlnet.ora 파일을 찾아서 내용을 보면 아래와 같습니다. 

 

# sqlnet.ora Network Configuration File: C:\app\myosuser\product\11.2.0\client_1\network\admin\sqlnet.ora # Generated by Oracle configuration tools.   # This file is actually generated by netca. But if customers choose to  # install "Software Only", this file wont exist and without the native  # authentication, they will not be able to connect to the database on NT.   SQLNET.AUTHENTICATION_SERVICES= (NTS)     NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)

 

 

해당 파일의 내용중 

SQLNET.AUTHENTICATION_SERVICES= (NTS)

 

윗부분을 주석처리 하고 아래와 같이 변경합니다.

 

#SQLNET.AUTHENTICATION_SERVICES= (NTS)  SQLNET.AUTHENTICATION_SERVICES= (NONE)

 

 

# sqlnet.ora Network Configuration File: C:\app\myosuser\product\11.2.0\client_1\network\admin\sqlnet.ora # Generated by Oracle configuration tools.   # This file is actually generated by netca. But if customers choose to  # install "Software Only", this file wont exist and without the native  # authentication, they will not be able to connect to the database on NT.   #SQLNET.AUTHENTICATION_SERVICES= (NTS) SQLNET.AUTHENTICATION_SERVICES= (NONE)     NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)