自强不息,方能厚德载物。

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.

posted @ 2013-04-27 15:37  omniscienceer  阅读(362)  评论(0编辑  收藏  举报