Overview of HA for Oracle External Proxy

Language:

The ORCL.oracle_external_proxy resource type interrogates the Oracle Database or the Oracle Real Application Clusters (Oracle RAC) local or remote services and interprets the availability of those services as an Oracle Solaris Cluster resource state or status in an Oracle Solaris Cluster configuration. Support for local services allows the agent to monitor pluggable databases (PDBs) in a RAC container database (CDB).

If the Oracle Database or the Oracle RAC services are unavailable, the Oracle Solaris Cluster resource state will be offline. Similarly, if the Oracle Database or the Oracle RAC services are available, the Oracle Solaris Cluster resource state will be online. Additionally, appropriate Oracle Solaris Cluster status messages will also be displayed.

For example:

# clresource status oep-rs
=== Cluster Resources ===

Resource Name       Node Name       State       Status Message
-------------       ---------       -----       --------------
oep-rs              oephost1         Online      Online - Service orcl is UP
                    oephost2         Online      Online - Service orcl is UP

Furthermore, if the Oracle Database and the Oracle RAC services are unavailable, the Oracle Solaris Cluster resource status message will also display the ORA error number and some part of the error message, if known.

For example:

# clresource status oep-rs
=== Cluster Resources ===

Resource Name       Node Name       State       Status Message
-------------       ---------       -----       --------------
oep-rs              oephost1         Offline      Offline - Service orcl is DOWN /
[ORA-12514, TNS:listener does not currently ...]
                    oephost2         Offline      Offline - Service orcl is DOWN /
[ORA-12514, TNS:listener does not currently ?]

Oracle External Proxy Status Messages

Status	Message	Description
Service VIS is UP	`Instance is OPEN`	A database that is OPEN in READ WRITE mode results in the Oracle External Proxy resource going to the ONLINE state.
Service VIS is DOWN	`ORA-01033: ORACLE initialization or shutdown ...`	A database that is MOUNTED results in the Oracle External Proxy resource, that has `dbuser=hauser`, going to the OFFLINE state.
Service VIS is DOWN	`Instance is MOUNTED`	A database that is MOUNTED results in the Oracle External Proxy resource, that has `dbuser="hauser as sysdba"`, going to the OFFLINE state.
Service VIS is DOWN	`Instance is READ ONLY`	A database that is OPEN in READ ONLY mode results in the Oracle External Proxy resource going to the OFFLINE state.
Service VIS is DOWN	`Instance is READ ONLY WITH APPLY`	A database that is OPEN in READ ONLY WITH APPLY mode results in the Oracle External Proxy resource going to the OFFLINE state.