11G Oracle報ORA-01078和LRM-00109錯解決方法

資料庫安裝完成後啟動資料庫時報錯如下：

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

[root@oracle dbs]# cd /u01/app/oracle/product/11.2/db_1/dbs/
[root@oracle dbs]# ll
total 20
-rw-rw---- 1 oracle oinstall 1544 Mar 12 17:24 hc_orcl11g.dat
-rw-r--r-- 1 oracle oinstall 2851 May 15  2009 init.ora
-rw-r----- 1 oracle oinstall   24 Mar 12 17:23 lkORCL11G
-rw-r----- 1 oracle oinstall 1536 Mar 12 17:23 orapworcl11g
-rw-r----- 1 oracle oinstall 2560 Mar 12 17:25 spfileorcl11g.ora

沒有initorcl.ora檔案
於是將pfile引數檔案複製過來並重新命名為initorcl.ora

[oracle@oracle ~]$ cp /u01/app/oracle/admin/orcl11g/pfile/init.ora.2122015172334 /u01/app/oracle/product/11.2/db_1/dbs/initorcl.ora
[oracle@oracle ~]$ sqlplus / as sysdba


SQL*Plus: Release 11.2.0.4.0 Production on Thu Mar 12 21:37:24 2015


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


Connected to an idle instance.


SQL> startup 
ORACLE instance started.


Total System Global Area 1603411968 bytes
Fixed Size                  2253664 bytes
Variable Size             989858976 bytes
Database Buffers          603979776 bytes
Redo Buffers                7319552 bytes
Database mounted.
Database opened.