DPA: Error 'Failed to connect to database' when discovering RMAN

Summary: The wizard reports 'Failed to connect to database' for Oracle Recovery Manager (RMAN); logs show sodbcOpen and OCIEnvCreate errors caused by a missing or wrong C runtime for Instant Client. ...

This article applies to This article does not apply to This article is not tied to any specific product. Not all product versions are identified in this article.
Check out other resources

Symptoms

The following error is returned in the DPA Discovery Wizard during the Start Test when attempting to discover Oracle RMAN: 

Failed to connect to database


Within the dpaagent.log the following error is visible. 

ERR      5644.1852     20200327:173521   sodbc.oracle.sodbc - sodbcOpen(): Failed to connect to database server. server=server_name, dbname=servicename, user=userxyz, port=2112. Error was: OCIEnvCreate() failed: -1 (-1)


DPA Agent used for collecting from Oracle is on Windows system and Oracle Instant Client has been installed

Cause

Prerequisite application missing

Resolution

Installed the required version of Microsoft Visual Studio Redistributable for the version of Oracle Instant Client which is being used. Note that some versions of the Oracle Instant Client do not require any Microsoft Visual Studio Redistributable such as 11.1.

 

Affected Products

Data Protection Advisor

Products

Data Protection Advisor
Article Properties
Article Number: 000173198
Article Type: Solution
Last Modified: 23 ذو الحجة 1447
Version:  5
Find answers to your questions from other Dell users
Support Services
Check if your device is covered by Support Services.