Skip to main content
FlashGrid.io

How to add cluster database to OEM

  • Updated
  • Products: FlashGrid Cluster on Azure
  • Products: FlashGrid Cluster on GCP
  • Products: FlashGrid Cluster on AWS

Prerequisites

  • Install management agent on all database nodes of the cluster. Refer to the documentation for details.

Configure Monitoring Credentials

  • Set a new password and unlock the DBSNMP database user in the cluster database: 
    alter user dbsnmp identified by "Oracle123" account unlock;
  • Set a new password and unlock the ASMSNMP ASM user. Refer to: Setting ASM Passwords

Add Cluster Target

  1. Go to Setup -> Add Target -> Auto Discovery Results:

  1. Find the cluster target:

  1. Select the cluster and click Promote:

  1. Review the target properties and adjust them if needed. Make sure that all DB hosts are on the list. Otherwise, add missing hosts manually.

  1. Click the Promote button, review the results:

Add Cluster Database

  1. Go to Setup -> Add Target -> Auto Discovery Results:

  1. Find the cluster database target:

  1. Select the cluster database and click Promote:

  1. Review the target properties and adjust them if needed.

  2. Specify the password for the DBSNMP user that was set in the Configure Monitoring Credentials step. Make sure that all database instances and all pluggable databases (in case of a Container database) are discovered. Click the Test Connection button to verify the DBSNMP password. Set Target Group if needed.

  1. Scroll down to the Cluster ASM section. Specify the password for the ASMSNMP user that was set in the Configure Monitoring Credentials step. Make sure that all ASM instances are discovered. Click the Test Connection button to verify the ASMSNMP password. Set Target Group if needed.

  1. Scroll down to the Listeners section. Set Target Group if needed. Adjust the machine name for listeners as follows:
    • ASM Listeners: should have machine name set to <node>-priv.yourdomain, e.g. rac1-priv.example.com
    • Listeners: should have machine name set to <node>.yourdomain, e.g. rac1.example.com

  1. Click the Next button in the top right corner:

  1. Review the targets. Click Save if everything is fine. Otherwise, click Back to return to the previous screen.

  1. Review the results:

  1. The newly added cluster database can be seen on the Databases screen: