OverviewThis resource controls the Oracle database. It detects the Oracle database installed on the system, controls the service and monitors the status. StartStarts the Oracle database service. If the service is already running, terminate the service through Finish process and start it again. After the start, check the backup status to see if there is any ongoing backup process. If so, terminate it and try to open the instance again. TerminateTerminates the Oracle database service. If there is an ongoing backup process, terminate it first. If ShutdownOption is set to 'Abort', use the "shutdown abort" command to terminate an instance. If not, try "shutdown immediate". When OfflineTimeout occurs, if ShutdownOption is set to 'AbortAtTimeout', use "shutdown abort" to terminate. MonitorMonitors whether the Oracle database process is running. Additionally, if the DoQuery attribute is set to 'true', inquire about the instance status and set the Status attribute. If the status is 'OPEN', it will conclude that execution is normal. If the status is set to other value, then it will conclude that there is "no response". If the FaultOnQueryFailure attribute is set to 'true', "no response" is handled as a trouble. FinishIf the monitoring results indicate the case of trouble, run the following finish process. - If all the Oracle database processes are running, run the termination command.
- If there is any process not terminated after running the termination command, terminate it forcibly.
- If there is any IPC resource not finished, delete them all.
AddIn your resource addition wizard, select a resource type for the Oracle database. | Section |
|---|
| Column |
|---|
For Windows From the list of Oracle database services installed, select a service item to manage. 
[Figure]Add Oracle Database Resource |
| Column |
|---|
For Linux - Oracle home directory - Enter the directory path for Oracle.
Oracle user - Enter the user account where you will run the database service. | Note |
|---|
User account must match the owner of the home directory. |
- Oracle database instance - To identify the database, enter the SID(Oracle System ID).
[Figure]Add Oracle Database Resource |
|
Status| | Status | Descriptions |
|---|
 | Offline | It means that all the processes composing the Oracle database service are terminated. |  Image Removed Image Added | Online | It means that the Oracle database is running. If the DoQuery attribute is set to 'true', the instance status is 'OPEN'. |  | No response | It means that the Oracle database is running, but the instance status is not 'OPEN' or you cannot inquire about its status. |  | Trouble | It means that it went offline from online without a termination process. |
AttributeCommon Attributes | Attribute | Descriptions | Type | Default | Modification |
|---|
| SID | Oracle database instance name | STRING | None | X | | Status | v$instance is returned as the instance status
( STARTED, MOUNTED, OPEN ) | STRING | None | X | | ShutdownOption | Oracle database termination command option
( "Abort" / "AbortAtTimeout" / None ) | STRING | "AbortAtTimeout" | O | | DoQuery | Whether to inquire about the instance status | BOOLEAN | true | O | | FaultOnQueryFailure | Whether to handle trouble if the instance status is not 'OPEN' or you cannot inquire about it. | BOOLEAN | true | O |
| Section |
|---|
| Column |
|---|
For Windows | Attribute | Descriptions | Type | Default | Modification |
|---|
| OracleServiceName | Oracle database service name registered in service manager(SCM) | STRING | None | X |
|
| Column |
|---|
For Linux | Attribute | Descriptions | Type | Default | Modification |
|---|
| OracleHome | Path for the Oracle database software installation | STRING | None | O | | User | Oracle database execution user account | STRING | None | O |
|
|
|