create pfile from spfile in RAC 2006-03-19 - By LiShan Cheng
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>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>
|
|
