Skip to Content
Information

This site will undergo a brief period of maintenance on Friday, 18 December at 12:30 AM Central/12:00 PM IST. During a 30 minute window, site availability may be intermittent.

Discovering externally-provisioned Oracle RAC Clusters

Nodes that are part of an Oracle Real Application Cluster (RAC) that was not provisioned by using BMC Database Automation appear as Cluster Nodes during the node approval process.

Before you begin

The following requirements and limitations apply to enabling discovery of Oracle databases:

  • BMC Database Automation supports symmetrical clusters only. For example, if a cluster uses Automatic Storage Management (ASM), ASM must be installed on all nodes.
  • RAC servers must be running to be discovered.
  • RAC databases must be registered with Cluster Ready Services (CRS) to be discovered.

To discover externally-provisioned Oracle RAC clusters

The following information can be modified post-discovery by editing the db_names.conf file:

  • Oracle Version
  • OPatch path
Information
Important

If using the db_names.conf file, values must also be specified for the install user and CRS Home that correspond to a particular cluster. Additionally it is required that all nodes in a cluster have the same entry in the db_names.conf file in order to modify these values.

A cluster rescan is required for changes to auto-discovered values to appear.

Enter the following information in a space delimited format for each cluster:
<Product Type> <Install user> <CRS home> <Cluster version> <OPatch path>

An example of a db_names.conf file is shown in the following figure.

Information
Example

# config file for standalone dagent

# for Oracle, list these items:
#
# product          DB name    DB SID    ORACLE_HOME path      version     install user     opatch path
# ORACLE_DATABASE  MY DB      SID2222   /app/ora/homepath     10.2.0.1    oinstall         /opt/ora/opatch

# product          install user  crs home       cluster version    opatch path
# ORACLE_CLUSTER   oinstall      /opt/ora/crs   10.2.0.1           /opt/ora/crs/OPatch

# this is the config for an Oracle database instance
ORACLE_DATABASE  MY DB      MYBDSID1   /app/oracle/10.2/db     10.2.0.1    oinstall         /opt/ora/opatch

ORACLE_CLUSTER   oinstall      /app/oracle/CRS   10.2.0.1           /app/oracle/CRS/OPatch

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*

BMC Database Automation 8.2