ORA-01078: failure in processing system parameters 问题的解决方法

jiawang

报错现象：
[oracle@strong_st ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Thu Oct 11 11:28:36 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/db_1/dbs/initorcl1.ora'

报错原因是打不开initorcl1.ora，进入$oracle_home/dbs目录下,发现并没有initorcl1.ora文件
[oracle@strong_st ~]$ cd /u01/app/oracle/product/11.2.0/db_1/dbs/
[oracle@strong_st dbs]$ ll
total 20
-rw-rw---- 1 oracle oinstall 1544 Oct 11 11:20 hc_orcl2.dat
-rw-r--r-- 1 oracle oinstall 2851 May 15  2009 init.ora
-rw-r----- 1 oracle oinstall   24 Oct 11 11:18 lkORCL2
-rw-r----- 1 oracle oinstall 1536 Oct 11 11:19 orapworcl2
-rw-r----- 1 oracle oinstall 2560 Oct 11 11:20 spfileorcl2.ora

解决办法：进入到$ORACLE_BASE/
[oracle@strong_st pfile]$ find /u01  -name pfile
/u01/app/oracle/admin/orcl2/pfile
[oracle@strong_st pfile]$ cd /u01/app/oracle/admin/orcl2/pfile
[oracle@strong_st pfile]$ ll
总用量 4
-rw-r----- 1 oracle oinstall 2049 10月 11 11:17 init.ora.9112018111939

[oracle@strong_st pfile]$ cp init.ora.9112018111939 /u01/app/oracle/product/11.2.0/db_1/dbs/initorcl1.ora
[oracle@strong_st pfile]$ cd /u01/app/oracle/product/11.2.0/db_1/dbs
[oracle@strong_st dbs]$ ll
总用量 28
-rw-rw---- 1 oracle oinstall 1544 10月 11 11:37 hc_orcl1.dat
-rw-rw---- 1 oracle oinstall 1544 10月 11 11:20 hc_orcl2.dat
-rw-r--r-- 1 oracle oinstall 2851 5月  15 2009 init.ora
-rw-r----- 1 oracle oinstall 2049 10月 11 11:36 initorcl1.ora
-rw-r----- 1 oracle oinstall   24 10月 11 11:37 lkORCL2
-rw-r----- 1 oracle oinstall 1536 10月 11 11:19 orapworcl2
-rw-r----- 1 oracle oinstall 2560 10月 11 11:20 spfileorcl2.ora

[oracle@strong_st dbs]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Thu Oct 11 11:37:02 2018
Copyright (c) 1982, 2013, Oracle.  All rights reserved.
Connected to an idle instance.

SQL> startup;
ORACLE instance started.
Total System Global Area 2505338880 bytes
Fixed Size                  2255832 bytes
Variable Size             620758056 bytes
Database Buffers         1879048192 bytes
Redo Buffers                3276800 bytes
Database mounted.
Database opened.