[解决思路]ORA-01078: failure in processing system parameters LRM-00109: could not open parameter file
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.

浙公网安备 33010602011771号