• ORA01078: 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.

  • 相关阅读:
    initctl 创建自己的JOB
    TortoiseXX 与TotalCommander (TC)的图标问题
    eclipse 与 tomcat 的那些路径
    把函数视为对象
    序列增量赋值的一个谜题: +=
    __new__ 和 __init__ 的区别
    Python 中 is 与 == 区别
    Flask 2.0.1 changes
    flask run 与 DispatcherMiddleware 不兼容处理
    waitress 部署 flask服务
  • 原文地址:https://www.cnblogs.com/uniqueness/p/3047253.html
Copyright © 2020-2023  润新知