Shulou(Shulou.com)06/01 Report--

When using dbca to create a database for Oracle 18C RAC in Oracle Linux 7.1, the ASM disk group was not found, while grid users using asmca could see the ASM disk group.

Solution method

1. Check the permission to create an ASM disk device. The correct permission is grid:asmadmin. The following output shows that the permission is correct.

[root@18c1] # ls-lrt / dev/asm*brw-rw---- 1 grid asmadmin 8, 16 Mar 16 22:28 / dev/asmdisk01brw-rw---- 1 grid asmadmin 8, 32 Mar 17 08:40 / dev/asmdisk02 [root@18c2 ~] # ls-lrt / dev/asm*brw-rw---- 1 grid asmadmin 8, 32 Mar 17 08:41 / dev/asmdisk02brw-rw---- 1 grid asmadmin 8, 16 Mar 17 08:41 / dev/asmdisk01

two。 Check whether the ASM instance is started

[grid@18c1] $asmcmd lsdgState Type Rebal Sector Logical_Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Voting_files NameMOUNTED EXTERN N 512512 4096 4194304 61440 35868 0 35868 0 Y CRS/MOUNTED EXTERN N 512512 4096 4194304 40960 36036 0 36036 0 N DATA/ [grid@18c2 ~] $asmcmd lsdgState Type Rebal Sector Logical_Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_file_MB Offline_disks Voting_files NameMOUNTED EXTERN N 512512 4096 4194304 61440 35868 0 35868 0 Y CRS/MOUNTED EXTERN N 512 512 4096 4194304 40960 36036 0 36036 0 N DATA/

3. Check whether oracle under GRID_HOME/bin has s permission. If you do not need to add s permission, the following output shows that oracle under GRID_HOME/bin directory does not have s permission. Here you need to add

[root@18c1] # ls-lrt / u01/app/oracle/18.0.0/db/bin/oracle-rwsr-s--x 1 oracle asmadmin 437038067 Mar 16 23:00 / u01/app/oracle/18.0.0/db/bin/oracle [root@18c1] # ls-lrt / u01/app/18.0.0/grid/bin/oracle-rwxr-x--x. 1 grid oinstall 413877125 Mar 16 19:10 / u01/app/18.0.0/grid/bin/oracle [root@18c2 /] # ls-lrt / u01/app/oracle/18.0.0/db/bin/oracle-rwsr-s--x 1 oracle oinstall 437038067 Mar 16 23:07 / u01/app/oracle/18.0.0/db/bin/oracle [root@18c2 /] # ls-lrt / u01/app/18.0.0/grid/bin/oracle-rwxr-x--x. 1 grid oinstall 413877125 Mar 16 19:30 / u01/app/18.0.0/grid/bin/oracle [root@18c1 ~] # chmod + s / u01/app/18.0.0/grid/bin/oracle [root@18c1 ~] # ls-lrt / u01/app/18.0.0/grid/bin/oracle-rwsr-s--x. 1 grid oinstall 413877125 Mar 16 19:10 / u01/app/18.0.0/grid/bin/oracle [root@18c2 /] # chmod + s / u01/app/18.0.0/grid/bin/oracle [root@18c2 /] # ls-lrt / u01/app/18.0.0/grid/bin/oracle-rwsr-s--x. 1 grid oinstall 413877125 Mar 16 19:30 / u01/app/18.0.0/grid/bin/oracle

4. Check all user groups

[root@18c1 ~] # id oracleuid=1001 (oracle) gid=1011 (oinstall) groups=1007 (asmdba), 1009 (dba), 1010 (oper), 1012 (backupdba), 1013 (dgdba), 1014 (kmdba), 1015 (racdba), 1011 (oinstall) [root@18c1 ~] # id griduid=1002 (grid) gid=1011 (oinstall) groups=1006 (asmadmin), 1007 (asmdba), 1008 (asmoper), 1009 (dba) 1011 (oinstall) [root@18c1 ~] # gpasswd-an oracle asmadminAdding user oracle to group asmadmin [root@18c1 ~] # id oracleuid=1001 (oracle) gid=1011 (oinstall) groups=1006 (asmadmin), 1007 (asmdba), 1009 (dba), 1010 (oper), 1012 (backupdba), 1013 (dgdba), 1014 (kmdba), 1015 (racdba), 1011 (oinstall) [root@18c2 /] # id oracleuid=1001 (oracle) gid=1011 (oinstall) groups=1007 (asmdba), 1009 (dba), 1010 (oper), 1012 (backupdba), 1013 (dgdba), 1014 (kmdba), 1011 (racdba) 1011 (oinstall) [root@18c2 /] # id griduid=1002 (grid) gid=1011 (oinstall) groups=1006 (asmadmin), 1007 (asmdba), 1008 (asmoper), 1009 (dba), 1011 (oinstall) [root@18c2 /] # gpasswd-an oracle asmadminAdding user oracle to group asmadmin [root@18c2 /] # id oracleuid=1001 (oracle) gid=1011 (oinstall) groups=1006 (asmadmin), 1007 (asmdba), 1009 (dba), 1010 (oper), 1012 (backupdba), 1013 (dgdba), 1014 (kmdba), 1015 (racdba), 1011 (oinstall)

The disk group can be found correctly when dbca is executed to create the database.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.