This resource controls the Oracle database. It detects the Oracle database installed on the system, controls the service and monitors the status.
이 페이지의 주요 내용
Online
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.
Offline
Terminates 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.
Monitor
Monitors 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.
Clean
If 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.
Add
In your resource addition wizard, select a resource type for the Oracle database.
From the list of Oracle database services installed, select a service item to manage.
[Figure]Add Oracle Database Resource
Status
The following table explains the status changing 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 service. | |
| Monitoring | Identify the Window Oracle Database Service Status. You see the results from this command: If the DoQuery attribute is set to 'true', the Oracle database is still? running DoQuery 속성이 True일 경우, 오라클 데이터베이스는 실행중이지만 FaultOnQueryFailure 속성값이 true 면 응답없음 상태는 장애로 인식합니다. false면 응답없음 상태는 온라인 상태로 인식합니다. | ||
Offline It means that all the processes composing the Oracle database service are terminated. | Online | Starts the Oracle database service. C:\> SC START SERVICE_NAME EX) SC START OracleServiceORCL If there is any ongoing backup process. If so, terminate it and try to open the instance again. | |
| Monitoring | Identify the Window Oracle Database Service Status. You see the results from this command: If the DoQuery attribute is set to 'true', Identify the OPEN state. | ||
Trouble It means that it went offline from online without a termination process. | Online | Starts the Oracle database service. C:\> SC START SERVICE_NAME EX) SC START OracleServiceORCL If there is any ongoing backup process. If so, terminate it and try to open the instance again. | |
| Offline | Terminates the Oracle database service. | ||
| Clean | If the monitoring results indicate the case of trouble, run the following finish 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 |
| OracleServiceName | Oracle database service name registered in service manager(SCM) | STRING | None | X |
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.