Unable to create SPFILE. 2005-10-12 - By Chirag DBA
I have started with pfile, by changing audit_trail=DB.
startup pfile='file name'.
show parameter audit.
audit_trail=DB
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@(protected)> 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@(protected) on behalf of Marquez, Chris
> Sent: Wed 10/12/2005 10:06 AM
> To: chiragdba@(protected); 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@(protected) 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
>
>
>
>
<div>I have started with pfile, by changing audit_trail=DB.</div>
<div> </div>
<div>startup pfile='file name'.</div>
<div>show parameter audit.</div>
<div>audit_trail=DB</div>
<div>create spfile='location' from pfile;</div>
<div>File created..!!</div>
<div> </div>
<div>but when see the spfile, *.audit_trail='OS';</div>
<div> </div>
<div>I was thinking that while you do the create spfile, it is creating a
binary copy of pfile matching exactly with pfile.</div>
<div> </div>
<div>but this is something unexpected I am getting.</div>
<div> </div>
<div>regards - chirag <br><br> </div>
<div><span class="gmail_quote">On 10/12/05, <b class="gmail_sendername">Marquez
, Chris</b> <<a href="mailto:cmarquez@(protected)">cmarquez@(protected)
.org</a>> wrote:</span>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0
.8ex; BORDER-LEFT: #ccc 1px solid">
<p><font size="2">Sorry meant to say;<br><br>SQL> startup pfile ='/[your
changed pfile]';<br>SQL> show parameter audit<br>SQL> create spfile='....
.' from pfile='....';<br>SQL> shutdown;<br>SQL> startup spfile ='/[your
new spfile]';
<br>SQL> show parameter audit<br><br>If this is a bug or feature this will
show it.<span class="q"><br><br><br>Chris Marquez<br>Oracle DBA<br><br><br><br>
-- --Original Message-- --<br></span><span class="q">From: <a onclick="return
top.js.OpenExtLink(window,event,this)" href="mailto:oracle-l-bounce@(protected)
.org" target="_blank">
oracle-l-bounce@(protected)</a> on behalf of Marquez, Chris<br>Sent: Wed 10
/12/2005 10:06 AM<br>To: <a onclick="return top.js.OpenExtLink(window,event,this
)" href="mailto:chiragdba@(protected)" target="_blank">chiragdba@(protected)
</a>; Oracle-L Freelists<br>Subject: RE: Unable to create SPFILE.<br><br><br
>You sure you are using the right (default) pfile on startup?<br><br>do this;<br
>SQL> startup; [as you normaly would]<br>SQL> show parameter audit
<br><br>???<br><br>Something got to be a miss on your end...or this would be a
scary (documented) bug?<br><br>Chris Marquez<br>Oracle DBA<br><br>-- --Original
Message-- --<br>From: <a onclick="return top.js.OpenExtLink(window,event,this)"
href="mailto:oracle-l-bounce@(protected)" target="_blank">
oracle-l-bounce@(protected)</a> on behalf of Chirag DBA<br>Sent: Wed 10/12
/2005 9:45 AM<br></span><span class="q">To: Oracle-L Freelists<br>Subject:
Unable to create SPFILE.<br><br>I have started my Database with pfile and now
want to create spfile.
<br> I am using create spfile='location' from pfile;<br> When I see
the audit parameters in pfile, it is AUDIT_TRAIL=DB,<br>but in SPFILE it is
showing as AUDIT_TRAIL=OS, set previously but changed<br>now.<br>same with few
other parameters.
<br>I changed my init file, bounce DB with pfile and now creating spfile.<br>
This is 9i with Solaris.<br> regards - chirag<br><br><br><br></span><
/font></p></blockquote></div><br>
|
|
