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_at_gb.vodafone.co.uk> 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_at_freelists.org [mailto:
> oracle-l-bounce_at_freelists.org] *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
>
>

--
http://www.freelists.org/webpage/oracle-l