Change the parameters for RAC database

Change the parameters for RAC database:

1) Login to prod1 server as ORACLE user.

2) Set the . oraenv to orcl1

3) Login to the database as sysdba

3.1) select STATUS,INSTANCE_NUMBER,INSTANCE_NAME from gv$instance;

3.2) Show parameter sga; (this would show the current value for sga_max_size and sga_target to be 500MB)

3.3) alter system set sga_max_size=1g scope=spfile SID='*';

3.4) alter system set sga_target=1g scope=spfile SID='*';

3.5) exit

4) srvctl stop instance -d ORCL -i ORCL1

5) srvctl start instance -d ORCL -i ORCL1

6) Check the alertlog and the listener logs and confirm all ok.

*********************

7) ssh PROD2 server.

8) set the environment .oraenv to ORCL2

9) srvctl stop instance -d ORCL -i ORCL2

10) srvctl start instance -d ORCL -i ORCL2

11) Check the alertlog and the listener logs and confirm all ok.

***********************

12) ssh PROD3 server.

13) set the environment .oraenv to ORCL3

14) srvctl stop instance -d ORCL -i ORCL3

15) srvctl start instance -d ORCL -i ORCL3

16) Check the alertlog and the listener logs and confirm all ok.

************************

17) ssh PROD4 server

18) set the environment .oraenv to ORCL4

19) srvctl stop instance -d ORCL -i ORCL4

20) srvctl start instance -d ORCL -i ORCL4

21) Check the alertlog and the listener logs and confirm all ok