Tag Archives: Linux Start database Error

[Solved] Linux Start database Error: could not open parameter file init**.ora

Sqlplus/nolog, Conn/as SYSDBA, startup command

SQL> startup
ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file ‘/home/oracle/app/product/11.2.0/dbhome_ 1/dbs/initLCDC.ora’

Look up the file, it doesn’t exist. It is estimated that it is caused by illegal shutdown

This is because in Oracle 9i and Oracle 10g, Oracle will use SPFILE to start the database by default. If SPFILE does not exist, the above error will appear

Solution 1:
add $Oracle_Copy the init.ora.012009233838 file in the base/admin/database name/pfile directory to $oracle_Initlcdc.ora in the home/DBS directory( Note: Oracle in initoracle.ora is your instance name oracle_ Sid, the file name is the file name of the error prompt)

The corresponding path is:

Path 1: Home/Oracle/APP/admin/LCDC/pfile/init.ora.4132019135738

Path 2: Home/Oracle/APP/product/11.2.0/dbhome_ 1/dbs