Thursday, 24 July 2014

startup failed: ORA-01078: failure in processing system parameters, LRM-00109: could not open parameter file


OS: OEL 5.7
DB: 11.2.0.3.0
64 Bit

RMAN> startup nomount ;

startup failed: ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file '/u02/oracle/ERP/db/tech_st/11.2.0/dbs/initERP.ora'

starting Oracle instance without parameter file for retrieval of spfile
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of startup command at 07/24/2014 11:08:06
RMAN-04014: startup failed: ORA-04031: unable to allocate 1048608 bytes of shared memory ("shared pool","unknown object","sga heap(1,0)","row cache")




During rman restore and recovery testing i was trying to restore spfile from backup. But issuing startup nomount with RMAN threw "ora-10078".

I remember reading somewhere, rman will start database without  spfile, using a dummy parameter file. Seeing the error i decided to crosscheck with rman documentaion and found it should start using dummy parameter file if one is not available

http://docs.oracle.com/cd/E11882_01/backup.112/e10642/rcmadvre.htm#BRADV363
When the server parameter file is not available, RMAN starts the instance with a dummy parameter file. For example, enter the following command:




I could see that its trying to open init file and as its not availabe its gives the error.

Just create a temporary parameter file with only db_name=[db_name] entry





Now connected to rman and issued startup nomount
That was enough for rman to start database in nomount mode.


No comments:

Post a Comment