Skip to content
Home » Oracle » How to Resolve ORA-32016: parameter "db_name" cannot be updated in SPFILE

How to Resolve ORA-32016: parameter "db_name" cannot be updated in SPFILE

ORA-32016

Tried to change DB_NAME in SPFILE when the instance is running, but it failed with ORA-32016. Let's see current value of DB_NAME.

SQL> show parameter db_name

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_name                              string      TESTCDB
SQL> alter system set db_name='ORCLCDB' scope=spfile sid='*';
alter system set db_name='ORCLCDB' scope=spfile sid='*'
*
ERROR at line 1:
ORA-32017: failure in updating SPFILE
ORA-32016: parameter "db_name" cannot be updated in SPFILE

ORA-32016 means that such parameter is not allowable to change when the instance is running, no matter the instance is NOMOUNT, MOUNT or OPEN.

Solution

That is to say, you have to shutdown the database to make it idle then change it. A parameter file (PFILE) can always come into play in such situation. So the first step is to create a PFILE for later modification.

For more details, you may check the following posts:

Leave a Reply

Your email address will not be published. Required fields are marked *