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

I got ” ORA-32018: parameter cannot be modified in memory on another instance ” error in Oracle database during parameter change on Oracle database.

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

Details of error are as follows.

SQL> alter system set shared_pool_size=10000M scope=both sid='*';
alter system set shared_pool_size=10000M scope=both sid='*'
*
ERROR at line 1:
ORA-32018: parameter cannot be modified in memory on another instance

SQL>

parameter cannot be modified in memory on another instance

This ORA-32018 error is related with the database environment is using Real Application Clusters (RAC).  This error will not be seen in a non-RAC environment.

In some cases, a parameter can only be changed for a specific instance from the node where that instance is running.  In the example above, using SID=’*’ is causing this error because the SID in the command does not match the SID running on the node.

This error can also occur when using the specific instance name for the SID. For example, assume we attempt to change the value of shared_pool_size with SID=’INSTANCE1′ from a node where INSTANCE1 is *not* running. We get the same error:

SQL> alter system set shared_pool_size=10000M scope=both sid='*';
alter system set shared_pool_size=10000M scope=both sid='*'
*
ERROR at line 1:
ORA-32018: parameter cannot be modified in memory on another instance

SQL>

To solve this error, Change the value of the parameter on the node where each specific instance is running. For example:

On node 1 - 

ALTER SYSTEM SET SHARED_POOL_SIZE=8g SCOPE=both SID='INSTANCE1';

On node 2 - 

ALTER SYSTEM SET SHARED_POOL_SIZE=8g SCOPE=both SID='INSTANCE2';

On node 3 - 

ALTER SYSTEM SET SHARED_POOL_SIZE=8g SCOPE=both SID='INSTANCE3';

Do you want to learn more details about RMAN, then Click this Link and read the articles.

RMAN Tutorial | Backup, Restore and Recovery Tutorials For Beginner Oracle DBA