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

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.

Finish

If the monitoring results indicate the case of trouble, run the following finish process.

1. If all the Oracle database processes are running, run the termination command.
2. If there is any process not terminated after running the termination command, terminate it forcibly.
3. If there is any IPC resource not finished, delete them all.

Add

Adding

In your resource addition wizard, select a resource type for the Oracle database.

1. Oracle home directory - Enter the directory path for Oracle.

2. Oracle user - Enter the user account where you will run the database service.

   Note
   User account must match the owner of the home directory.

3. 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. 
The command assumes that it is generated by a user.
Oracle database agent: Manages the Oracle database registered in MCCS.

Image RemovedOffline all the processes composing the Oracle database service are terminated.It means that the Oracle database is running. the instance status is 'OPEN'.

	StatusStatus	Agent's functions	Descriptions	Note
Online It means that	Image Removed	Online	the Oracle database is running. If the DoQuery attribute is set to 'true', the instance status is 'OPEN'.	Offline	Terminates the Oracle database processes. Ex) sqlplus /as sysdba shutdown  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',
Image Removed	No response	It means that the Oracle database is running, but the instance status is not 'OPEN' or you cannot inquire about its status.
Image Removed	Trouble 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. Ex) sqlplus /as sysdba startup  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', Identify the OPEN state.
Fault It means that it went offline from online without a termination process.	Online	Starts the Oracle database processes. Ex) sqlplus /as sysdba startup  If there is any ongoing backup process. If so, terminate it and try to open the instance again.
	Offline	Terminates the Oracle database processes. If there is an ongoing backup process, terminate it first.
	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.

Attribute

Show the unique attribute of oracle database resource.

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. 

...