Thursday, 24 July 2014

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

OS: OEL 5.7
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
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.