ORA-01078: failure in processing system parameters

当你在处理了以下这两个问题后,

ORA-16032: parameter LOG_ARCHIVE_DEST destination string cannot be translated

    ORA-07286: sksagdi: cannot obtain device information.

    Linux Error: 2: No such file or directory

重启数据库,发现

SQL> startup
ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file '/opt/oracle/products/10.1.0.3/db_1/dbs/initrawdb.ora'

解决办法:
$ cp $ORACLE_BASE/admin/xzomc/pfile/init.ora.728200794421 /oracleapp/u01/app/oracle/product/10.2.0/dbs/initrawdb.ora

SQL> conn sys/oracle@xzomc as sysdba;
Connected to an idle instance.
SQL> startup pfile=$ORACLE_BASE/admin/xzomc/pfile/init.ora.728200794421
ORACLE instance started.

Total System Global Area 2550136832 bytes
Fixed Size                  1980808 bytes
Variable Size             536872568 bytes
Database Buffers         1996488704 bytes
Redo Buffers               14794752 bytes
Database mounted.
Database opened.

posted @ 2013-04-22 17:14  皮皮机器猫  阅读(303)  评论(0编辑  收藏  举报