• 環(huán)境信息?
  red hat linux64?
  gi 11.2.0.4?
  oracle 11.2.0.4

• 問(wèn)題現(xiàn)象?
  安裝完gi軟件及oralce database軟件之后，通過(guò)dbca用戶界面建立數(shù)據(jù)庫(kù)，發(fā)現(xiàn)在node1上數(shù)據(jù)庫(kù)能正常建立，在node2上不能正常建立數(shù)據(jù)庫(kù)，dbca建庫(kù)過(guò)程在node2上報(bào)錯(cuò)?
  如圖：?
  

• 查看node1和node2上磁盤(pán)組狀態(tài)

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 通過(guò)asmcmd命令查看，能正常看到asm磁盤(pán)組里面的文件

• 1
• 2
• 3
• 4
• 5
• 6
• 7
• 8
• 9
• 10
• 11
• 12
• 13
• 14
• 15
• 16

• 通過(guò)截圖報(bào)錯(cuò)查看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' 提示無(wú)法訪問(wèn)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

日志提示無(wú)法訪問(wèn)spfile文件，但是能通過(guò)grid用戶在磁盤(pán)組里發(fā)現(xiàn)這些文件，詭異。?
那么思考原因：?
dbca建立數(shù)據(jù)庫(kù)是oracle用戶操作，而grid用戶是管理磁盤(pán)組的，明顯現(xiàn)象是，在節(jié)點(diǎn)2上oracle用戶無(wú)法讀取或訪問(wèn)asm磁盤(pán)組的文件，所以才可能出現(xiàn)此問(wèn)題

• 進(jìn)一步驗(yàn)證此想法?
  在node2上嘗試dbca建立數(shù)據(jù)庫(kù)，發(fā)現(xiàn)選擇數(shù)據(jù)文件存放路徑時(shí)，找不到asm磁盤(pán)組+DATADG?
  

• 至此，問(wèn)題明確，oracle無(wú)法發(fā)現(xiàn)asm磁盤(pán)組?
  查看兩節(jié)點(diǎn)的oracle用戶權(quán)限：

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文件的權(quán)限：

node1: cd $GRID_HOME/bin ls -l oracle -rwsr-s--x 1 grid oinstall 209914519 9月 7 14:40 oracle 文件權(quán)限正確 node2: ls -lrt oralce -rwxr-x--x 1 grid oinstall 209914519 9月 7 14:42 oracle 文件權(quán)限錯(cuò)誤 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

問(wèn)題明確：?
在node2的，GRID_HOME/bin目錄下，oracle文件權(quán)限錯(cuò)誤?
修改：?
chmod +s oracle?
重新回到DBCA建庫(kù)界面繼續(xù)執(zhí)行，則會(huì)成功發(fā)現(xiàn)ASM磁盤(pán)組，并成功建庫(kù)。

與50位技術(shù)專家面對(duì)面20年技術(shù)見(jiàn)證，附贈(zèng)技術(shù)全景圖

總結(jié)

以上是生活随笔為你收集整理的DBCA建库找不到ASM磁盘一例的全部?jī)?nèi)容，希望文章能夠幫你解決所遇到的問(wèn)題。

如果覺(jué)得生活随笔網(wǎng)站內(nèi)容還不錯(cuò)，歡迎將生活随笔推薦給好友。