Unable to validate Oracle database credentials: Try again
SGMon Debug:
Failed to initialize OCI environment.
For Oracle 10G and 11G, Check that credentials entered correspond to a SYSDBA oracle user that has the CONNECT permission granted.
For Oracle 12c and later, Check that credentials entered correspond to a SYSBACKUP privileges.
Check that the Windows user that is trying to add this instance information is member of local administrators group and the ORA_DBA local group.
If the above points have been confirmed then please use SGMON to gather more detailed information on why this issue may occur. SGMON is a diagnostic tool for Backup Exec which gives the ability to view debug output in real-time, while the application is running.
By analyzing the SGMON output different error messages might get displayed. Here is an example:
Failed to initialize OCI environment.
Steps to be followed :
If the above error is displayed, please review the System and User environmental variables
Right click on my computer go to Properties
Go to Advanced tab and click on Environmental variables button
Check the variable "path". It should contain the path to the Oracle bin directory.
Steps to be followed strictly with the recommendation from Oracle Admin:
1. Edit “sqlnet.ora” file on oracle server
2. Add “NONE” to SQLNET.AUTHENTICATION_SERVICES = (NTS, NONE)
3. Save the file and try to configure the Oracle instance in remote agent utility.
File: Sqlnet.ora