Installing Standard Edition High Availability

Learn how to Install high availability on Oracle Database Standard Edition 2.

About Standard Edition High Availability

Starting with Oracle Database 19c, you can install Oracle Database Standard Edition 2 in high availability mode.

Note:

The ACFS storage option on IBM AIX is deprecated in Oracle Database 19c.

Standard Edition High Availability provides cluster-based failover for single-instance Standard Edition Oracle Databases using Oracle Clusterware.

Oracle Standard Edition High Availability benefits from the cluster capabilities and storage solutions that are already part of Oracle Grid Infrastructure, such as Oracle Clusterware, Oracle Automatic Storage Management (Oracle ASM) and Oracle ASM Cluster File System (Oracle ACFS).

Using integrated, shared, and concurrently mounted storage, such as Oracle ASM and Oracle ACFS for database files as well as for unstructured data, enables Oracle Grid Infrastructure to restart an Oracle Database on a failover node much faster than any cluster solution that relies on failing over and remounting volumes and file systems.

Starting with Oracle Database 19c Release Update (19.7), Standard Edition High Availability is supported on Linux x86-64, Oracle Solaris on SPARC (64-bit), and Microsoft Windows.

Starting with Oracle Database 19c Release Update (19.13), Standard Edition High Availability is supported on IBM AIX on POWER Systems (64-bit) and HP-UX Itanium.

Note:

This section is specific to Standard Edition High Availability, which provides cluster-based database failover for Standard Edition Oracle Databases 19c. For more information about high availability options for Oracle Database, see Oracle Clusterware Administration and Deployment Guide.

Requirements for Installing Standard Edition High Availability

Review these requirements before you install and deploy the Standard Edition High Availability feature.

You must configure Standard Edition High Availability using at least two nodes of a cluster running Oracle Grid Infrastructure 19.7 or later for Standalone Cluster.
You must configure Standard Edition High Availability using an Oracle Database home of version 19.7 or later.

Note:
When updating your Oracle Database home using Release Update (RU) 19.7 or later, ensure that you apply the Oracle Clusterware (OCW) RU of the same version to the Oracle Database home.
Ensure that all cluster nodes on which you plan to install Oracle Database have the same operating system users, groups, and resource limits for the database software owner.
You must store the Oracle Database binaries only on local storage or Oracle Automatic Storage Management Cluster File System (Oracle ACFS).
You must store the Oracle Database data files only on Oracle ASM or Oracle ACFS.
If you are using Oracle ACFS for storing data files, then you must register Oracle ACFS as a clusterware resource. The Oracle Database software owner user ( oracle ) must be the mount owner of the Oracle ACFS volume. When using an Oracle home on Oracle ACFS, Oracle recommends that you have Oracle base on the local file system.
If you are using a local file system, then you must have the same single-instance Standard Edition 2 installation and updates on each node. You must also use the same Oracle base and Oracle home directory structure on each node.
You must perform the same Oracle home operations on all the nodes.
You must use an SPFILE for the database instance initialization parameters and a database password file stored for the database instance initialization parameters in Oracle ASM or Oracle ACFS. This approach ensures that the parameters are consistent across all nodes and the password file is available after a failover or a relocation.
You must register the Standard Edition 2 single-instance database with SCAN listeners as remote listener and node listeners as local listener.

Deploying Standard Edition High Availability

Learn the process and options to deploy high availability on Oracle Database Standard Edition 2.

After installing Oracle Clusterware, as described in Oracle Grid Infrastructure Installation and Upgrade Guide for your platform, install single instance Standard Edition 2 Oracle Database software on the cluster nodes on which you want to configure Standard Edition High Availability.

Installing Standard Edition High Availability Database Software on Local File System

You can install Oracle Database software binaries on a local file system to enable the Oracle Database Standard Edition high availability feature.

Ensure that all the cluster nodes, on which you plan to configure Standard Edition High Availability, have the same operating system configuration, users, groups, resource limits, and SSH equivalence for the Oracle Database software owner user (oracle).

Before you start the installation, have all the information you need about users, groups, and storage paths. You should also be prepared to run root scripts or provide information to automate root scripts.

As the root user, log into the first cluster node on which you want to configure Standard Edition High Availability and create the Oracle base directory on the local file system. Follow the Oracle Optimal Flexible Architecture (OFA) recommendations and specify the correct owner, group, and permissions for this directory.
```
# mkdir -p /u01/app/oracle
# chown oracle:oinstall /u01/app/oracle
```
Log in to the first cluster node as the Oracle Database software owner user (oracle).
Download the Oracle Database 19c release 19.3 installation image file (db_home.zip) from Oracle Software Delivery Cloud website to a directory of your choice.
https://edelivery.oracle.com/
Download the Oracle Database Release Update 19.7 or later patch from My Oracle Support to a directory of your choice and unzip it.
https://support.oracle.com/
Create an OFA-compliant Oracle home directory on the local file system and extract the image files that you have downloaded in to this Oracle home directory. For example:
```
$ mkdir -p /u01/app/oracle/product/19.0.0/dbhome_1
$ cd /u01/app/oracle/product/19.0.0/dbhome_1
$ unzip -q /tmp/db_home.zip
```
From the Oracle home directory, run the runInstaller command with the -applyRU flag to start the Oracle Database Setup Wizard and apply the Oracle Database Release Update 19.7 or later patch during installation.
```
$ ./runInstaller -applyRU patch_directory_location/patch_ID
```
Note:
Run the runInstaller command from the Oracle home directory only. Do not use the runInstaller command that resides at $ORACLE_HOME/oui/bin/, or any other location, to install Oracle Database.
In the Select Configuration Option screen, select Set Up Software Only.
In the Select Database Installation Option screen, select Single instance database installation.
In the Select Database Edition screen, select Standard Edition 2.
Respond to the configuration prompts as needed.
Provide information to automate root scripts, or run scripts as root when prompted by the setup wizard.

If you configure automation for running root scripts, and a root script fails, then you can fix the problem manually, and click Retry to run the root script again.

Note:
Click Help if you have any questions about the information you are asked to submit during installation.
Optional: As the oracle user, enable read-only Oracle home on the first cluster node.
```
$ $ORACLE_HOME/bin/roohctl -enable
```
As the root user, create the Oracle base directory on all of the other cluster nodes on which you want to configure Standard Edition High Availability.
```
# mkdir -p /u01/app/oracle
# chown oracle:oinstall /u01/app/oracle
```
As the oracle user, run the addnode.sh script from the first node to perform the following operations on the other nodes on which you want to configure Standard Edition High Availability:
- Copy the Oracle home directory from the first node to the other nodes.
- Setup Oracle base and Oracle inventory directories on the other nodes.
```
$ $ORACLE_HOME/addnode/addnode.sh -silent CLUSTER_NEW_NODES=comma_separated_list_of_other_nodes
```
As the root user, run the root.sh script on all the other cluster nodes on which you are configuring Standard Edition High Availability.
```
# /u01/app/oracle/product/19.0.0/dbhome_1/root.sh
```

After the Oracle Database software installation is complete, use Oracle Database Configuration Assistant (Oracle DBCA), in either interactive or silent mode, to create a Standard Edition database on the first cluster node on which you installed the Oracle Database software.

For more information about the requirements for creating a database, and the procedure for enabling and configuring Standard Edition High Availability for Oracle Databases, refer to Oracle Database Administrator's Guide.

Installing Standard Edition High Availability Database Software on Oracle ACFS

You can install Oracle Database software binaries on an Oracle ASM Cluster File System (Oracle ACFS) volume to enable the Oracle Database Standard Edition High Availability feature.

Before you start the installation, have all the information you need about users groups, and storage paths. You should also be prepared to run root scripts or provide information to automate root scripts.

As the root user, register Oracle ACFS as an Oracle Clusterware resource specifying the Oracle Database software owner user (oracle) as the mount owner.
```
# Grid_home/bin/srvctl add filesystem -volume acfs_volume_name -diskgroup diskgroup_name -path mount_point -fstype ACFS -autostart ALWAYS -user oracle
```
Note:
Mount Oracle ACFS to a mount point where you plan to create Oracle base and Oracle home directories for this installation. For example, /u01/app/oracle.
As the oracle user, mount the Oracle ACFS file system on all of the cluster nodes on which you want to configure Standard Edition High Availability.
```
$ Grid_home/bin/srvctl start filesystem -volume acfs_volume_name -diskgroup diskgroup_name
```
As the root user, create the Oracle base directory in an Oracle ACFS volume on the first cluster node on which you want to configure Standard Edition High Availability. Follow the Oracle Optimal Flexible Architecture (OFA) recommendations and specify the correct owner, group, and permissions for this directory.
```
# mkdir -p /u01/app/oracle
# chown oracle:oinstall /u01/app/oracle
```
Note:
If you have configured the Oracle ACFS file system with the oracle user as the mount owner and the /u01/app/oracle directory as the mount point, then this step is not required.
Log in to the first cluster node as the Oracle Database software owner user (oracle).
Download the Oracle Database 19c release 19.3 installation image file (db_home.zip) from Oracle Software Delivery Cloud website to a directory of your choice.
https://edelivery.oracle.com/
Download the Oracle Database Release Update 19.7 or later patch from My Oracle Support to a directory of your choice and unzip it.
https://support.oracle.com/
Create an OFA-compliant Oracle home directory in an Oracle ACFS volume and extract the image files that you have downloaded in to this Oracle home directory. For example:
```
$ mkdir -p /u01/app/oracle/product/19.0.0/dbhome_1
$ cd /u01/app/oracle/product/19.0.0/dbhome_1
$ unzip -q /tmp/db_home.zip
```
From the Oracle home directory, run the runInstaller command with the -applyRU flag to start the Oracle Database Setup Wizard and apply the Oracle Database Release Update 19.7 or later patch during installation.
```
$ ./runInstaller -applyRU patch_directory_location/patch_ID
```
Note:
Run the runInstaller command from the Oracle home directory only. Do not use the runInstaller command that resides at $ORACLE_HOME/oui/bin/, or any other location, to install Oracle Database.
In the Select Configuration Option screen, select Set Up Software Only.
In the Select Database Installation Option screen, select Single instance database installation.
In the Select Database Edition screen, select Standard Edition 2.
Respond to the configuration prompts as needed.
Provide information to automate root scripts, or run scripts as root when prompted by the setup wizard.

If you configure automation for running root scripts, and a root script fails, then you can fix the problem manually, and click Retry to run the root script again.

Note:
Click Help if you have any questions about the information you are asked to submit during installation.
Optional: As the oracle user, enable read-only Oracle home on the first cluster node.
```
$ $ORACLE_HOME/bin/roohctl -enable
```
Attach the Oracle home on the first node to the other cluster nodes on which you want to configure Standard Edition High Availability.
```
$ $ORACLE_HOME/addnode/addnode.sh -silent CLUSTER_NEW_NODES=comma_separated_list_of_other_nodes
```
As the root user, run the root.sh script on all the other cluster nodes on which you are configuring Standard Edition High Availability.
```
# /u01/app/oracle/product/19.0.0/dbhome_1/root.sh
```