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

 6,840 views last month,  2 views today

About Mehmet Salih Deveci

I am Founder of SysDBASoft IT and IT Tutorial and Certified Expert about Oracle & SQL Server database, Goldengate, Exadata Machine, Oracle Database Appliance administrator with 10+years experience.I have OCA, OCP, OCE RAC Expert Certificates I have worked 100+ Banking, Insurance, Finance, Telco and etc. clients as a Consultant, Insource or Outsource.I have done 200+ Operations in this clients such as Exadata Installation & PoC & Migration & Upgrade, Oracle & SQL Server Database Upgrade, Oracle RAC Installation, SQL Server AlwaysOn Installation, Database Migration, Disaster Recovery, Backup Restore, Performance Tuning, Periodic Healthchecks.I have done 2000+ Table replication with Goldengate or SQL Server Replication tool for DWH Databases in many clients.If you need Oracle DBA, SQL Server DBA, APPS DBA,  Exadata, Goldengate, EBS Consultancy and Training you can send my email adress [email protected].-                                                                                                                                                                                                                                                 -Oracle DBA, SQL Server DBA, APPS DBA,  Exadata, Goldengate, EBS ve linux Danışmanlık ve Eğitim için  [email protected] a mail atabilirsiniz.

Leave a Reply