Versions Compared

Old Version 1

changes.mady.by.user Copy Page Tree

Saved on

compared with

New Version 2

changes.mady.by.user 정은진

Saved on

Key

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

...

[Figure]Add Oracle Database Resource


Deleting

Select resource "Resource type" → right click → delete resource.

...

StateAgent commandDescriptionsNote

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.

  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.

...

AttributeDescriptionTypeDefaultEditNote
SIDOracle database instance nameSTRINGNoneX
Statusv$instance is returned as the instance status
( STARTED, MOUNTED, OPEN )		STRINGNoneX
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
OracleServiceNameOracle database service name registered in service manager(SCM)STRINGNoneX
DBAAccountIt is a user account that has administrative previlege of Oracle database.STRINGNoneO
PasswordIt is a password of the DBA account.STRINGNoneO

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.

Info

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.