Resizing database node VMs (GCP)

Resizing database node VMs may be needed for performance or cost reasons. Resizing can be done for one node at a time without causing database downtime.

To resize database node VMs in a running cluster repeat the following steps on each database node, one node at a time

1. Update SGA and PGA sizing parameters for the databases according to the new VM memory size

2. If using HugePages then update the vm.nr_hugepages parameter in /etc/sysctl.conf according to the new VM memory size

3. Make sure there are no other nodes that are in offline or re-syncing state. All disk groups must have zero offline disks and Resync = No:

   # flashgrid-cluster

4. Stop all local database instances running on the node.

5. Stop Oracle CRS on the node:

   # crsctl stop crs

6. Stop the FlashGrid Storage Fabric services on the node:

   # flashgrid-node stop

7. Stop the VM using GCP console

8. Resize the VM using GCP console

9. Start the VM using GCP console

10. Wait until all disks are back online and resyncing operations complete on all disk groups. All disk groups must have zero offline disks and Resync = No.

    # flashgrid-cluster

11. Start all database instances on the node

12. Proceed to the next node