Can I add memory on ODA X8-2 HA RAC environment during online processing without stopping DB running
Hi,
I have a ODA X8-2 HA with two instances on DB 11.2.0.4/GRID 19.8 environment.
I plan to add memory from 384GB to 768GB one by one node during online processing as follows;
- Node1 is poweroff, insert 384GB Memory, poweron and check total 768GB (32GB * 24) during node2 online status.
- Node1 is 768GB and Node2 is 384GB RAC status.
- Node2 is poweroff, insert 384GB Memory, poweron and check total 768GB (32GB * 24) during node1 online status.
- Node1 is 768GB and Node2 is 768GB RAC status. They are not changed SGA, Hugepages and etc.
- srvctl stop instance -d AZWEL -i AZWEL1 -o immediatesrvctl stop instance -d EZBILL -i AZBILL1 -o immediatealter system set sga_max_size=128G scope=spfile sid = '*';alter system set sga_target=128G scope=spfile sid = '*';alter system set pga_aggregate_target=64G scope=spfile sid = '*';alter system set processes=6400 scope=spfile sid = '*';sysctl -w vm.nr_hugepages=108000 /etc/sysctl.conf → vm.nr_hugepages=108000 edit cat /proc/meminfo → HugePages_Total=108000 verifyii) SGA 128GB, PGA 64GB, PROCESS 6400 settingiii) Huge page settingiv) Restart DB instance to adopt these parameters or Node1 rebootv) follow step i ~ iv for node2.
0