Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to view spfile in ASM diskgroup while the database can’t be started?

614497Feb 17 2009 — edited Oct 17 2009

Hi All,

We are in 10.2.0.3 and server is window 2003. And the init.ora file has one line in it “SPFILE='+DG_DATA/MITCH/spfileMITCH.ora'”.

One time I can’t start the database and got the error below. I googled it and it said if I can reduce large_pool_size or sga_target I should be able to start. But I need to know what in the spfile in order to create the new init file. So my question is how to view the content of a SPFILE saved in ASM diskgroup. All I did is looking into alert log to found the parameter values. But I am not sure if there is a better and surer way to get into SPFILE. Thanks in advance for your help,

Shirley

ORA-27102: out of memory
OSD-00026: additional error information
O/S-Error: (OS 1455) The paging file is too small for this operation to complete

This post has been answered by OrionNet on Feb 18 2009

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 14 2009

Added on Feb 17 2009

#general-database-discussions

9 comments

10,820 views