ORACLE报错（3）ORA-01078: failure in processing system parameters

原创

wwtcn 2010-11-29 15:03:50 博主文章分类：ORACLE ©著作权

文章标签 oracle 职场休闲 oracle 报错 文章分类 Oracle 数据库

©著作权归作者所有：来自51CTO博客作者wwtcn的原创作品，请联系作者获取转载授权，否则将追究法律责任

ORACLE报错（3）ORA-01078: failure in processing system parameters

ORA-01078: failure in processing system parameters

错误信息：

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/$ORACLE_SID/pfile/init.ora /opt/oracle/products/10.1.0.3/db_1/dbs/initrawdb.ora

> sqlplus /nolog

SQL*Plus: Release 10.1.0.3.0 - Production on Thu Jun 8 13:16:00 2006

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

SQL> conn / as sysdba
Connected to an idle instance.
SQL> startup
ORACLE instance started.

Total System Global Area  167772160 bytes
Fixed Size                   778212 bytes
Variable Size              57679900 bytes
Database Buffers          109051904 bytes
Redo Buffers                 262144 bytes
Database mounted.
Database opened.
SQL> 
问题解决！