Content Comparison

Online

It means that the Oracle database is running.
If the DoQuery attribute is set to 'true', the instance status is 'OPEN'.

Terminates the Oracle database service.
If there is an ongoing backup process, terminate it first.

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.

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.

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. 

TroubleFault

It means that it went offline from online without a termination process.

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.

Terminates the Oracle database service.
If there is an ongoing backup process, terminate it first.

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.