11G ORACLE RAC DBCA does not recognize ASM disk groups

ASM disks do not recognize several phenomena:

1) GI home directory or its subdirectory permissions error

2) Incorrect permissions for ASM disks

3) ASM instance is not started or ASM Disk Group is not on Mount

4) ASM Disk Group resources are not online

5) Incorrect permissions for Oracle users

6) Permissions error for Oracle ($ORACLE _home/bin) executable file

OK, then I will follow the above analysis of the results of one-by-one troubleshooting:

1) GI home directory or its subdirectory permissions error

[Email protected] ~]# Ls-ld
/u01/app/11.2.0/grid/
Drwxr-x---oinstall 4096 Apr 19 01:36
/u02/app/11.2.0/grid/

I have a simple look at the GI home directory permissions, which is normal. Here want to remind everyone, some DBAs see such directory permissions intentionally or unconsciously, found that the owner is root, think that there is a problem, rightfully through the command to change, if only to change the permissions of the directory is not a problem, the fallback method is very simple, but once added-R parameter recursive way to the directory, The permissions of the child file are changed, and the fault occurs. Therefore, everyone in the operation of the time do not blindly to do not grasp the matter, master each operation behind the principle and its consequences, so that the full preparation of the fallback method.

There was a time when the-R changed the entire directory permission, resulting in an unrecognized ASM disk group.

Changing the directory permissions according to the normal RAC is still not recognized, the main problem is as follows:
[[email protected] ~]# Find/-name Oracle

See the following 2 paths for Oracle file permissions
/u01/app/oracle/11.2.0/db_1/bin/oracle
/u01/app/grid/11.2.0/bin/oracle
[Email protected] bin]# ls-ltr Oracle
-rwsr-s--x 1 Oracle asmadmin 232399431 Feb 08:10 oracle/u01/app/grid/11.2.0/bin/oracle
[Email protected] bin]# ls-ltr Oracle
-rwsr-s--x 1 grid oinstall 203974257 Feb 07:28 Oracle
[Email protected] bin]# ls-ltr Oracle
-rwsr-s--x 1 grid oinstall 203974257 Feb 07:28 Oracle

Note The permissions for these two Oracle files, as shown above

2)
ASM Disk Permissions Error

[Email protected] ~]# ls-l/dev/oracleasm/disks/
Total
0
BRW-RW----1 grid asmadmin 8, APR 01:22 ASMDISK1
BRW-RW----1 grid
Asmadmin 8, APR 01:22 ASMDISK2

If you find that the permissions are incorrect, modify the following command:
[Email protected] ~]#
Oracleasm Configure-i
Or
[Email protected] ~]#/etc/init.d/oracleasm
Configure
View after modification:
[Email protected] ~]# oracleasm
Configure
Oracleasm_enabled=true
Oracleasm_uid=grid
Oracleasm_gid=asmadmin
Oracleasm_scanboot=true
Oracleasm_scanorder= ""
Oracleasm_scanexclude= ""

3)
ASM instance not started or ASM Disk Group is not on Mount

4) ASM Disk Group resources are not online:
[Email protected] ~]$ CRSCTL Stat Res
–t
---------------------------------------------------------------------
NAME
TARGET State SERVER
State_details
--------------------------------------------------------------------------------
Local
Resources
---------------------------------------------------------------------
Ora. Data.dg
ONLINE
ONLINE Rac1
Ora. Flash.dg
Online online Rac1
Ora. Grid.dg
ONLINE
ONLINE Rac1
Ora. Listener.lsnr
Online online Rac1
Ora.asm
ONLINE
ONLINE Rac1 Started
Ora.ons
OFFLINE OFFLINE
Rac1
---------------------------------------------------------------------
Cluster
Resources
---------------------------------------------------------------------
Ora.cssd
1
Online online Rac1
Ora.diskmon
1 OFFLINE OFFLINE
Ora.evmd
1 ONLINE
ONLINE Rac1

5) Incorrect permissions for Oracle users
[[email protected] ~]# ID Oracle

UID=1101 (Oracle)
gid=1000 (Oinstall)
groups=1000 (Oinstall), 1300 (DBA), 1301 (Oper), 1201 (ASMDBA)

Oracle users need to join the ASMDBA group, if found not joined, do the following:

[Email protected] ~]# gpasswd-a Oracle ASMDBA
Adding user Oracle to group ASMDBA

6)
Permissions error for Oracle ($ORACLE _home/bin) executable file
[Email protected] ~]# su-oracle

[Email protected] ~]$ CD $ORACLE _home/bin

[Email protected] bin]$ ls-l Oracle
-rwsr-s--x 1 Oracle oinstall 232399473 APR 07:04 Oracle

The permissions for the Oracle executable file are incorrect:
[[Email protected] ~]# CD
/u01/app/oracle/product/11.2.0/dbhome_1/bin/

[Email protected] bin]# chown oracle.asmadmin Oracle

[Email protected] bin]# ls-l Oracle
-rwxr-x--x 1 Oracle asmadmin 232399473 APR 07:04 Oracle

[Email protected] bin]# chmod +s Oracle

[Email protected] bin]# ls-l Oracle
-rwsr-s--x 1 Oracle asmadmin 232399473 APR 07:04 Oracle

11G ORACLE RAC DBCA does not recognize ASM disk groups