<<Back to Oracle RAC Main Page
How to Fix ORA-65500: could not modify DB_UNIQUE_NAME, resource exists
SQL> alter system set db_unique_name='TST1TP' scope=spfile;alter system set db_unique_name='TST1TP' scope=spfile
*
ERROR at line 1:
ORA-32017: failure in updating SPFILE
ORA-65500: could not modify DB_UNIQUE_NAME, resource exists
Cause: The cause of the issue is an entry of the resource in clusterware repository.
Bug 20876249 : COULD NOT
MODIFY DB_UNIQUE_NAME RESOURCE EXISTS
Solution1:
Remove the configuration from crs repository
$ srvctl config database -d TST1T
$ srvctl status database -d TST1T
Database is running.
$ srvctl remove database -d TST1T -f
Modify the parameter in SPFILE and Restart the databaseSQL> alter system set db_unique_name='TST1TP' scope=spfile;
System altered.
SQL> startup force;
ORACLE instance started.
Total System Global Area 2147483648 bytes
Fixed Size 8794848 bytes
Variable Size 1912605984 bytes
Database Buffers 218103808 bytes
Redo Buffers 7979008 bytes
Database mounted.
Database opened.
Add the DB resource to CRS repository
$ srvctl add database -db TST1TP -oraclehome /u01/dbatst1/12.2.0.1/dbp1 -spfile /u01/dbatst1/12.2.0.1/dbp1/dbs/spfileTST1T.ora
Solution2:
Create pfile from spfile
SQL> create pfile from spfile;
File created.
Manually edit the pfile and add/modify the db_unique_name parameter
*.db_unique_name='TST1TP'
Stop the database
SQL> shut immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
Create the spfile from pfile
SQL> create spfile from pfile;
File created.
Start the database with updated spfile
SQL> startup
ORACLE instance started.
Total System Global Area 2147483648 bytes
Fixed Size 8794848 bytes
Variable Size 1912605984 bytes
Database Buffers 218103808 bytes
Redo Buffers 7979008 bytes
Database mounted.
Database opened.
Verify the change
SQL> show parameter unique
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_unique_name string TST1TP
Remove the DB configuration from crs repository
$ srvctl remove database -d TST1T -f
Add the DB resource Configuration to CRS repository
$ srvctl add database -db TST1TP -oraclehome /u01/dbatst1/12.2.0.1/dbp1 -spfile /u01/dbatst1/12.2.0.1/dbp1/dbs/spfileTST1T.ora
Thanks for shearing this kind of information clone
ReplyDelete