Configuring application monitoring for Oracle

Perform the following steps to configure monitoring for Oracle on a managed LPAR.

To configure application monitoring for Oracle

  1. In the Symantec High Availability view of the VOM Management Server console, click Configure Application Monitoring.

    This launches the Symantec ApplicationHA Configuration Wizard.

  2. Review the information on the Welcome screen and then click Next.

    The wizard lists all the supported applications for the system.

  3. On the Application Selection page, click Oracle in the Supported Applications list.

    Note:

    The wizard configures the agent to monitor Oracle instances with Intelligent Monitoring Framework (IMF).

  4. Ensure that the Oracle database instances and associated Listener processes are running and then click Next.

    An application discovery page appears.

    Note:

    If the Oracle database instances are not running, ensure that they are added in the oratab file.

  5. On Listener Selection panel, review the listed Oracle Listeners.

    Listener

    Name of the Listener.

    Home

    The $ORACLE_HOME path to Oracle binaries and configuration files.

    Owner

    The Oracle user, as the defined owner of executables and database files in /etc/passwd.

    EnvFile

    Specify the full path name of the file that is sourced by any operation.

    TnsAdmin

    The $TNS_ADMIN path to directory in which the Listener configuration file resides (listener.ora).

    Password

    This password is set for the selected Listener.

  6. On the Oracle Database Selection screen, select the Oracle database instances and the associated listeners that you want to monitor and then click Configure.

    Instances

    Click to select the Oracle instances to monitor.

    Database SID

    The Oracle System ID (SID) is used to uniquely identify a particular database on a system. For this reason, one cannot have more than one database with the same SID on a computer system.

    Oracle Home

    ORACLE_HOME refers to a directory where the Oracle is installed

    Database Owner

    The Database Owner refers to the owner of the Oracle Home directory.

    PFILE Path

    PFILE is a text file that contains parameters and their values which are consumed by the Oracle system .

    Listeners

    Oracle Listener receives incoming client connection requests and manages the traffic of these requests to the database server.

    Note:

    For each selected SID, all discovered Listeners are listed, and associated listeners are selected. If discovery phase is not displayed the correct SID - Listener association, you can appropriately select listeners for a selected SID.

  7. The wizard performs the application monitoring configuration tasks. The ApplicationHA Configuration screen displays the status of each task.

    After all the tasks are complete, click Next.

    Note:

    If the configuration tasks fail, click Diagnostic information to check the details of the failure.

    You then have to run the wizard again to configure the application monitoring.

  8. Click Finish to complete the wizard.

    This completes the application monitoring configuration.

  9. To view the status of the configured application on a managed LPAR, on the VOM Management Server console, right-click the appropriate managed LPAR and then click Manage ApplicationHA.

    The Symantec High Availability view appears.

    By default, the Component List tab appears. The tab lists each component of the configured application and the status description of each component.

    For more information on viewing and administering applications through the Veritas Operations Manager, see the Symantec ApplicationHA User's Guide.

  10. To view component dependency for the monitored application, click the Component Dependency tab.

    The component dependency graph appears.

    The graph illustrates the dependencies between a selected component group (an application or a group of inter-related components) and its components for the configured application. The left pane displays component groups and/or configured applications. The right pane displays components of the selected component group or application.

    For more information on viewing component dependency for any configured application, see the Symantec ApplicationHA User's Guide.