节点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




