RE: Unable to create SPFILE.

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