User's Manual

3.3 Action definition file
The instance-monitoring detector of Oracle Wizard determines what corrective action should be
taken from an error code. The action definition file consists of Oracle error numbers, corrective
actions, and error messages.
● Action definition file name and path
/etc/opt/FJSVclora/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 an Oracle error number (ORA-xxxxx).
― Status
Indicates the detector state
Cn : When connecting to the Oracle instance.
Ol : Under connection to the Oracle instance.
Dc : When disconnecting to the Oracle instance.
All : Any status of above.
― Action
Indicates detector’s operation.
Np : Ignores any detected errors.
Of : Notifies Offline.
Wa : Notifies Warning.
Rs : Restarts detector.
Fa : Notifies Faulted.
When an error is detected by executing the “UPDATE” command of SQL, and if NP
is shown as a corrective action, the subsequent process has to be discontinued.
Take the Rs process.
― Message
Indicates text of an error code.
26