Startup and shutdown options

You can specify Startup and Shutdown options for the Oracle instances that are configured.

Table: Startup options lists the startup options that the agent supports.

Table: Startup options

Option

Description

STARTUP_FORCE

(Default)

Runs the command startup force pfile='location_of_pfile' if the pfile is configured.

If the pfile is not configured, the agent runs startup force. It picks up the default parameter files from their default locations.

STARTUP

Runs the command startup pfile='location_of_pfile' if the pfile is configured.

If the pfile is not configured, the agent picks up the default parameter files from their default locations and runs startup.

RESTRICTED

Starts the database in the RESTRICTED mode.

RECOVERDB

Performs a database recovery on instance startup.

CUSTOM

Uses a predefined SQL script (start_custom_$SID.sql) and runs custom startup options. The script must be in the /opt/VRTSagents/ha/bin/Oracle directory and must have access to the Oracle Owner OS user. If the file is not present, the agent logs an error message.

With a custom script, the agent takes the following action:

     sqlplus /nolog <<!
     connect / as sysdba;
     @start_custom_$SID.sql
     exit;
     !

SRVCTLSTART

Uses the srvctl utility to start an instance of the database.

For RAC clusters, you must manually set the default startup option as SRVCTLSTART.

Table: Shutdown options lists the shutdown options that the agent supports.

Table: Shutdown options

Option

Description

IMMEDIATE

(Default)

Shuts down the Oracle instance by running shutdown immediate.

TRANSACTIONAL

Runs the shutdown transactional command. This option is valid only for the database versions that support this option.

CUSTOM

Uses a predefined SQL script (shut_custom_$SID.sql) and runs custom shutdown options. The script must be in the /opt/VRTSagents/ha/bin/Oracle directory and must have access to the Oracle Owner OS user. If the file is not present, the agent shuts the agent down with the default option.

SRVCTLSTOP

Uses the srvctl utility to stop an instance of the database.

For RAC clusters, you must manually set the default option as SRVCTLSTOP.