Strange ... database won't let you change the db_name in the spfile when the database is mounted.
SYS AS SYSDBA@tl01bko1> alter system set db_name='t01bko' scope=spfile;
System altered.
SYS AS SYSDBA@tl01bko1> alter database mount;
Database altered.
SYS AS SYSDBA@tl01bko1> alter system set db_name='t01bko' scope=spfile;
alter system set db_name='t01bko' scope=spfile
*
ERROR at line 1:
ORA-32017: failure in updating SPFILE
ORA-32016: parameter "db_name" cannot be updated in SPFILE
Subscribe to:
Post Comments (Atom)
1 comment:
The DB_NAME can only be changed if you are using the DBNEWID command OR recreating the control file.
Hemant K Chitale
Post a Comment