You can specify Startup and Shutdown options for Oracle instances that are configured.
Startup options
Startup options lists the startup options that the agent supports.
Startup options
Option
Description
STARTUP_FORCE
(Default)
Runs 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 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;
!
Shutdown options
Shutdown options lists the shutdown options that the agent supports.
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 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.