ORA-01078 and LRM-00109 issues lead to Oracle boot failure workaround

Operating Environment

SuSE11 + ORACLE11GR2 (11.2.0.3)

problem Phenomenon

New Installation of Oracle boot failure, prompting for ORA-01078 and LRM-00109 errors. Specific error phenomena are as follows

Problem analysis

Based on error analysis, the failure to find the parameter file Initora11g.ora cause the startup to fail. Copy a Initora11g.ora file from another path to the specified directory

Problem Solving

1, Cd/home/oracle/base/admin/ora11g/pfile

2. CP init.ora.6242012174552 /home/oracle/base/dbs/initora11g.ora

3. Reboot the startup DB instance successfully.

Extended

This question is a little bit strange, check out the next /home/oracle/base/ The Spfileora11g.ora file is present in the DBS directory, usually only after the order is read from the Spfileora11g.ora file Initora11g.ora file (the reading sequence of the parameter file: Spfileora11g.ora- > Spfile.ora, Initora11g.ora, this assumes that the instance name is ora11g). If none of the three are read, the DB instance fails to start.

ORA-01078 and LRM-00109 issues lead to Oracle boot failure workaround