[解决思路]ORA-01078: failure in processing system parameters LRM-00109: could not open parameter file

时间:2023-11-22 21:34:32

  oracle数据库,服务器异常断电,导致数据库不能启动。。。。

错误提示:

SQL> startup ORA-01078: failure in processing system parameters

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

解决方案:

  服务器异常断电导致的文件丢失,恢复即可。 cp -a $ORACLE_BASE/admin/pfile/initxxx.ora   $ORACLE_HOME/dbs/init<sid>.ora

01、进入sid保留的init

echo $ORACLE_SID  //查看当前sid

cd $ORACLE_BASE/admin/<sid>/pfile

  init.ora.1131201617420   ---->  init<sid>.ora

02、复制init<sid>.ora到dbs/pfile中

/u01/app/oracle/product/11.2.0/db_1/dbs/pfile/

  initsznfpt.ora

03、启动数据库实例

sqlplus / as sysdba;

SQL> startup

ORACLE instance started.

Total System Global Area 6680915968 bytes

Fixed Size      2213936 bytes

Variable Size   3556771792 bytes

Database Buffers  3087007744 bytes

Redo Buffers     34922496 bytes

Database mounted. Database opened.