oracle11g报错 ORA-01078和LRM-00109 解决方法

数据库安装完成后启动数据库startup时报错如下：

[oracle@Danny ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Sat Jul 16 01:38:13 2016

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

Connected to an idle instance.

SQL> conn as sysdba
Enter user-name: orcl
Enter password: 
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/dbs/initorcl.ora'

查看此路径下果然没有这个文件

[root@Danny ~]# cd /u01/app/oracle/product/11.2.0/db/dbs/
[root@Danny dbs]# ll
total 20
-rw-rw---- 1 oracle oinstall 1544 Jul 16 01:28 hc_dbca.dat
-rw-r--r-- 1 oracle oinstall 2851 May 15  2009 init.ora
-rw-r----- 1 oracle oinstall   24 Jul 16 01:18 lkDBCA
-rw-r----- 1 oracle oinstall 1536 Jul 16 01:18 orapwdbca
-rw-r----- 1 oracle oinstall 2560 Jul 16 01:28 spfiledbca.ora

网上找到方法，可以将pfile参数文件拷贝过来并重新命名为initorcl.ora

查看pfile下果然有这个文件，cp过来

[oracle@Danny pfile]$ cd /u01/app/oracle/admin/dbca/pfile/
[oracle@Danny pfile]$ ll
total 4
-rw-r----- 1 oracle oinstall 1760 Jul 16 01:18 init.ora.616201612838
[oracle@Danny pfile]$ cp init.ora.616201612838 /u01/app/oracle/product/11.2.0/db/dbs
[oracle@Danny pfile]$ cd /u01/app/oracle/product/11.2.0/db/dbs
[oracle@Danny dbs]$ ll
total 24
-rw-rw---- 1 oracle oinstall 1544 Jul 16 01:28 hc_dbca.dat
-rw-r--r-- 1 oracle oinstall 2851 May 15  2009 init.ora
-rw-r----- 1 oracle oinstall 1760 Jul 16 02:04 init.ora.616201612838
-rw-r----- 1 oracle oinstall   24 Jul 16 01:18 lkDBCA
-rw-r----- 1 oracle oinstall 1536 Jul 16 01:18 orapwdbca
-rw-r----- 1 oracle oinstall 2560 Jul 16 01:28 spfiledbca.ora

就OK了