Appendix F (Information) Action Definition File

The Oracle instance-monitoring detector of RIMECLUSTER Wizard for Oracle determines what corrective action should be taken from the error code. The action definition file provides Oracle 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 detector state
  - 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 detector operation
  - Np : Ignores any detected errors.
  - Of : Notifies Offline.
  - Wa : Notifies Warning.
  - Rs : Restarts detector.
  - Fa : Notifies Faulted.
Note
NOP error
If subsequent processing is not allowed with the SQL command while the corrective action is Np, the Rs processing will be performed.
- Message
  indicates text of the error code

Information

The errno that are not defined in the Action Definition File will be handled as Np.