| Section | |||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
Overview
This resource controls the Oracle database. It detects the Oracle database installed on the system, controls the service and monitors the status.
Start
Starts 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.
Terminate
...
Adding
In your resource addition wizard, select a resource type for the Oracle database.
- 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
Deleting
Select resource type → right click → delete resource.
The deleted resource will immediately disappear from the management web console.
Status
The following table explains the status switching of the MCCS resource caused by a user's command and the status.
Oracle database agent: Manages the Oracle database registered in MCCS.
| Status | Agent's functions | Descriptions | Note |
|---|---|---|---|
Online It means that the Oracle database is running. | Offline | Terminates the Oracle database processes. If there is an ongoing backup process, terminate it first. | |
| Monitoring | Monitors whether the Oracle database process is running.. If |
...
the DoQuery attribute is set to ' |
...
true', |
...
the Oracle database is still? running If the FaultOnQueryFailure attribute is set to 'true', "no response" is handled as a trouble. If the FaultOnQueryFailure attribute is set to ' |
...
false', | |||
Offline It means that all the processes composing the Oracle database service are terminated. | Online | Starts the Oracle database service. If there is any ongoing backup process. If so, terminate it and try to open the instance again. | |
| Monitoring | Monitors whether the Oracle database process is running. |
...
If the DoQuery attribute is set to 'true', |
...
If the FaultOnQueryFailure attribute is set to 'true', "no response" is handled as a trouble.
...
Identify the OPEN state. | |||
Fault It means that it went offline from online without a termination process. | Online | Starts the Oracle database processes. If there is any ongoing backup process. If so, terminate it and try to open the instance again. | |
| Offline | Terminates the Oracle database processes. | ||
| Clean | If the monitoring results indicate the case of trouble, run the following finish process.
|
...
Add
In your resource addition wizard, select a resource type for the Oracle database.
- 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
| 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'.Attribute value of ArgList arguments are the values that are added resources and the value can be changed or viewed through ’Specified Attribute’ list on the detailed information panel.