7-8 Oracle Database

Owned by Copy Page Tree
Last updated: 2018/02/09 by 정은진
3 min read

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.

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

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

    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.

Status

The following table explains the status switching of the MCCS resource caused by a user's command and the status. 
Oracle database agent: Manages the Oracle database registered in MCCS.

StatusAgent's functionsDescriptionsNote

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 processes.
e.g.) 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', 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.
e.g.) 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.
e.g.) 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.

  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.

Attribute

Show the unique attribute of oracle database resource.

AttributeDescriptionsTypeDefaultModification
SIDOracle database instance nameSTRING
X
Statusv$instance is returned as the instance status
( STARTED, MOUNTED, OPEN )		STRING
X
ShutdownOption

Oracle database termination command option
( Abort / AbortAtTimeout / None )

STRING"AbortAtTimeout"O
DoQueryWhether to inquire about the instance statusBOOLEANtrueO
FaultOnQueryFailureWhether to handle trouble if the instance status is not 'OPEN' or you cannot inquire about it.BOOLEANtrueO
OracleHomePath for the Oracle database software installationSTRING
O
UserIt is an user account that has administrative previlege of Oracle database.STRING
O
DBAAccountIt is a user account that has administrative previlege of Oracle database.STRING
O
PasswordIt is a password of the DBA account.STRING
O

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. 


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.