Please try the solutions/recommendations in your test environment. All the posts in my blogs are my personal experience. It may or may not work. Please try at your own risk. Blogger will not be responsible for any loss suffered as a result of following any of this blog posts.. Happy Learning...
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';
Subscribe to:
Posts (Atom)