DBCA建库找不到ASM磁盘一例

﹏ヽ暗。殇╰゛Y 2022-06-04 07:19 454阅读 0赞

*  环境信息   
    red hat linux64   
    gi 11.2.0.4   
    oracle 11.2.0.4
 *  问题现象   
    安装完gi软件及oralce database软件之后，通过dbca用户界面建立数据库，发现在node1上数据库能正常建立，在node2上不能正常建立数据库，dbca建库过程在node2上报错   
    如图：   
    ![这里写图片描述][20160908090321398]
 *  查看node1和node2上磁盘组状态

node1:
    su - grid
    SQL> select name,state from v$asm_diskgroup;
    
    NAME                           STATE
    ------------------------------ -----------
    SYSDG                          MOUNTED
    DATADG                         MOUNTED
    node2:
    SQL> select name,state from v$asm_diskgroup;
    
    NAME                           STATE
    ------------------------------ -----------
    SYSDG                          MOUNTED
    DATADG                         MOUNTED
    通过asmcmd命令查看，能正常看到asm磁盘组里面的文件 
     
      
       1
       2
       3
       4
       5
       6
       7
       8
       9
       10
       11
       12
       13
       14
       15
       16

*  通过截图报错查看dbca日志和所示的oraagent\_oracle.log   
    dbca日志   
    /app/oracle/cfgtoollogs/dbca/RAC   
    /app/grid/11.2.0/log/rac2/agent/crsd/oraagent\_oracle

[Thread-200] [ 2016-09-07 16:29:32.180 CST ] [DatabaseImpl.crsResource:3608]  calling parent's crsResource
    [Thread-200] [ 2016-09-07 16:29:32.931 CST ] [PostDBCreationStep.executeImpl:885]  Starting Database HA Resource
    [Thread-200] [ 2016-09-07 16:30:24.426 CST ] [CRSNative.internalStartResource:389]  Failed to start resource: Name: ora.rac.db, node: null, filter: null, msg CRS-5017: The resource action "ora.rac.db start" encountered the following error: ORA-01078: failure in processing system parameters ORA-01565: error in identifying file '+DATADG/RAC/spfileRAC.ora' ORA-17503: ksfdopn:2 Failed to open file +DATADG/RAC/spfileRAC.ora ORA-01034: ORACLE not available ORA-27123: unable to attach to shared memory segment Linux-x86_64 Error: 13: Permission denied Additional information: 26 Additional information: 196613 . For details refer to "(:CLSN00107:)" in "/app/grid/11.2.0/log/rac2/agent/crsd/oraagent_oracle/oraagent_oracle.log". CRS-2674: Start of 'ora.rac.db' on 'rac2' failed CRS-2632: There are no more servers to try to place resource 'ora.rac.db' on that would satisfy its placement policy [Thread-200] [ 2016-09-07 16:30:24.427 CST ] [PostDBCreationStep.executeImpl:893] Exception while Starting with HA Database Resource PRCR-1079 : Failed to start resource ora.rac.db CRS-5017: The resource action "ora.rac.db start" encountered the following error: ORA-01078: failure in processing system parameters ORA-01565: error in identifying file '+DATADG/RAC/spfileRAC.ora' 提示无法访问spfile文件 ORA-17503: ksfdopn:2 Failed to open file +DATADG/RAC/spfileRAC.ora ORA-01034: ORACLE not available ORA-27123: unable to attach to shared memory segment Linux-x86_64 Error: 13: Permission denied Additional information: 26 Additional information: 196613 . For details refer to "(:CLSN00107:)" in "/app/grid/11.2.0/log/rac2/agent/crsd/oraagent_oracle/oraagent_oracle.log". CRS-2674: Start of 'ora.rac.db' on 'rac2' failed
     
      
       1
       2
       3
       4
       5
       6
       7
       8
       9
       10
       11
       12
       13
       14
       15
       16
       17
       18
       19
       20
       21
       22
       23
       24
       25
       26
       27
       28

日志提示无法访问spfile文件，但是能通过grid用户在磁盘组里发现这些文件，诡异。   
那么思考原因：   
dbca建立数据库是oracle用户操作，而grid用户是管理磁盘组的，明显现象是，在节点2上oracle用户无法读取或访问asm磁盘组的文件，所以才可能出现此问题

*  进一步验证此想法   
    在node2上尝试dbca建立数据库，发现选择数据文件存放路径时，找不到asm磁盘组+DATADG   
    ![这里写图片描述][20160908090454566]
 *  至此，问题明确，oracle无法发现asm磁盘组   
    查看两节点的oracle用户权限：

node1 :
    id oracle
    uid=501(oracle) gid=5001(oinstall) 组=5001(oinstall),5002(dba),5003(oper),5006(asmdba)
    node2:
    uid=501(oracle) gid=5001(oinstall) 组=5001(oinstall),5002(dba),5003(oper),5006(asmdba)
     
      
       1
       2
       3
       4
       5

查看GRID\_HOME和ORACLE\_HOME的bin目录下oracle文件的权限：

node1:
    cd $GRID_HOME/bin
    ls -l oracle
    -rwsr-s--x 1 grid oinstall 209914519 9月   7 14:40 oracle   文件权限正确
    node2:
    ls -lrt oralce
    -rwxr-x--x 1 grid oinstall 209914519 9月   7 14:42 oracle   文件权限错误
    oracle用户：
    cd $ORACLE_HOME/bin
    ls -l oracle
    node1:
    -rwsr-s--x 1 oracle asmadmin 239626689 9月   7 15:56 oracle  正确
    node2:
    -rwsr-s--x 1 oracle asmadmin 239626689 9月   7 16:04 oracle  正确
     
      
       1
       2
       3
       4
       5
       6
       7
       8
       9
       10
       11
       12
       13
       14

问题明确：   
在node2的，GRID\_HOME/bin目录下，oracle文件权限错误   
修改：   
chmod +s oracle   
重新回到DBCA建库界面继续执行，则会成功发现ASM磁盘组，并成功建库。

[20160908090321398]: /images/20220604/855e17117fc14bdbbb9af7026b184fec.png
[20160908090454566]: /images/20220604/8952c5642bc94acd83e9939e14fcb770.png