7.12 Oracle Database
- 헌규임
- JuneL (Unlicensed)
- 정은진
- 권홍선
This resource controls the Oracle database. It detects the Oracle database installed on the system, controls the service and monitors the status.
이 페이지의 주요 내용
Adding
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
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 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 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. 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. | ||
Fault 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.