ORAINVOBJ

Explanation

ORAINVOBJ is the enclosing tag for all oracle invalid object - entries.

Parent

OSAGENT

allowed values

• DATABASE

Count

0 or 1. If you don't define ORAINVOBJ, no orainvobj check will run.

Example

<ORAINVOBJ>
  <DATABASE>
    <ORACLE_SID>osmart</ORACLE_SID>
    <!-- ORACLE_HOME will be read from /etc/oratab, if not set here
    -->

    <!-- Objects from user scott are not important -->
    <LOGFILTER>
      <REGEX>OWNER:SCOTT</REGEX>
      <ERRORLEVEL>NORMAL</ERRORLEVEL>
    </LOGFILTER>

    <!-- Views from osmart are VERY important -->
    <LOGFILTER>
      <REGEX>OWNER:OSMART.*TYPE:VIEW</REGEX>
      <ERRORLEVEL>ERROR</ERRORLEVEL>
    </LOGFILTER>

    <!-- All other invalid objects are WARNING -->
    <LOGFILTER>
      <REGEX>.*</REGEX>
      <ERRORLEVEL>WARNING</ERRORLEVEL>
      <PRIORITY>1000</PRIORITY>
    </LOGFILTER>

  </DATABASE>
</ORAINVOBJ>
        

DATABASE

Explanation

For every database you want to check you you define a DATABASE-pair

Parent

ORAINVOBJ

allowed values

• ORACLE_HOME

• ORACLE_SID

• LOGFILTER

• The common XML tags as described in Section 9.8, “Tags Common to All Checks and/or Checkpoints”

Count

As many as you like.

Example

Look at ORAINVOBJ