Dbvisit fails with Credential retrieval error , This article explains how to resolve this issue
Dbvisit fails with Credential retrieval failed error
Applicable Error Code
Dbvisit Standby terminated. Return code = 402
201306201211 - ORA-12638: Credential retrieval failed SQL> SQL> SQL> SQL> ORA-12638: Credential retrieval failed Dbvisit Standby terminated. Return code = 12638
Have been noticed in Version 6.0, 7.0 and 8.0
Message received from process: dbvisit.exe ORCL(Dbvisit Standby: 18.104.22.16866 Process id: 2000) 201306201210 - Log apply for ORCL terminated: Database error. Database ORCL appears to have a problem Please contact Dbvisit support. (if necessary) Dbvisit Standby terminated. Return code = 402 Dbvisit Standby Database Technology message from Server1 Message received from process: dbv_oraStartStop.exe stop ORCL (Dbvisit Standby: 22.214.171.12425 Process id: 5020) 201306201211 - ORA-12638: Credential retrieval failed SQL> SQL> SQL> SQL> ORA-12638: Credential retrieval failed Dbvisit Standby terminated. Return code = 12638
ORA-12638: Credential retrieval failed error may indicate that Dbvisit Standby does not have enough credentials to start the primary or standby database on Windows. The error message can also be:
Dbvisit Standby logs onto the database as
sysdba without a password. You can test this by manually logging on as follows:
sqlplus "/ as sysdba"
If Oracle is not letting you log into the database as
sysdba then please ensure there is a line in the
SQLNET.ORA file which reads:
SQLNET.AUTHENTICATION_SERVICES = (NTS)
Sometimes the server needs to be rebooted after
SQLNET.AUTHENTICATION_SERVICES = (NTS) is set to take affect. Also make sure that the user that is running Dbvisit Standby is part of the DBA group.
To test if Dbvisit can start the primary or standby database, run the command:
dbv_oraStartStop start ORCL
If this is not working, then you can set the following in your DDC file on the primary server to login to the database with a username and password:
SYS_LOGON= SYS_USER= _SYS_PASSWD= SYS_LOGON_STRING=
More information on these SYS_LOGON settings can be found in user guide.
Version 6.0 : https://dbvisit.atlassian.net/wiki/display/dbdc/Sys+Logon+Settings
Version 7.0 : https://dbvisit.atlassian.net/wiki/display/UGDS7/SYS+Logon+Settings
For more information, please refer to metalink document 77665.1 - WIN: OS Authentication - CONNECT AS SYSDBA Without a Password.
Mike Donovan June 21, 2013 09:34