Shulou(Shulou.com)05/31 Report--

Editor to share with you what to do when there are ORA-01078 and LRM-00109 errors in oracle. I believe most people don't know much about it, so share this article for your reference. I hope you can learn a lot after reading this article. Let's learn about it together.

1: error message:

SQL > startup

ORA-01078: failure in processing system parameters

LRM-00109: could not open parameter file'/ u01amp appActionoracleUniverse produce 11.1.0 Universe dbaccoun1OndbsActionInitorc11g.ora'

2: solution:

Oracle_base = / u01/app/oracle

Execute the following command:

Cd / u01/app/oracle/admin/oracl11g/pfile/

Cp init.ora.71420095101 / u01/app/oracle/product/11.1.0/db_1/dbs/initorc11g.ora

3: restart the service:

[oracle@ORCL11G ~] $sqlplus / nolog

SQL*Plus: Release 11.1.0.6.0-Production on Sat Aug 15 22:13:12 2009

Copyright (c) 1982, 2007, Oracle. All rights reserved.

SQL > conn / as sysdba

Connected to an idle instance.

SQL > startup

ORACLE instance started.

Total System Global Area 238530560 bytes

Fixed Size 1299116 bytes

Variable Size 79695188 bytes

Database Buffers 155189248 bytes

Redo Buffers 2347008 bytes

Database mounted.

Database opened.

SQL >

The above is all the contents of the article "what to do if there are ORA-01078 and LRM-00109 errors in oracle". Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.