Re: Unable to create SPFILE.
- From: Chirag DBA <chiragdba@xxxxxxxxx>
- To: "Hallas, John, Tech Dev" <John.Hallas@xxxxxxxxxxxxxxxxx>
- Date: Wed, 12 Oct 2005 10:11:49 -0400
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:
