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
Online It means that the Oracle database is running. If the DoQuery attribute is set to 'true', the instance status is 'OPEN'.	Offline	Terminates the Oracle database service. If there is an ongoing backup process, terminate it first.
	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 '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: C:W> SC STATUS SERVICE_NAME EX) SC STATUS OracleServiceORCL\ 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. 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	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 ( "Abort" / "AbortAtTimeout" / 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
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.

7.12 Oracle Database

Adding

Deleting

Status

Attribute

Comments