Versions Compared

Key

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

...

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

 

 

Attribute

Show the unique attribute of oracle database resource.

AttributeDescriptionsTypeDefaultModification
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

 The attribute value is entered to register the resource, and you can change or check it in the 'Specified Attribute'.