7.12 Oracle Database.
- Copy Page Tree
This resource controls the Oracle database. It detects the Oracle database installed on the system, controls the service and monitors the status.
Table of Contents
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.
State
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.
| State | Agent command | 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 | Description | Type | Default | Edit | Note |
|---|---|---|---|---|---|
| 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 | |
| DBAAccount | It is a user account that has administrative previlege of Oracle database. | STRING | None | O | |
| Password | It is a password of the DBA account. | STRING | None | O |
Specified attribute values are normally entered when add the resource, This value can be edited or viewed through 'Specified Attribute' table in the Resource Attributes tab on the detailed information panel.
MCCS has function to limit input values against user's input field, and it provides function detects automatically data which is input wrong by user's mistake.