ORA-01078: failure in processing system parameters

2011年12月2日 发表评论 阅读评论

数据库在安装完成后,在启动时,报错误:ORA-01078: failure in processing system parameters 

[oracle@localhost ~]$ sqlplus /nolog

SQL*Plus: Release 10.2.0.4.0 - Production on Fri Dec 2 15:56:00 2011

Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.

SQL> conn /as sysdba;
Connected to an idle instance.
SQL> startup
ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file '/opt/oracle/product/10g/dbs/initnis.ora'

从上面报的错误不难看出是缺少了文件initnis.ora,于是执行cp /opt/oracle/admin/gaxt/pfile/init.ora.1122011151513 /opt/oracle/product/10g/dbs/initnis.ora

重新启动,

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

Total System Global Area 1258291200 bytes
Fixed Size                  1267236 bytes
Variable Size             318769628 bytes
Database Buffers          922746880 bytes
Redo Buffers               15507456 bytes
ORA-01102: cannot mount database in EXCLUSIVE mode

发现可以启动,上面的问题解决,但又报了一个错。解决方面请查我的另一篇日志:

 




本站的发展离不开您的资助,金额随意,欢迎来赏!

You can donate through PayPal.
My paypal id: itybku@139.com
Paypal page: https://www.paypal.me/361way

分类: 数据库 标签:
  1. 本文目前尚无任何评论.