Tuesday 12 June 2012

include the parentheses

When changing the initialisation parm DB_DOMAIN remember to include the parentheses or you will get an unhelpful message.

SQL> alter system set db_domain=rosspdc.com.au scope=spfile;
alter system set db_domain=dbathrift.com scope=spfile
                 *
ERROR at line 1:
ORA-02095: specified initialization parameter cannot be modified


SQL> alter system set db_domain='dbathrift.com' scope=spfile;

System altered.

SQL> 

No comments:

Post a Comment