ORA-01078: failure in processing system parameters
[oracle@oracle111 bin]$ sqlplus "/ as sysdba"
SQL*Plus: Release 10.2.0.1.0 - Production on Tue Jul 3 09:36:07 2012
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to an idle instance.
SQL> select instance_name from v$instance;
select instance_name from v$instance
*
ERROR at line 1:
ORA-01034: ORACLE not available
SQL> startup
ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file '/oracle/app/product/10.2.0/db_1/dbs/initCMS.ora'
SQL> exit
Disconnected
[oracle@oracle111 dbs]$ cp /oracle/app/admin/cms/pfile/init.ora.229201284028 /oracle/app/product/10.2.0/db_1/dbs/initCMS.ora
[oracle@oracle111 dbs]$ sqlplus "/ as sysdba"
SQL*Plus: Release 10.2.0.1.0 - Production on Tue Jul 3 09:42:45 2012
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to an idle instance.
SQL> select instance_name from v$instance;
select instance_name from v$instance
*
ERROR at line 1:
ORA-01034: ORACLE not available
SQL> startup;
ORACLE instance started.
Total System Global Area 599785472 bytes
Fixed Size 2022600 bytes
Variable Size 163578680 bytes
Database Buffers 427819008 bytes
Redo Buffers 6365184 bytes
Database mounted.
Database opened.
自强不息,方能厚得载物。
尊重知识,转载需注明出处。