Configuring Oracle within the Backup Exec Agent Utility fails with the error message: "Unable to validate Oracle database credentials. Try again".

Article: 100046880
Last Published: 2019-12-27
Ratings: 2 1
Product(s): Backup Exec

Problem

Configuring the Oracle access credentials within the Oracle tab of the Backup Exec Agent Utility fails with the error message: "Unable to validate Oracle database credentials. Try again".
 

Error Message

"Unable to validate Oracle database credentials. Try again."
 

SGMON Debug Output (Oracle, Management and 3rd party):

VXMON_FULL: [11/25/19 16:47:52] [14996]     [fsys\oracle]        - OCIINTERCONNECT::LogonOracle: db = (opera), home_dir = (d:\oracle\11204), user =(sys), passwd= (****) version= (110), CONNECT_TYPE= (0)
VXMON_FULL: [11/25/19 16:47:52] [14996]     [fsys\oracle]        - Current Oracle user name (sys)
VXMON_FULL: [11/25/19 16:47:52] [14996]     [fsys\oracle]        - putenv(ORACLE_SID=opera)
VXMON_FULL: [11/25/19 16:47:52] [14996]     [fsys\oracle]        - putenv(ORACLE_HOME=d:\oracle\11204)
VXMON_FULL: [11/25/19 16:47:52] [14996]     [fsys\oracle]        - Using the OCI library - oci.dll
VXMON_FULL: [11/25/19 16:47:52] [14996]     [fsys\oracle]        - Failed to initialize OCI environment.
VXMON_FULL: [11/25/19 16:47:52] [14996]     [fsys\oracle]        - Failed to logon to database, other error: Error code (0xffffffff)
VXMON_FULL: [11/25/19 16:47:52] [14996]     [fsys\oracle]        - Returning E_RMAN_LOGON_OTHER error (0xe000100f)
VXMON_FULL: [11/25/19 16:47:52] [14996]     [fsys\oracle]        - OCIINTERCONNECT::LogonOracle: Logon is Unsuccessful
 

Cause

This is caused by the order of the different Oracle bin paths specified in the System Environment variables:

Example of an environmental variable which causes this issue:
Path=D:\ORA\xxxx\11gappr2\bin; D:\ORACLE\11204\bin;

** The number 11204 within the path is the build version of Oracle and changes depending on the Oracle version installed. 

 

Solution

Ensure that the Oracle Home path visible in the debug log statement above "putenv(ORACLE_HOME=d:\oracle\11204)" is the first Environment Variable listed under "Path:"

** The number 11204 within the path is the build version of Oracle and changes depending on the Oracle version installed. 

Using the example from above the working order would be:
Path=D:\ORACLE\11204\bin; D:\ORA\xxxx\11gappr2\bin; 

To change the order:
- Go to Control Panel\System and Security\System > Advanced system settings
- Click the “Environment Variables…” button.
- Change the order based on your Oracle configuration.

Save and Restart the Remote Server.

 

Was this content helpful?