...
| Status | Descriptions | |
|---|---|---|
 | Offline | It means that all the processes composing the Oracle database service are terminated. |
 | 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. |
Attribute
Show the unique attribute of oracle database resource.
| 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 | 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 |
| OracleHome | Path for the Oracle database software installation | STRING | None | O |
| User | Oracle database execution user account | STRING | None | O |
The attribute value is entered to register the resource, and you can change or check it in the 'Specified Attribute'.