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

Several points to pay attention to when Oracle 11.2 instance accesses ASM:

1. Oracle users and grid users must have the same group, and the subordinate group of ASM Disk must be consistent with this group, otherwise the database cannot access the ASM disk

Error ora 15081

For example: both oracle and grid belong to the asmdba group, and the owner of the asm disk is also asmdba

[root@host rules.d] # id oracle

Uid=1001 (oracle) gid=1000 (oinstall) groups=1000 (oinstall), 1001 (dba), 1002 (oper), 1004 (asmdba)

[root@host rules.d] # id grid

Uid=1000 (grid) gid=1000 (oinstall) groups=1000 (oinstall), 1001 (dba), 1003 (asmadmin), 1004 (asmdba), 1005 (asmoper)

[root@host rules.d] # ll / dev/sdb*

Brw-rw-r-- 1 grid asmdba 8, 16 Dec 19 13:44 / dev/sdb

Brw-rw-r-- 1 grid asmdba 8, 17 Dec 19 17:58 / dev/sdb1

Brw-rw-r-- 1 grid asmdba 8, 18 Dec 19 17:58 / dev/sdb2

Brw-rw-r-- 1 grid asmdba 8, 19 Dec 19 17:58 / dev/sdb3

Brw-rw-r-- 1 grid asmdba 8, 20 Dec 19 17:58 / dev/sdb4

2. The correct owner of the $ORACLE_HOME/bin/oracle executable file should be oracle:asmadmin, and the permissions must be shared by s, as follows:

Oracle@host: [/ oracle/database/product/11.2.0/dbhome_1/bin] ll oracle

-rwsr-s--x 1 oracle asmadmin 232399473 Dec 19 14:51 oracle

If the oracle executable file permissions are incorrect, you can execute the following command:

${GI_HOME} / bin/setasmgidwrap-o ${ORACLE_HOME} / bin/oracle

Check the permissions of the oracle executable file after execution:

Ls-l ${ORACLE_HOME} / bin/oracle

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.