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: