Convert Oracle Restart to Cluster

Summary

This passage is based on Oracle 12.2.0.1 & 18.1.1.

Log down information

• Use srvctl config database -db <DB_UNIQUE_NAME>, srvctl config service -db <DB_UNIQUE_NAME>, srvctl config listener -listener <LISTENER_NAME> to detect configuration information.
• export SRVM_TRACE=true to enable srvctl log。

Stop resources

• Stop all database, services and listeners listed above by using srvctl stop database -db <DB_UNIQUE_NAME>, srvctl stop listener -listener <LISTENER_NAME>.

Unmount ACFS FS

• Unmount all existing Oracle ACFS FS by using ASMCA.

Deconfig

Run $GI_HOME/crs/install/roothas.sh –deconfig –force to unconfigure Oracle Restart with root user.

Export env variables

Export following environment variables:
- export oracle_install_asm_UseExistingDG=true or false
- export oracle_install_asm_DiskGroupName=disk_group_name
- export oracle_install_asm_DiskDiscoveryString=asm_discovery_string
- export oracle_install_asm_ConfigureGIMRDataDG=true or false
- export oracle_install_asm_GIMRDataDGName=disk_group_name

Install cluster to new location

If need to install in a new location, then set up GI software in new location with “Installing Only the Oracle GI Software”.

Install GI to existing location

Invoke gridSetup.sh and install GI with cluster settings to existing location.

Mount back DG

Mount ASM DG used by Oracle Restart.

Mount back ACFS FS

If used ACFS FS on Oracle Restart, start ASMCA and run volenable to enable Oracle Restart DG volumes. Mount all ACFS manually.

Add services, db, listeners listed in step 1.

Run following command as database user: $GI_HOME/bin/srvctl add database -db <DB_UNIQUE_NAME> -spfile <SP_FILE_LOCATION> [-pwfile <PW_FILE_LOCATION>] -oraclehome $DB_HOME -node <NODE_HOSTNAME>

Documents

• Convert Oracle Restart to Cluster
• SIDB to RAC using DBCA