Cluster Server 7.4 Agent for Oracle Installation and Configuration Guide - Linux
- Introducing the Cluster Server agent for Oracle
- About the Cluster Server agent for Oracle
- Supported software for VCS agent for Oracle
- Changes introduced in the 7.4 release
- How the agent makes Oracle highly available
- About Cluster Server agent functions for Oracle
- Oracle agent functions
- Startup and shutdown options for the Oracle agent
- Startup and shutdown options for the pluggable database (PDB)
- Recommended startup modes for pluggable database (PDB) based on container database (CDB) startup modes
- Monitor options for the Oracle agent in traditional database and container database
- Monitor for the pluggable database
- How the agent handles Oracle error codes during detail monitoring
- Info entry point for Cluster Server agent for Oracle
- Action entry point for Cluster Server agent for Oracle
- How the Oracle agent supports health check monitoring
- Netlsnr agent functions
- ASMInst agent functions
- ASMDG agent functions
- Oracle agent functions
- Typical Oracle configuration in a VCS cluster
- About setting up Oracle in a VCS cluster
- Installing and configuring Oracle
- About installing Oracle in a VCS environment
- Before you install Oracle in a VCS environment
- About VCS requirements for installing Oracle
- About Oracle installation tasks for VCS
- Installing ASM binaries for Oracle 11gR2 or 12c in a VCS environment
- Configuring Oracle ASM on the first node of the cluster
- Configuring and starting up ASM on remaining nodes for 11gR2 or 12c
- Installing Oracle binaries on the first node of the cluster
- Configuring the Oracle database
- Copying the $ORACLE_BASE/admin/SID directory
- Copying the Oracle ASM initialization parameter file
- Verifying access to the Oracle database
- Installing and removing the agent for Oracle
- Configuring VCS service groups for Oracle
- About configuring a service group for Oracle
- Configuring Oracle instances in VCS
- Before you configure the VCS service group for Oracle
- Configuring the VCS service group for Oracle
- Setting up detail monitoring for VCS agents for Oracle
- Enabling and disabling intelligent resource monitoring for agents manually
- Configuring VCS service groups for Oracle using the Veritas High Availability Configuration wizard
- Typical VCS cluster configuration in a virtual environment
- About configuring application monitoring using the High Availability solution for VMware
- Getting ready to configure VCS service groups using the wizard
- Before configuring application monitoring
- Launching the High Availability Configuration wizard
- Configuring the agent to monitor Oracle
- Understanding service group configurations
- Understanding configuration scenarios
- High Availability Configuration wizard limitations
- Troubleshooting
- Sample configurations
- Administering VCS service groups for Oracle
- Pluggable database (PDB) migration
- Troubleshooting Cluster Server agent for Oracle
- About troubleshooting Cluster Server agent for Oracle
- Error messages common to the Oracle and Netlsnr agents
- Error messages specific to the Oracle agent
- Error messages specific to the Netlsnr agent
- Error messages specific to the ASMInst agent
- Error messages specific to the ASMDG agent
- Troubleshooting issues specific to Oracle in a VCS environment
- Verifying the Oracle health check binaries and intentional offline for an instance of Oracle
- Disabling IMF for a PDB resource
- Appendix A. Resource type definitions
- About the resource type and attribute definitions
- Resource type definition for the Oracle agent
- Resource type definition for the Netlsnr agent
- Resource type definition for the ASMInst agent
- Resource type definition for the ASMDG agent
- Appendix B. Sample configurations
- About the sample configurations for Oracle enterprise agent
- Sample single Oracle instance configuration
- Sample multiple Oracle instances (single listener) configuration
- Sample multiple instance (multiple listeners) configuration
- Sample Oracle configuration with shared server support
- Sample Oracle ASM configurations
- Sample configuration of Oracle pluggable database (PDB) resource in main.cf
- Sample configuration of migratable Oracle pluggable database (PDB) resource in main.cf
- Sample Configuration of Oracle supported by systemD
- Sample configuration of ASMInst supported by systemD
- Appendix C. Best practices
- Appendix D. Using the SPFILE in a VCS cluster for Oracle
- Appendix E. OHASD in a single instance database environment
Startup and shutdown options for the Oracle agent
You can specify Startup and Shutdown options for the Oracle instances that are configured.
Note:
In case of the CDB or traditional database types, the use of the SRVCTLSTART or SRVCTLSTART_RO startup options along with the UseSystemD attribute is not supported.
In case of the PDB database types, the use of the UseSystemD attribute is not supported.
In either case, if the UseSystemD attribute is set, the agent reports the resource as UNKOWN and logs an appropriate message accordingly.
Table: Startup options for traditional database and container database lists the startup options that the agent supports for traditional database and container database.
Table: Startup options for traditional database and container database
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='pfile_name_with_absolute _path' if the pfile is configured. For example: startup pfile = '</dbs/pfilename>' If the pfile is not configured, the agent runs startup without pfile. |
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. With systemD enabled, Oracle single instance or RAC does not support SRVCTLSTART option on the SLES 12, RHEL 7, and supported RHEL-compatible distributions. Note: This is applicable only when an Oracle grid infrastructure is configured. |
SRVCTLSTART_RO | Uses the srvctl utility to start an instance of the database with the With systemD enabled, Oracle single instance or RAC does not support SRVCTLSTART_RO option on the SLES 12, RHEL 7, and supported RHEL-compatible distributions. Note: This is applicable only when an Oracle grid infrastructure is configured. |
Table: Shutdown options for traditional database and container database lists the shutdown options that the agent supports for traditional database and container database.
Table: Shutdown options for traditional database and container database
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. Note: This is applicable only when an Oracle grid infrastructure is configured. |
SRVCTLSTOP_TRANSACT | Uses the srvctl utility to stop an instance of the database with the Note: This is applicable only when an Oracle grid infrastructure is configured. |
SRVCTLSTOP_ABORT | Uses the srvctl utility to stop an instance of the database with the Note: This is applicable only when an Oracle grid infrastructure is configured. |
SRVCTLSTOP_IMMEDIATE | Uses the srvctl utility to stop an instance of the database with the |