Unable to establish connection with database ORA 12638

Article:TECH157046  |  Created: 2011-03-31  |  Updated: 2011-03-31  |  Article URL http://www.symantec.com/docs/TECH157046
Article Type
Technical Solution


Issue



 

Unable to establish the connection with the database. Scope is database '<DB NAME>' on server '<SERVER>'. Additional Error Information: ORA-12638: Credential retrieval failed


Error



Unable to establish the connection with the database. Scope is database '<DB NAME>' on server '<SERVER>'. Additional Error Information: ORA-12638: Credential retrieval failed


Cause



 

By default sqlnet.ora file has the value of AUTHENTICATION_SERVICES set to (NTS). Due to this value, whenever connection is tried with the server, the system verifies the user who wants to connect. Jobprocessor.exe, which connects to the database for querying, runs under the user "bvpmuser". This user is a local user on the Information Server and cannot be  verified on the Oracle server to be a Windows user. Hence, if the AUTHENTICATION_SERVICE value is set to NTS, the connection fails.


Solution



 

Change the AUTHENTICATION_SERVICES value.

Open the Sqlnet.ora file present in the %ORACLE_HOME%/network/ admin directory and change

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




Article URL http://www.symantec.com/docs/TECH157046


Terms of use for this information are found in Legal Notices