LRM-00109: could not open parameter file '/u01/app/oracle/product/12.1.0/db_1/dbs/initepps.ora'

时间:2021-02-05 06:57:37

安装好oracle后,起动时报如下错误:

[oracle@Oracle-A ~]$ export ORACLE_SID=ORCL
[oracle@Oracle-A ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Tue Jun 12 21:39:26 2018

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

Connected to an idle instance.

SQL> startup
ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/initORCL.ora'

复制如下位置的文件,如:

[oracle@Oracle-A dbhome_1]$ cp /u01/app/base/admin/orcl/pfile/init.ora.582018154558 /u01/app/oracle/product/11.2.0/dbhome_1/dbs/initORCL.ora

故障排除:

SQL> startup
ORACLE instance started.

Total System Global Area  835104768 bytes
Fixed Size                  2257840 bytes
Variable Size             536874064 bytes
Database Buffers          289406976 bytes
Redo Buffers                6565888 bytes
Database mounted.
Database opened.