ORA-65500: could not modify DB_UNIQUE_NAME, resource exists

I got “ORA-65500: could not modify DB_UNIQUE_NAME, resource exists ” error in Oracle database.

 

ORA-65500: could not modify DB_UNIQUE_NAME, resource exists

 

Details of error are as follows.

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

SQL>

 

 

ORA-65500 | ORA-32017: failure in updating SPFILE

 

This ORA-65500 error is related with the existing of same service in the CRS.

To solve this error, remove the existing service from CRS or use the different DB_UNIQUE_NAME

You can remove the existing service from CRS as follows.

srvctl remove database -d MSDBDR


Now you can set this DB_UNIQUE_NAME again.

SQL> alter system set db_unique_name='MSDBDR' scope=spfile sid='*';

System altered.

 

Or you should use the different db_unique_name.

 

Do you want to learn Oracle dataguard, then read the following articles.

Oracle DataGuard Physical Standby Installation Step by Step Using RMAN -1

 

 855 views last month,  1 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