Tuesday, June 25, 2013

ORA-32018: parameter cannot be modified in memory on another instance


##########################
## Error
##########################

ORA-32018: parameter cannot be modified in memory on another instance

### Full Error

SQL> Alter system set large_pool_size=1.3g;
Alter system set large_pool_size=1.3g
*
ERROR at line 1:
ORA-32018: parameter cannot be modified in memory on another instance

##########################
#  Error Occurred
##########################

Error occured while trying to modify the large_pool_size parameter in RAC database,

##########################
## Command Executed
##########################

Alter system set large_pool_size=1.3g;

(or)

Alter system set large_pool_size=1.3g sid='*';

##########################
## Issue Description.
##########################

###

Parameter cant be changed in another instance, needs to be changed by logging to each instance.

##########################
## Solution
##########################

Mention the SID of that particular instance to be changed. Do the same in other instances by changing their instance names.

Alter system set large_pool_size=1300m sid='rac11gn1';