Friday, November 27, 2009

ORA-32016: parameter "db_name" cannot be updated in SPFILE

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