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 databa