Oracle DBA Script - Adjust AMM on RAC

Assume we would like to set memory target to 6000M

On Node 1:

1. Enter the DB instance via SQL Plus.  Enter the below command:
1. show spparameter target (to check the current setting)
2. ALTER SYSTEM SET MEMORY_MAX_TARGET = 600M scope=SPFILE;
3. ALTER SYSTEM SET MEMORY_TARGET = 600M scope=SPFILE;
4. ALTER SYSTEM SET SGA_TARGET = 0 scope=SPFILE;
5. ALTER SYSTEM SET PGA_AGGREGATE_TARGET = 0 scope=SPFILE;
6. show spparameter target (to check the new setting)
2. exit SQL Plus
3. Restart the instance at command prompt:
1. srvctl stop instance -d dbname -n dbnode01-o IMMEDIATE
2. srvctl start instance -d dbname -n dbnode01
4. Enter SQL plus again
5. verify the running parameter by this command:
1. show parameter target

Repeat the above procedure at node 2, with the appropriate change of node name at restart procedure.