Re: Unable to create SPFILE.

I put my audit_trail=os. wanted to change to DB, but unable to do that on
the fly.
 SQL> alter system set audit_trail=DB;
alter system set audit_trail=DB
*
ERROR at line 1:
ORA-02095: specified initialization parameter cannot be modified
 SQL> ALTER SYSTEM SET audit_trail=DB SCOPE=SPFILE;
ALTER SYSTEM SET audit_trail=DB SCOPE=SPFILE
*
ERROR at line 1:
ORA-32001: write to SPFILE requested but no SPFILE specified at startup

Now is it like, I startup my db with spfile and then do
alter system set audit_trail=DB scope=pfile;
create pfile from spfile;
 hope this should work.
 regards - chirag
 On 10/12/05, Hallas, John, Tech Dev <John.Hallas@xxxxxxxxxxxxxxxxx> wrote:
>
>  After restarting the database with the spfile if you do a show parameter
> spfile does it show that it is using the file in the location you specified?
>
>  If it is then alter system set audit_trail = DB scope =spfile; and
> reboot. Ensure that your initSID.ora file piles to the spfile
>
>  If that does not solve your problem then I am afraid I do not fully
> understand the issue
>
>  John
>
>   ------------------------------
>
> *From:* oracle-l-bounce@xxxxxxxxxxxxx [mailto:
> oracle-l-bounce@xxxxxxxxxxxxx] *On Behalf Of *Chirag DBA
> *Sent:* 12 October 2005 14:45
> *To:* Oracle-L Freelists
> *Subject:* Unable to create SPFILE.
>
>  I have started my Database with pfile and now want to create spfile.
>
>  I am using create spfile='location' from pfile;
>
>  When I see the audit parameters in pfile, it is AUDIT_TRAIL=DB,
>
> but in SPFILE it is showing as AUDIT_TRAIL=OS, set previously but changed
> now.
>
> same with few other parameters.
>
> I changed my init file, bounce DB with pfile and now creating spfile.
>
>  This is 9i with Solaris.
>
>  regards - chirag
>
>

Other related posts: