| Panel | ||||||||
|---|---|---|---|---|---|---|---|---|
| ||||||||
| Section | ||||||||
OverviewThis resource controls
| ||||||||
| ||||||||
|
Adding
In your resource addition wizard, select a resource type for the Oracle database.
...
From the list of Oracle database
...
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.
...
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: |
...
C:W> SC STATUS SERVICE_NAME EX) SC STATUS OracleServiceORCL 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 ' |
...
Monitor
Monitors whether the Oracle database process is running.
...
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', |
...
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 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.
|
Add
In your resource addition wizard, select a resource type for the Oracle database.
| Section | ||||||
|---|---|---|---|---|---|---|
|
상태
| 상태 | 설명 | |
|---|---|---|
 | 오프라인 | 오라클 데이터베이스 서비스를 구성하는 프로세스들이 모두 종료된 상태입니다. |
 | 온라인 | 오라클 데이터베이스가 실행중인 상태이며, DoQuery 속성이 'true'일 때는 인스턴스 상태가 'OPEN'임을 의미합니다. |
 | 응답없음 | 오라클 데이터베이스는 실행중이지만 인스턴스 상태가 'OPEN'이 아니거나 상태를 조회할 수 없는 상태입니다. |
 | 장애 | 온라인 상태에서 종료 과정을 거치지 않고 오프라인 상태 변경된 경우입니다. |
속성
Common Attributes
...
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 |
...
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 |
...
For Windows
...
| OracleServiceName |
...
| Oracle database service name registered in service manager(SCM) |
...
| STRING |
...
| None | X |
...
For Linux
...
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.