PowerProtect: Oracle Discoveries generate critical alerts for Oracle databases that do not exist on the Oracle box

Summary: This article explains a workaround on how to avoid alerts for nonexisting Oracle Databases.

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

PowerProtect Data Manager generates critical alerts for Oracle databases that do not exist on the Oracle system.

See the example below.
 
Oracle alerts
Figure 1: Oracle alerts seen in PowerProtect Data Manager.

Cause

This can happen if there are Oracle Databases in oratab that do not exist on the Oracle system.

Resolution

If the database is a valid database:
  1. Start that Oracle database.
If the database does not exist on the Oracle system:
  1. Delete the inactive database (ORACLE_SID) from the oratab file. 
  2. Set the EXCLUDE_SID parameter to exclude that ORACLE_SID from the discovery in the RMAN Agent Configuration

The default location of the RMAN Agent configuration file is: 
/home/oracle/opt/dpsapps/rmanagent/config/rman_agent.cfg
Starting with PowerProtect Data Manager 19.14, the IGNORE_ORATAB_INACTIVE_SID parameter can be enabled in the RMAN Agent configuration file.

This allows ddbmcon to ignore the inactive ORACLE_SID database in the oratab file.
Article Properties
Article Number: 000214726
Article Type: Solution
Last Modified: 19 Jun 2023
Version:  3
Find answers to your questions from other Dell users
Support Services
Check if your device is covered by Support Services.