RE: Unable to create SPFILE.

From: Marquez, Chris <cmarquez_at_collegeboard.org>
Date: Wed, 12 Oct 2005 10:06:20 -0400
Message-ID: <B30C2483766F9342B6AEF108833CC84E05BD5FF2@ecogenemld50.Org.Collegeboard.local>

You sure you are using the right (default) pfile on startup?

do this;
SQL> startup; [as you normaly would]
SQL> show parameter audit

???

Something got to be a miss on your end...or this would be a scary (documented) bug?

Chris Marquez
Oracle DBA

-----Original Message-----

From: oracle-l-bounce_at_freelists.org on behalf of Chirag DBA Sent: Wed 10/12/2005 9:45 AM
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 Received on Wed Oct 12 2005 - 09:13:01 CDT