ORA-65500: could not modify DB_UNIQUE_NAME, resource exists

ORA-65500: could not modify DB_UNIQUE_NAME, resource exists

ORCL1> show parameter spfile

NAME                                 TYPE            VALUE
------------------------------------ --------------- ------------------------------
spfile                               string          +DATA01/ORCL/spfile

ORCL1> alter system set db_unique_name="ORCLP" scope=spfile sid='*';
alter system set db_unique_name="ORCLP" scope=spfile sid='*'
*
ERROR at line 1:

ORA-32017: failure in updating SPFILE
ORA-65500: could not modify DB_UNIQUE_NAME, resource exists

Bug 20876249 : COULD NOT MODIFY DB_UNIQUE_NAME RESOURCE EXISTS

Workaround

1. Manually edit the pfile and added the entry

*.db_unique_name='ORCLP'

2. startup the db using the pfile

SQL> startup pfile='/local/dbms/oracle/product/12.1.0.2/db_1/dbs' ;

3.created the spfile from the pfile

SQL> create spfile='+DATA01/ORCL/spfile' from
pfile='/local/dbms/oracle/product/12.1.0.2/db_1/dbs';

File created.

4.set the spfile parameter
SQL> alter system set spfile='+DATA01/ORCL/spfile'  ;
System altered.