Oracle Database Appliance (ODA) (MOSC)

MOSC Banner

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;

  1. Node1 is poweroff, insert 384GB Memory, poweron and check total 768GB (32GB * 24) during node2 online status.
  2. Node1 is 768GB and Node2 is 384GB RAC status.
  3. Node2 is poweroff, insert 384GB Memory, poweron and check total 768GB (32GB * 24) during node1 online status.
  4. Node1 is 768GB and Node2 is 768GB RAC status. They are not changed SGA, Hugepages and etc.
  5. 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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center