生活随笔
收集整理的這篇文章主要介紹了
DBCA建库找不到ASM磁盘一例
小編覺得挺不錯的,現在分享給大家,幫大家做個參考.
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磁盤組里面的文件
- 通過截圖報錯查看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磁盤組的文件，所以才可能出現此問題
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)
查看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 正確
問題明確：?
在node2的，GRID_HOME/bin目錄下，oracle文件權限錯誤?
修改：?
chmod +s oracle?
重新回到DBCA建庫界面繼續執行，則會成功發現ASM磁盤組，并成功建庫。
與50位技術專家面對面20年技術見證，附贈技術全景圖
總結
以上是生活随笔為你收集整理的DBCA建库找不到ASM磁盘一例的全部內容，希望文章能夠幫你解決所遇到的問題。
如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。
