Configuring detail monitoring
Prev About modifying an Oracle service group Next

Configuring detail monitoring

Use the detail monitoring capability of VCS database agent for Oracle to monitor the status of a database. Before setting up detail monitoring, you must have the agent running at the basic level of monitoring, that is, the DetailMonitor attribute must be set to False.

The Oracle agent uses a script to monitor the status of the database. A sample SQL script, located at %VCS_HOME%\bin\Oracle\check.sql, is provided with the agent for the purpose. If the script is successfully executed during monitoring, the agent considers the database instance available. If the execution fails, the database instance is considered not available and the service group faults and fails over to the failover nodes. You can customize the script to meet your configuration requirements.

Note:

You must use a separate script for each Oracle service group that exists in the cluster. The script must exist on all the nodes in the service group.

Veritas recommends that before configuring detail monitoring, you must ensure that Oracle is configured correctly and you are able to connect to the database.

Enabling detail monitoring

The section below describes how to enable detail monitoring using the configuration wizard.

To enable detail monitoring

  1. Start the Oracle configuration wizard from Start > All Programs > Veritas > Veritas Cluster Server > Configuration Tools > Oracle Configuration Wizard or, on Windows 2012 operating systems, from the Apps menu in the Start screen.

    or

    Launch the Solutions Configuration Center (SCC) from Start > All Programs > Veritas > Veritas Cluster Server > Solutions Configuration Center or, on Windows 2012 operating systems, from the Apps menu in the Start screen. In the SCC, click the Solutions tab, expand High Availability Configuration Wizards, and click the Launch button for the Oracle Agent Configuration Wizard.

  2. Review the prerequisites and click Next.
  3. On the Wizard Options panel, click Modify service group, select the service group configured for the instance to be monitored in detail, and click Next.
  4. On the Oracle Configuration panel, select the SIDs to be configured along with their respective listeners and click Next.
  5. On the Detail Monitoring dialog box, specify information to enable detail monitoring, and click Next.

    Enter the appropriate information in the following fields:

    Detail Monitor

    Check the Detail Monitor option corresponding to each database that you want to configure detail monitoring for.

    SQL Path

    Type the path of the SQL file that will query the database to validate the status. Click the icon next to the field to browse for the SQL file.

    A sample SQL file, check.sql, is located at %VCS_HOME%\bin\Oracle\.
  6. On the Domain and User selection panel, type a valid domain name, user name, password, and then click Next.
  7. Follow the wizard instructions and accept the default values in the subsequent dialog boxes.

Disabling detail monitoring

The section below describes how to disable detail monitoring using the Oracle Configuration Wizard.

To disable detail monitoring

  1. Start the Oracle configuration wizard from Start > All Programs > Veritas > Veritas Cluster Server > Configuration Tools > Oracle Configuration Wizard or, on Windows 2012 operating systems, from the Apps menu in the Start screen.

    or

    Start the Solutions Configuration Center (SCC) from Start > All Programs > Veritas > Veritas Cluster Server > Solutions Configuration Center or, on Windows 2012 operating systems, from the Apps menu in the Start screen. In the SCC, click the Solutions tab, expand High Availability Configuration Wizards, and click the Launch button for the Oracle Agent Configuration Wizard.

  2. Review the prerequisites and click Next.
  3. On the Wizard Options panel, click Modify service group, select the service group configured for the instance for which detail monitoring is being disabled, and click Next.
  4. On the Oracle Configuration panel, click Next.
  5. On the Detail Monitoring Configuration panel, uncheck the check box corresponding to the Oracle Server instance for which detail monitoring is being disabled and click Next.
  6. Follow the wizard instructions and accept the default values in the subsequent dialog boxes.

Prev Up Next
Deleting an Oracle service group Home Adding DMP to a clustering configuration