[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了