[ORACLE] ORA-01078 LRM-00109 错误解决方案

ORA-01078  LRM-00109解决方法

 

SQL> startup

ORA-01078: failure in processing system parameters

LRM-00109: could not open parameter file '/oracle/app/oracle/product/12.1.0/dbhome_1/dbs/initDBNAME.ora'

 

oracle@HOSTNAME:~> cd /oracle/app/oracle/admin/dbname/pfile

oracle@HOSTNAME:/oracle/app/oracle/admin/dbname/pfile> ls -lrt

total 4

-rw-r----- 1 oracle oinstall 2066 Mar 27 09:52 init.ora.227201795728

oracle@HOSTNAME:/oracle/app/oracle/admin/dbname/pfile> cp init.ora.227201795728 /oracle/app/oracle/product/12.1.0/dbhome_1/dbs/

oracle@HOSTNAME:/oracle/app/oracle/admin/dbname/pfile> cd /oracle/app/oracle/product/12.1.0/dbhome_1/dbs/

oracle@HOSTNAME:/oracle/app/oracle/product/12.1.0/dbhome_1/dbs> mv init.ora.227201795728 initDBNAME.ora

 

oracle@HOSTNAME:/oracle/app/oracle/product/12.1.0/dbhome_1/dbs> sqlplus / as sysdba

 

SQL*Plus: Release 12.1.0.2.0 Production on Mon Mar 27 10:24:58 2017

 

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

 

Connected to an idle instance.

 

SQL> startup

ORACLE instance started.

 

Total System Global Area 1610612736 bytes

Fixed Size                  2924928 bytes

Variable Size             520097408 bytes

Database Buffers         1073741824 bytes

Redo Buffers               13848576 bytes