Cluster Server 7.3.1 Agent for Oracle Installation and Configuration Guide - Solaris
- Introducing the Cluster Server agent for Oracle
- About the Cluster Server agent for Oracle
- How the agent makes Oracle highly available
- About Cluster Server agent functions for Oracle
- Oracle agent functions
- How the Oracle agent supports health check monitoring
- ASMInst agent functions
- Oracle agent functions
- Installing and configuring Oracle
- 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
- Installing Oracle binaries on the first node of the cluster
- Installing and removing the agent for Oracle
- Configuring VCS service groups 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
- Administering VCS service groups for Oracle
- Pluggable database (PDB) migration
- Troubleshooting Cluster Server agent for Oracle
- Verifying the Oracle health check binaries and intentional offline for an instance of Oracle
- Appendix A. Resource type definitions
- Appendix B. Sample configurations
- 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 configuration for Oracle instances in Solaris zones
- Sample Oracle ASM configurations
- Appendix C. Best practices
- Appendix D. Using the SPFILE in a VCS cluster for Oracle
- Appendix E. OHASD in a single instance database environment
Error messages specific to the Oracle agent
Table: Oracle agent error messages lists the error messages for the VCS agent for Oracle with the description and a recommended solution, if available.
Table: Oracle agent error messages
Message | Description and solution |
---|---|
No SID specified | The Sid attribute in the Oracle type has not been set. Solution: Set the Sid attribute value to the correct database instance. |
sqlplus not found in <Oracle_Home>/bin | The client utility sqlplus is not found in the $ORACLE_HOME/bin directory. Solution: Verify that the Oracle home has been correctly specified and that this executable is present. |
srvctl not found in <Oracle_Home>/bin | The client utility srvctl is not found in the $ORACLE_HOME/bin directory. Solution: Verify that the Oracle home has been correctly specified and that this executable is present. |
Oracle <SID> failed to stop | Warning message to indicate that the following commands were not successful in closing the Oracle instance in the clean or offline entry point:
|
Oracle database <SID> not running | Warning message to indicate that the database instance was not running even before the clean or offline entry points were executed. Solution: No action required. |
Oracle (<SID>) kill TERM <PID1, PID2, ...> | Warning message to indicate that the Oracle processes would be signaled with SIGTERM. Solution: No action required. |
Oracle (<SID>) kill KILL <PID1, PID2, ...> | Warning message to indicate that the Oracle processes would be signaled with SIGKILL. Solution: No action required. |
Database in QUIESCING/QUIESCED mode | Warning message to indicate that database is in QUIESCING or QUIESCED mode. |
Database in RESTRICTED mode | Warning message to indicate that database is in RESTRICTED mode. |
Database in SUSPENDED state | Warning message to indicate that database is in SUSPENDED state. |
Resource <Res_name> - monitor procedure did not complete within the expected time. | Refer to Oracle's alert log for more information. When a monitor times out as many times as the value specified, the corresponding resource is brought down by calling the clean entry point. The resource is then marked FAULTED, or it is restarted, depending on the RestartLimit attribute value. Solution: Set the FaultOnMonitorTimeouts attribute value to 0 so that the monitor failures are not considered indicative of a resource fault. Another possible reason could be that automatic archiving was not enabled while setting up the database. Solution: Archive the database manually. If automatic archival is enabled, set the LOG_ARCHIVE_START parameter value in the file init.ora to TRUE. |
VCS ERROR Resource <Res_name>: online procedure did not complete within the expected time. | Solution: Increase the Oracle agent's OnlineTimeout interval. |
Custom script /opt/VRTSagents/ha/bin/Oracle/start_custom_<SID>.sql does not exist. Will not be able to start the database. | The agent could not find the custom script at the specified location to start the database. Solution: Make sure the custom file exists at the specified location and has valid permissions. |
Custom script /opt/VRTSagents/ha/bin/Oracle/shut_custom_<SID>.sql does not exist. Using default shutdown option. | The agent could not find the custom script at the specified location to stop the database. Solution: Make sure the custom file exists and the specified location and has valid permissions. |
oraerror.dat did not have records that could be parsed | The file oraerror.dat is not present or has records in an unsupported format. Solution: Make sure the file exists and has data in the supported format. |
Incorrect Monitor Option | The MonitorOption value is less than 0 or greater than 1. Solution: Set the MonitorOption attribute value to 0 or 1. |
MonitorOption value not applicable for this Oracle Version | The health check monitoring option is selected when Oracle version is not Oracle 10g or later. Solution: Set the MonitorOption value to 0 to select the process check monitoring option. |
VCSAgExec returned failure when trying to execute health check monitor test | Internal error. Solution: Contact Technical Support for further assistance. |
VCSAgExec returned failure while trying to find Oracle version | Internal error. Solution: Contact Technical Support for further assistance. |
One or more of the attributes User:Pword:Table:MonScript are not set correctly. Detail monitoring will not be enabled!! | Detail Monitoring has been enabled but the necessary attributes for detail monitoring have not been set correctly. Solution: Set the values of the required attributes for detail monitoring correctly. |