SQL> startup
ORA-01078: Failure in Processing System Parameters
LRM-00109: cocould not open parameter file '/opt/Oracle10g/product/10.2/db_1/dbs/initora10g. ora'
The file does not exist. It is estimated that the shutdown is caused by illegal shutdown.
This is because in Oracle9i and Oracle10g, Oracle uses spfile by default to start the database. If spfile does not exist, the above error will occur.
Solution 1 (verified ):
Copy the file in the form of init. ora.012009233838 in the $ oracle_base/admin/database name/pfile directory to the initoracle. ora directory in the $ ORACLE_HOME/DBS directory. (Note: Oracle in initoracle. ora is your instance name, that is, my name is initora10g. ora)
[Root @ localhost DBS] # cp init. ora.721200911530 $ ORACLE_HOME/dbs/initora10g. ora
Switch to the Oracle account, connect to sqlplus, and run startup. the following error may occur:
This is because you have no permissions,
[Root @ localhost DBS] # chmod-r 775 initora10g. ora
Continue startup
Success.