Re: cannot delete entry from spfile

Hi,

in sqlplus

connect / as sysdba
SQL>create pfile from spfile;

in $ORACLE_HOME/database edit and change file initDB_NAME.ora

and
SQL>create spfile from pfile.

Christophe.

"Ed Stevens" <nospam_at_noway.nohow> a écrit dans le message de news:oeapq05hat5kujcuujf72hab2smvm2rcvo_at_4ax.com...
> On Tue, 30 Nov 2004 17:32:03 +0100, "Cookie Monster"
> <cookie.monster_at_somewhere.com> wrote:
>
> >Hi,
> >
> >I have an entry in the spfile as follows:
> >
> >max_enabled_roles = 30
> >
> >When I start oracle (10g) I get the error message 'ORA-32004: obsolete
> >and/or deprecated parameters(s) specified'.
> >
> >The oracle documentation states that :
> >Deleting Initialization Parameter Values. If an initialization parameter
> >takes a value that is a string, you can restore the value to its default
> >value by using empty single quote marks, as follows:
> >
> >ALTER SYSTEM SET parameter = '';
> >
> >For numeric and boolean value parameters, you must explicitly set the
> >parameter back to its original default value.
> >
> >Well I did this and set max_enabled_roles to the default value of '30'.
But
> >I still get the error on startup. Does anyone know how I can remove this
> >entry..or is it there forever.
> >
> >Thanks!
> >
> >Steve
> >
> >
> >
>
> Gen it to a pfile, edit to your heart's content, then gen it back to a
> spfile. I leave the syntax details to the student as homework.
Received on Tue Nov 30 2004 - 11:22:31 CST