• 12.2 rac db补丁升级无法mount问题


    ALTER DATABASE   MOUNT
    2020-07-22T08:47:54.126335+08:00
    This instance was first to mount
    2020-07-22T08:47:55.845223+08:00
    NOTE: ASMB mounting group 2 (DATA)
    NOTE: ASM background process initiating disk discovery for grp 2 (reqid:0)
    WARNING: group 2 (DATA) has missing disks
    ORA-15040: diskgroup is incomplete
    WARNING: group 2 is being dismounted.
    WARNING: ASMB force dismounting group 2 (DATA) due to missing disks
    SUCCESS: diskgroup DATA was dismounted
    NOTE: ASMB mounting group 2 (DATA)
    NOTE: ASM background process initiating disk discovery for grp 2 (reqid:0)
    WARNING: group 2 (DATA) has missing disks
    ORA-15040: diskgroup is incomplete
    WARNING: group 2 is being dismounted.
    WARNING: ASMB force dismounting group 2 (DATA) due to missing disks
    SUCCESS: diskgroup DATA was dismounted
    2020-07-22T08:47:55.903640+08:00
    ORA-00210: cannot open the specified control file
    ORA-00202: control file: '+DATA/TZLV2DB0/CONTROLFILE/control02.ctl'
    ORA-17503: ksfdopn:2 Failed to open file +DATA/TZLV2DB0/CONTROLFILE/control02.ctl
    ORA-15001: diskgroup "DATA" does not exist or is not mounted
    ORA-15040: diskgroup is incomplete
    ORA-00210: cannot open the specified control file
    ORA-00202: control file: '+DATA/TZLV2DB0/CONTROLFILE/control01.ctl'
    ORA-17503: ksfdopn:2 Failed to open file +DATA/TZLV2DB0/CONTROLFILE/control01.ctl
    ORA-15001: diskgroup "DATA" does not exist or is not mounted
    ORA-15040: diskgroup is incomplete
    2020-07-22T08:47:55.950258+08:00
    ORA-205 signalled during: ALTER DATABASE   MOUNT...
    

      

    问题原因:/u01/app/oracle/product/12.2.0/db/bin/oracle文件属性发生变化

    [oracle@tz-yycs-db02 bin]$ ll oracle
    -rwsr-s--x 1 oracle oinstall 409357928 Jul 22 09:24 oracle
    

      

    解决办法:

    #chmod 6751 /u01/app/oracle/product/12.2.2.0/db/bin/oracle
    #chown oracle:asmadmin /u01/app/oracle/product/12.2.0/db/bin/oracle
    

      

  • 相关阅读:
    启动mysql时显示:/tmp/mysql.sock 不存在的解决方法
    python在使用MySQLdb模块时报Can't extract file(s) to egg cacheThe following error occurred while trying to extract file(s) to the Python eggcache的错误。
    文档发布测试
    我的日常
    CSS-基础优化策略
    Git-基本操作
    Git-配置SSH公钥
    Git-免密提交
    Wx-mpvue开发小程序
    Vue-移动端开发全家桶
  • 原文地址:https://www.cnblogs.com/hanglinux/p/13358706.html
Copyright © 2020-2023  润新知