ORA-65500: could not modify DB_UNIQUE_NAME, resource exists

Issue:  Unable to change DB_UNIQUE_NAME after failover from PRIMARY TO STANDBY

SQL> alter system set db_unique_name=MWMPPROD scope=spfile;
alter system set db_unique_name=MWMPPROD scope=spfile
*
ERROR at line 1:
ORA-32017: failure in updating SPFILE
ORA-65500: could not modify DB_UNIQUE_NAME, resource exists

Solution: We need to switch back to PRIMARY instead of making a change in db unique name:

On Standby (old Primary)

ALTER DATABASE ACTIVATE PHYSICAL STANDBY DATABASE;

On Primary (Old Standby)

ALTER DATABASE CONVERT TO PHYSICAL STANDBY;

 

Nagulu Polagani

"We are all apprentices in a craft where no one ever becomes a master."

Latest posts by Nagulu Polagani (see all)