create pfile from spfile in RAC 2006-03-20 - By LiShan Cheng
Hi
You dont need to start the instance to create pfile/spfile from
spfile/pfile. I have however found the culprit. In the beginning I thought
RAC was using a spfile but it turns out it was using a pfile which contains
a single line pointing to a spfile located in the raw device and that is why
it was saying ORA-27037 (See ORA-27037.ora-code.com): unable to obtain file status
please note how creating pfile and spfile works when instance is not
started:
Single Instance:
[oracle@(protected) oracle]$ sqlplus "/ as sysdba"
SQL*Plus: Release 10.2.0.1.0 - Production on Mon Mar 20 14:14:28 2006
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to an idle instance.
SQL> create spfile from pfile;
File created.
SQL> create pfile = '/tmp/init.ora' from spfile;
File created.
RAC:
[oracle@(protected) oracle]$ sqlplus / as sysdba
SQL*Plus: Release 10.2.0.1.0 - Production on Mon Mar 20 14:17:23 2006
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to an idle instance.
SQL> create spfile='/tmp/spfile.ora' from pfile;
File created.
SQL> create pfile='/tmp/pfile.ora' from spfile;
create pfile='/tmp/pfile.ora' from spfile
*
ERROR at line 1:
ORA-27037 (See ORA-27037.ora-code.com): unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3
Cheers
On 3/20/06, sol beach <sol.beach@(protected)> wrote:
>
> >connected to an idle instance
>
> What part of the above do you NOT understand?
> The database is DOWN.
> You must have the database up & online to create a pfile.
>
> oerr ora 4030
> 04030, 00000, "out of process memory when trying to allocate %s bytes
> (%s,%s)"
> // *Cause: Operating system process private memory has been exhausted
> // *Action:
>
> What did you change prior to shutdown?
>
>
>
>
> On 3/19/06, LiShan Cheng <exriscer@(protected)> wrote:
>
> > Hi
> >
> > I have modified some SGA related parameters in a RAC installation, two
> > nodes and modified in both through spfile located in a raw device (ASM). The
> > problem is after restarting the database both instance failed to start
> > because it caused ORA-04030 (See ORA-04030.ora-code.com).
> >
> > I have tried to create pfile using pfile by performing following
> > procedure:
> >
> >
> > connect / as sysdba
> > connected to an idle instance
> >
> > create pfile from spfile;
> >
> > Error: Not logon
> >
> > This same operation works in single instance database so I guess this is
> > expected behaviour in RAC?
> >
> >
> > TIA
> >
> >
> >
>
>
>
<div>Hi</div>
<div> </div>
<div>You dont need to start the instance to create pfile/spfile from spfile
/pfile. I have however found the culprit. In the beginning I thought RAC was
using a spfile but it turns out it was using a pfile which contains a single
line pointing to a spfile located in the raw device and that is why it was
saying ORA-27037 (See ORA-27037.ora-code.com): unable to obtain file status
</div>
<div> </div>
<div>please note how creating pfile and spfile works when instance is not
started:</div>
<div> </div>
<div>Single Instance:</div>
<p>[oracle@(protected) oracle]$ sqlplus "/ as sysdba"</p>
<p>SQL*Plus: Release 10.2.0.1.0 - Production on Mon Mar 20 14:14:28 2006</p>
<p>Copyright (c) 1982, 2005, Oracle. All rights reserved.<br>Connected to
an idle instance.</p>
<p>SQL> create spfile from pfile;</p>
<p>File created.</p>
<p>SQL> create pfile = '/tmp/init.ora' from spfile;</p>
<p>File created.</p>
<div><br>RAC:</div>
<div>
<p>[oracle@(protected) oracle]$ sqlplus / as sysdba</p>
<p>SQL*Plus: Release 10.2.0.1.0 - Production on Mon Mar 20 14:17:23 2006</p>
<p>Copyright (c) 1982, 2005, Oracle. All rights reserved.</p>
<p>Connected to an idle instance.</p>
<p>SQL> create spfile='/tmp/spfile.ora' from pfile;</p>
<p>File created.</p>
<p>SQL> create pfile='/tmp/pfile.ora' from spfile;<br>create pfile='/tmp
/pfile.ora' from spfile<br>*<br>ERROR at line 1:<br>ORA-27037 (See ORA-27037.ora-code.com): unable to obtain
file status<br>Linux Error: 2: No such file or directory<br>Additional
information: 3
</p>
<p> </p>
<p>Cheers</p>
<p> </p>
<p> </p></div>
<div><span class="gmail_quote">On 3/20/06, <b class="gmail_sendername">sol
beach</b> <<a href="mailto:sol.beach@(protected)">sol.beach@(protected)</a>>
wrote:</span>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0
.8ex; BORDER-LEFT: #ccc 1px solid">
<div style="DIRECTION: ltr">
<div></div>
<div style="DIRECTION: ltr"><span class="q">>connected to an idle instance
<br><br></span></div>
<div style="DIRECTION: ltr">What part of the above do you NOT understand?<br
>The database is DOWN.<br>You must have the database up & online to create a
pfile.<br><br> oerr ora 4030<br>04030, 00000, "out of process memory
when trying to allocate %s bytes (%s,%s)"
<br>// *Cause: Operating system process private memory has been exhausted
<br>// *Action: <br><br>What did you change prior to shutdown?<br><br> <
/div><br><br>
<div></div>
<div style="DIRECTION: ltr"><span class="q"><span class="gmail_quote">On 3/19
/06, <b class="gmail_sendername">LiShan Cheng</b> <<a onclick="return top.js
.OpenExtLink(window,event,this)" href="mailto:exriscer@(protected)" target="_blank
">
exriscer@(protected)</a>> wrote:</span></span></div>
<div style="DIRECTION: ltr"><span class="e" id="q_10a1548751334677_4">
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0pt 0pt 0pt 0
.8ex; BORDER-LEFT: rgb(204,204,204) 1px solid">
<div style="DIRECTION: ltr">
<div>Hi</div>
<div> </div>
<div>I have modified some SGA related parameters in a RAC
installation, two nodes and modified in both through spfile located in a raw
device (ASM). The problem is after restarting the database both instance failed
to start because it caused ORA-04030 (See ORA-04030.ora-code.com).
</div>
<div> </div>
<div>I have tried to create pfile using pfile by performing following procedure
:</div>
<div> </div>
<div> </div>
<div>connect / as sysdba</div>
<div>connected to an idle instance</div>
<div> </div>
<div>create pfile from spfile;</div>
<div> </div>
<div>Error: Not logon</div>
<div> </div>
<div>This same operation works in single instance database so I guess this is
expected behaviour in RAC?</div>
<div> </div>
<div> </div>
<div>TIA</div>
<div> </div>
<div> </div></div></blockquote></span></div>
<div style="DIRECTION: ltr"></div><br> </div></blockquote></div><br>
|
|
