PRIMECLUSTER Wizard for Oracle (PRIMEQUEST) 4.3 Configuration and Administration Guide

Appendix F (Information) Action Definition File

The Oracle instance-monitoring detector of RIMECLUSTER Wizard for Oracle determines in accordance with the Action Definition File what corrective action should be taken from the error code. The Action Definition File provides Oracle instance error numbers, corrective actions, and error descriptions.

Action Definition File name and path

/opt/FJSVclora/etc/FJSVclorafm.actionlist

File format

errno/Status/Action/Message
  18    Cn   Wa "maximum number of sessions exceeded"
  20    Cn   Wa "maximum number of processes (%s) exceeded"
 470    All  Of "LGWR process terminated with error"
 471    All  Of "DBWR process terminated with error"
 472    All  Of "PMON process terminated with error"
 942    Ol   Np "table or view does not exist"
1012    All  Rs "not logged on"
1034    All  Of "ORACLE not available"

• errno

  Indicates the Oracle error number (ORA-xxxxx).

• Status

  Indicates the processing state of the detector which monitors Oracle instances.

  • Cn : When connecting to an Oracle instance.

  • Ol : Under connection with an Oracle instance.

  • Dc : When disconnecting to an Oracle instance.

  • All : Any status of above.

• Action

  Indicates the action how the detector handles Oracle instance error.

  • Np : Ignores any detected Oracle instance errors and continues to monitor. Notifies the state which is the same as previous time.

  • Of : Notifies Offline and stops monitoring.

  • Wa : Notifies Warning and continues to monitor.

  • Rs : Restarts detector.

  • Fa : Notifies Faulted and stops monitoring.

• Message

  Message indicates text of the error code.

Note

• The Oracle instance errors(ORA-xxxxx) that are not defined in the Action Definition File will be handled as Np.

• In the cases such as the following, Oracle instance errors will be handled as an action which is different from the action defined in the Action Definition File.

  • When the Oracle instance errors (ORA-xxxxx) are detected during DELETE processing in the SQL table monitoring, the errors will be handled as follows. It prevents to remain the abnormal state when SQL commands cannot be continued.

    • The Oracle instance errors(ORA-xxxxx) that are defined as Np or are not defined in the Action Definition File will be handled as Rs.

    • The Oracle instance errors(ORA-xxxxx) that are defined as Wa will be handled as Rs after notifying of Warning.

  • When the Oracle instance errors (ORA-xxxxx) are detected during connecting to the Oracle instance, the errors that are defined as Np or are not defined will be handled as Of.
    The following situation corresponds.
    When Oracle database archive files are full, the monitoring timeout occurs and the Oracle instance error, ORA-00257 (archiver error. Connect internal only, until freed.), is detected during connecting to the Oracle instance.

  • When ORA-01012, ORA-03113 or ORA-03135 are detected except when connecting to the Oracle instance, the errors will be handled as Rs.