Unable to create SPFILE. 2005-10-12 - By Reidy, Ron
You have to restart your DB using the spfile, and read the docs.
-- --Original Message-- --
From: oracle-l-bounce@(protected)
[mailto:oracle-l-bounce@(protected)] 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.
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
This electronic message transmission is a PRIVATE communication which contains
information which may be confidential or privileged. The information is
intended
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.
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>Message</TITLE>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2900.2722" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=005500115-12102005><FONT face=Arial color=#0000ff size=2>You
have to restart your DB using the spfile, and read the docs.</FONT></SPAN></DIV>
<DIV></DIV>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left><FONT face=Tahoma
size=2>-- --Original Message-- --<BR><B>From:</B> oracle-l-bounce@(protected)
[mailto:oracle-l-bounce@(protected)] <B>On Behalf Of </B>Chirag
DBA<BR><B>Sent:</B> Wednesday, October 12, 2005 8:19 AM<BR><B>To:</B> Marquez,
Chris<BR><B>Cc:</B> Oracle-L Freelists<BR><B>Subject:</B> Re: Unable to create
SPFILE.<BR><BR></FONT></DIV>
<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)</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)"
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></BODY><P
align=left style="MARGIN-RIGHT: 0px"><FONT face=Tahoma size=2><FONT color=
#0000ff>
<HR>
</FONT></FONT><FONT face=Tahoma size=2><FONT color=#0000ff>This electronic
message transmission is a PRIVATE communication which contains information <BR
>which may be confidential or privileged. The information is intended to be for
the use of the individual <BR>or entity named above. If you are not the
intended recipient, please be aware that any disclosure, <BR>copying,
distribution or use of the contents of this information is prohibited. Please
notify the sender <BR>of the delivery error by replying to this message, or
notify us by telephone (877-633-2436, ext. 0), <BR>and then delete it from your
system.</FONT></FONT></P></HTML>
|
|
