1

问题

ORA-01078: failure in processing system parameters

LRM-00109: could not open parameter file '/u01/app/oracle/product/11.2.0/db_1/dbs/initORCL.ora'

SQL> create spfile ='+data' from pfile='/u01/app/oracle/product/11.2.0/db_1/initenmoedu.ora';

create spfile ='+data' from pfile='/u01/app/oracle/product/11.2.0/db_1/initenmoedu.ora'                                

*

ERROR at line 1:

ORA-01078: failure in processing system parameters

LRM-00109: could not open parameter file

'/u01/app/oracle/product/11.2.0/db_1/initenmoedu.ora'

2

解决方法

[oracle@enmoedu ~]$ cd /u01/app/oracle/admin/enmoedu/pfile/

[oracle@enmoedu pfile]$ ls

init.ora.125201623126

[oracle@enmoedu pfile]$ cp init.ora.125201623126 /u01/app/oracle/product/11.2.0.db_1/dbs/

[oracle@enmoedu pfile]$ ls

init.ora.125201623126

[oracle@enmoedu pfile]$ mv init.ora.125201623126 initenmoedu.ora

[oracle@enmoedu enmoedu]$ cd /u01/app/oracle/admin/enmoedu/pfile/

[oracle@enmoedu pfile]$ ls

initenmoedu.ora

----------------------------------------------------------------------------

SQL> show parameter pfile;

NAME                                     TYPE         VALUE

------------------------------------ ----------- ------------------------------

spfile                                     string         /u01/app/oracle/product/11.2.0

 .db_1/dbs/spfileenmoedu.ora

[oracle@enmoedu pfile]$ cd /u01/app/oracle/product/11.2.0.db_1/

[oracle@enmoedu 11.2.0.db_1]$ cd dbs/

[oracle@enmoedu dbs]$ ls

hc_enmo.dat     initenmoedu.ora        lkENMOEDU

hc_enmoedu.dat  init.ora               orapwenmoedu

hc_jj.dat       init.ora.125201623126  spfileenmoedu.ora

[oracle@enmoedu dbs]$ mv spfileenmoedu.ora spfileenmoedu.ora.bak

3

测试：

SQL> startup force 

ORACLE instance started.

Total System Global Area  830930944 bytes

Fixed Size                    2257800 bytes

Variable Size                  536874104 bytes

Database Buffers          285212672 bytes

Redo Buffers                    6586368 bytes

Database mounted.

Database opened.

SQL> show parameter pfile;

NAME                                     TYPE         VALUE

------------------------------------ ----------- ------------------------------

spfile                                     string

SQL> create spfile='+data' from pfile='/u01/app/oracle/product/11.2.0.db_1/dbs/initenmoedu.ora';

File created.