Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Section
Column

This resource controls the Oracle database. It detects the Oracle database installed on the system, controls the service and monitors the status.

Column
width350px
Panel

이 페이지의 주요 내용

Table of Contents
maxLevel4

Overview

...

Adding

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

From the list of 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.

...

services installed, select a service item to manage.

Image Added

[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. 

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 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 '

...

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:
C:W> SC STATUS SERVICE_NAME EX) SC STATUS OracleServiceORCL\

 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.
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

...

 

 

Add

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.

Image Removed

[Figure]Add Oracle Database Resource

 

 

Status

...

It means that the processes composing the Oracle database service are terminated.
 StatusDescriptions
Image RemovedOffline
  1. all
Image RemovedOnlineIt means that the Oracle database is running. If the DoQuery attribute is set to 'true', the instance status is 'OPEN'.
Image RemovedNo responseIt means that the Oracle database is running, but the instance status is not 'OPEN' or you cannot inquire about its status.
Image RemovedTroubleIt means that it went offline from online without a termination process
  1. .
 

 

Attribute

Show the unique attribute of oracle database resource.

...