ORA-01078: failure in processing system parameters
数据库在安装完成后,在启动时,报错误:ORA-01078: failure in processing system parameters
1[oracle@localhost ~]$ sqlplus /nolog
2SQL*Plus: Release 10.2.0.4.0 - Production on Fri Dec 2 15:56:00 2011
3Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
4SQL> conn /as sysdba;
5Connected to an idle instance.
6SQL> startup
7ORA-01078: failure in processing system parameters
8LRM-00109: could not open parameter file '/opt/oracle/product/10g/dbs/initnis.ora'
9从上面报的错误不难看出是缺少了文件initnis.ora,于是执行cp /opt/oracle/admin/gaxt/pfile/init.ora.1122011151513 /opt/oracle/product/10g/dbs/initnis.ora
10重新启动,
11SQL> conn /as sysdba;
12Connected to an idle instance.
13SQL> startup
14ORACLE instance started.
15Total System Global Area 1258291200 bytes
16Fixed Size 1267236 bytes
17Variable Size 318769628 bytes
18Database Buffers 922746880 bytes
19Redo Buffers 15507456 bytes
20ORA-01102: cannot mount database in EXCLUSIVE mode
发现可以启动,上面的问题解决,但又报了一个错。解决方面请查我的另一篇日志:
捐赠本站(Donate)
如您感觉文章有用,可扫码捐赠本站!(If the article useful, you can scan the QR code to donate))
- Author: shisekong
- Link: https://blog.361way.com/ora-01078/591.html
- License: This work is under a 知识共享署名-非商业性使用-禁止演绎 4.0 国际许可协议. Kindly fulfill the requirements of the aforementioned License when adapting or creating a derivative of this work.