首先以Oracle用户登录节点1: [oracle@rac1 ~]$ sqlplus /nolog SQL>conn sys/yourpasswd@instance1 as sysdba SQL>alter system set shared_pool_size=1000M scope=spfile; SQL>alter system set large_pool_size=200M scope=spfile; SQL>alter system set java_pool_size=200M scope=spfile; SQL>alter system set db_cache_size=18000M scope=spfile; SQL>shutdown immediate SQL>startup 节点1修改完成。
然后以Oracle用户登录节点2: [oracle@rac2 ~]$ sqlplus /nolog
SQL>conn sys/yourpasswd@instance2 as sysdba
SQL>alter system set shared_pool_size=1000M scope=spfile;
SQL>alter system set large_pool_size=200M scope=spfile;
SQL>alter system set java_pool_size=200M scope=spfile;
SQL>alter system set db_cache_size=18000M scope=spfile;
SQL>shutdown immediate
SQL>startup
节点2修改完成。