RE: Unable to create SPFILE.

  • From: "Reidy, Ron" <Ron.Reidy@xxxxxxxxxxxxxxxxxx>
  • To: <chiragdba@xxxxxxxxx>, "Marquez, Chris" <cmarquez@xxxxxxxxxxxxxxxx>
  • Date: Wed, 12 Oct 2005 09:02:33 -0600

You have to restart your DB using the spfile, and read the docs.
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Chirag DBA
Sent: Wednesday, October 12, 2005 8:19 AM
To: Marquez, Chris
Cc: Oracle-L Freelists
Subject: Re: Unable to create SPFILE.

I have started with pfile, by changing audit_trail=DB.
startup pfile='file name'.
show parameter audit.
create spfile='location' from pfile;
File created..!!
but when see the spfile, *.audit_trail='OS';
I was thinking that while you do the create spfile, it is creating a
binary copy of pfile matching exactly with pfile.
but this is something unexpected I am getting.
regards - chirag 

On 10/12/05, Marquez, Chris <cmarquez@xxxxxxxxxxxxxxxx> wrote: 

        Sorry meant to say;
        SQL> startup pfile ='/[your changed pfile]';
        SQL> show parameter audit
        SQL> create spfile='.....' from pfile='....';
        SQL> shutdown;
        SQL> startup spfile ='/[your new spfile]'; 
        SQL> show parameter audit
        If this is a bug or feature this will show it.
        Chris Marquez
        Oracle DBA
        -----Original Message-----
        From: oracle-l-bounce@xxxxxxxxxxxxx on behalf of Marquez, Chris
        Sent: Wed 10/12/2005 10:06 AM
        To: chiragdba@xxxxxxxxx ; Oracle-L Freelists
        Subject: RE: Unable to create SPFILE.
        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@xxxxxxxxxxxxx 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
         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
        same with few other parameters. 
        I changed my init file, bounce DB with pfile and now creating
         This is 9i with Solaris.
         regards - chirag

This electronic message transmission is a PRIVATE communication which contains
information which may be confidential or privileged. The information is 
to be for the use of the individual or entity named above. If you are not the 
intended recipient, please be aware that any disclosure, copying, distribution 
or use of the contents of this information is prohibited. Please notify the
sender  of the delivery error by replying to this message, or notify us by
telephone (877-633-2436, ext. 0), and then delete it from your system.

Other related posts: