暂无图片
暂无图片
暂无图片
暂无图片
暂无图片

ORA-15040: diskgroup is incomplete

原创 吾喾 2022-09-02
2044

节点2 statup启动时alert日志报错:

2022-09-02T09:44:42.027953+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
2022-09-02T09:44:42.062161+08:00
ORA-01565: Unable to open Spfile +DATA/DG/PARAMETERFILE/spfiledg.ora.
USER (ospid: 18200): terminating the instance due to error 1565
2022-09-02T09:44:42.062933+08:00
ALTER SYSTEM SET remote_listener=' dg-scan:1521' SCOPE=MEMORY SID='dg2';


查看DATA磁盘组挂载状态没有问题

select group_number, name, state, type, total_mb, free_mb, usable_file_mb from v$asm_diskgroup;

crsctl stat res -t

查看$ORACLE_HOME/bin/oracle文件属组,发现不对
[dg02:oracle]:/u01/app/oracle/product/12.2.1/db_1/bin>ll oracle
-rwsr-s--x 1 oracle oinstall 409930344 Aug 13 18:29 oracle
[dg02:oracle]:/u01/app/oracle/product/12.2.1/db_1/bin>pwd

修改完文件属组重新启动问题解决:
[root@dg02 ~]# chown oracle:asmadmin /u01/app/oracle/product/12.2.1/db_1/bin/oracle
[root@dg02 ~]#
[root@dg02 ~]# chmod 6751 /u01/app/oracle/product/12.2.1/db_1/bin/oracle
[root@dg02 ~]#
[root@dg02 ~]# ll /u01/app/oracle/product/12.2.1/db_1/bin/oracle
-rwsr-s--x 1 oracle asmadmin 409930344 Aug 13 18:29 /u01/app/oracle/product/12.2.1/db_1/bin/oracle


「喜欢这篇文章,您的关注和赞赏是给作者最好的鼓励」
关注作者
【版权声明】本文为墨天轮用户原创内容,转载时必须标注文章的来源(墨天轮),文章链接,文章作者等基本信息,否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容,欢迎发送邮件至:contact@modb.pro进行举报,并提供相关证据,一经查实,墨天轮将立刻删除相关内容。

评论