标题: ORA-01078: failure in processing system parameters 问题的解决方法 [打印本页] 作者: jiawang 时间: 2018-10-11 12:43 标题: ORA-01078: failure in processing system parameters 问题的解决方法 报错现象:
[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@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.