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

Reprinted from Http://blog.sina.com.cn/s/blog_53e731b70101liku.html

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/1 0g/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:

Copy the $oracle_base/admin/your database name/pfile/init.ora.628201264542 (not necessarily the same number) 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 usage (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

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