• oracle-12c-rac 报:ORA-01078


    OS:

    Oracle Linux Server release 5.7

    DB:

    Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production

    SQL> startup
    ORA-01078: failure in processing system parameters
    LRM-00109: could not open parameter file '/u01/oracle/app/oracle/product/11.2.0/dbhome_1/dbs/inityoon1.ora'

    1、到/u01/oracle/app/oracle/product/11.2.0/dbhome_1/dbs/

    [root@rac1 ~]#cd /u01/oracle/app/oracle/product/11.2.0/dbhome_1/dbs

    [root@rac1 dbs]# ls
    hc_yoon_1.dat hc_yoon_2.dat init.ora inityoon_1.ora

    2、inityoon_1.ora和inityoon1.ora文件不同

    3、查看SID:

    [root@rac1 dbs]# su - oracle
    [oracle@rac1 ~]$ more .bash_profile

    ORACLE_BASE=/u01
    ORACLE_HOME=/u01/oracle/app/oracle/product/11.2.0/dbhome_1
    ORACLE_SID=yoon1


    PATH=$ORACLE_HOME/OPatch:$ORACLE_HOME/bin:$PATH:$HOME/bin

    export PATH ORACLE_BASE ORACLE_HOME ORACLE_SID

    4、将ORACLE_SID=yoon1改成ORACLE_SID=yoon_1

    5、启动数据库OK:

    SQL> startup
    ORACLE instance started.

    Total System Global Area 1419685888 bytes
    Fixed Size 2288344 bytes
    Variable Size 536872232 bytes
    Database Buffers 872415232 bytes
    Redo Buffers 8110080 bytes
    Database mounted.
    Database opened.
    SQL>

    6、在oracle-11g-rac的SID设置yoon1没问题,在oracle-12c-rac中不行.

  • 相关阅读:
    linux read 系统调用剖析
    IO流程及优化
    分布式存储比较
    BTree,B-Tree,B+Tree,B*Tree的数据结构
    Spectrum Scale
    unixbench测试
    网络文件系统与 Linux
    协程的实现
    进程池和线程池
    django-spirt 论坛主题
  • 原文地址:https://www.cnblogs.com/hankyoon/p/5174462.html
Copyright © 2020-2023  润新知