Oracle startup, prompting "lrm-00109:could not open parameter file"

Oracle startup, prompting "lrm-00109:could not open parameter file"

Lrm-00109:could not open parameter file '/home/oracle/oracle10g/dbs/initoms

Today when connecting to the Oracle database, the discovery data is not started, using the startup command, the error message is as follows:

Sql> Startup
Ora-01078:failure in processing system parameters
Lrm-00109:could not open parameter file '/oracle/10g/dbs/init10g.ora '

Follow the prompts to find the relevant directory of files, sure enough does not exist.

Checked the information on the Internet. Get if useful information: because in oracle10g, Oracle uses SPFile to start the database by default, and if SPFile does not exist, the above error occurs.

Workaround:

Will $oracle_base/admin/your database name/pfile/init.ora.628201264542 (This string is not necessarily the same)
Copy to the $oracle_home/dbs directory and rename it to your DB instance name.
For example: The above hint can not find Init10g.ora this file, change to Init10g.ora

Reference command:

Export $ORACLE _home--Output environment variables in use HOME

Cat/home/oracle/.bash_profile--or. bashrc file, make sure that the value of $oracle_home is consistent with the current use
(I have encountered inconsistencies.)

MV $ORACLE _base/admin/orcl/pfile/init.ora.628201264542/oracle/10g/dbs/init10g.ora
--Copy files to the specified directory

Sqlplus "/as sysdba"

Startup

Get!

Oracle startup, prompting "lrm-00109:could not open parameter file"