We're here to help!

 Dbvisit fails with Credential retrieval error , This article explains how to resolve this issue

Problem Details

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

Message received from process: dbvisit.exe ORCL(Dbvisit Standby: 6.0.42.10166 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: 6.0.42.10125 Process id: 5020)
201306201211 - ORA-12638: Credential retrieval failed SQL> SQL> SQL> SQL> ORA-12638: Credential retrieval failed
Dbvisit Standby terminated.
Return code = 12638

The 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: SP2-0640

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)

or

SQLNET.AUTHENTICATION_SERVICES=(TNSNAMES,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

Version 8.0:

https://dbvisit.atlassian.net/wiki/display/DS8QSG/Dbvisit+Standby+Configuration+%28DDC%29+-+Reference#DbvisitStandbyConfiguration(DDC)-Reference-8.SYSLogonSettings

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