Oracle 11g r2 installation on OEL 5.5 - non rac non asm
Oracle 11g r2 installation on OEL 5.5 - one instanc only
Posted: Jul 24, 2012 10:29 PM
startup , ora01078 , lrm00109 , oracle , 11g , r2 , installation , in , oel , 55 [Edit]
Click to edit this message... Edit Click to report abuse... Click to reply to this thread Reply
ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file '/u01/app/oracle/product/11.2.0/db_1/dbs/initora11g.ora'
Unfortunately I can not find initora11g.ora
[oracle@localhost db_1] cd dbs
[oracle@localhost dbs] ls
hc_orcl.dat init.ora lkORCL orapworcl spfileorcl.ora
so create pfile from spfile='/home//oracle/product/11.2.0/db_1/dbs/spfileora11.ora will not work
in oratab also - it showed sid as orcl but I changed into
I have set oracle_sid = ora11g in .bash_profile as well
Do you have /u01/app/oracle/product/11.2.0/db_1/dbs/initora11g.ora file?. Your instance is not up so you can't run create pfile from spfile. You have to create pfile first then create spfile not other way around.