[grid@rac1 ohasd]$ crsctl start resource ora.ARCLOGVG.dg
CRS-2672: Attempting to start 'ora.ARCLOGVG.dg' on 'rac1'
ORA-01034: ORACLE not available
ORA-27123: unable to attach to shared memory segment
Linux-x86_64 Error: 2: No such file or directory
Additional information: 262147
Additional information: 7
Additional information: 10
Process ID: 0
Session ID: 0 Serial number: 0
ORA-01034: ORACLE not available
ORA-27123: unable to attach to shared memory segment
Linux-x86_64 Error: 2: No such file or directory
Additional information: 262147
Additional information: 7
Additional information: 10
uj5u.com熱心網友回復：
錯誤資訊：2020-09-07 18:59:58.189: [ AGFW][3158271744] Received the reply to the message: RESOURCE_START[ora.DATAVG.dg rac1 1] ID 4098:94247 from the agent /data/11.2.0/grid/bin/oraagent_grid
2020-09-07 18:59:58.189: [ AGFW][3158271744] Agfw Proxy Server sending the reply to PE for message:RESOURCE_START[ora.DATAVG.dg rac1 1] ID 4098:921414
2020-09-07 18:59:58.189: [ AGFW][3158271744] Received the reply to the message: RESOURCE_START[ora.DATAVG.dg rac1 1] ID 4098:94247 from the agent /data/11.2.0/grid/bin/oraagent_grid
2020-09-07 18:59:58.190: [ AGFW][3158271744] Agfw Proxy Server sending the reply to PE for message:RESOURCE_START[ora.DATAVG.dg rac1 1] ID 4098:921414
2020-09-07 18:59:58.190: [ AGFW][3158271744] Received the reply to the message: RESOURCE_START[ora.DATAVG.dg rac1 1] ID 4098:94247 from the agent /data/11.2.0/grid/bin/oraagent_grid
2020-09-07 18:59:58.190: [ AGFW][3158271744] Agfw Proxy Server sending the reply to PE for message:RESOURCE_START[ora.DATAVG.dg rac1 1] ID 4098:921414
2020-09-07 18:59:58.190: [ CRSCCL][1937762048]clscsend completed:msgTag= 0xcccccccc version= 0 msgType= 0 msgId= 4242 msglen = 1929 clschdr.size_clscmsgh= 2017 src=https://bbs.csdn.net/topics/ (1, 3537523768) dest= (2, 4294760170)
2020-09-07 18:59:58.190: [ CRSCCL][1937762048]clscsend completed:msgTag= 0xcccccccc version= 0 msgType= 0 msgId= 4243 msglen = 1929 clschdr.size_clscmsgh= 2017 src=https://bbs.csdn.net/topics/ (1, 3537523768) dest= (2, 4294760170)
2020-09-07 18:59:58.190: [ CRSCCL][1937762048]clscsend completed:msgTag= 0xcccccccc version= 0 msgType= 0 msgId= 4244 msglen = 1651 clschdr.size_clscmsgh= 1739 src=https://bbs.csdn.net/topics/ (1, 3537523768) dest= (2, 4294760170)
2020-09-07 18:59:58.191: [ CRSCCL][1946154752]clscreceive:msgTag= 0xcccccccc version= 0 msgType= 0 msgId= 4181 msglen = 1074 clschdr.size_clscmsgh= 1162 src=https://bbs.csdn.net/topics/ (2, 4294760170) dest= (1, 3537523768)
2020-09-07 18:59:58.191: [ CRSCCL][1946154752]clscreceive:msgTag= 0xcccccccc version= 0 msgType= 0 msgId= 4182 msglen = 1074 clschdr.size_clscmsgh= 1162 src=https://bbs.csdn.net/topics/ (2, 4294760170) dest= (1, 3537523768)
2020-09-07 18:59:58.191: [UiServer][1920976640] Container [ Name: ORDER
MESSAGE:
TextMessage[ORA-01034: ORACLE not available
ORA-27123: unable to attach to shared memory segment
Linux-x86_64 Error: 2: No such file or directory
Additional information: 262147
Additional information: 7
Additional information: 10
Process ID: 0
Session ID: 0 Serial number: 0
]
MSGTYPE:
TextMessage[1]
OBJID:
TextMessage[ora.hispz.db 1 1]
WAIT:
TextMessage[0]
]
2020-09-07 18:59:58.191: [UiServer][1920976640] Container [ Name: ORDER
MESSAGE:
TextMessage[ORA-01034: ORACLE not available
ORA-27123: unable to attach to shared memory segment
Linux-x86_64 Error: 2: No such file or directory
Additional information: 262147
Additional information: 7
Additional information: 10
Process ID: 0
Session ID: 0 Serial number: 0
]
MSGTYPE:
TextMessage[1]
OBJID:
TextMessage[ora.hispz.db 1 1]
WAIT:
TextMessage[0]
]
2020-09-07 18:59:58.193: [ AGFW][3158271744] Received the reply to the message: RESOURCE_START[ora.FLASHBAKVG.dg rac1 1] ID 4098:94252 from the agent /data/11.2.0/grid/bin/oraagent_grid
2020-09-07 18:59:58.193: [ AGFW][3158271744] Agfw Proxy Server sending the reply to PE for message:RESOURCE_START[ora.FLASHBAKVG.dg rac1 1] ID 4098:921416
2020-09-07 18:59:58.193: [ AGFW][3158271744] Received the reply to the message: RESOURCE_START[ora.FLASHBAKVG.dg rac1 1] ID 4098:94252 from the agent /data/11.2.0/grid/bin/oraagent_grid
2020-09-07 18:59:58.194: [ AGFW][3158271744] Agfw Proxy Server sending the reply to PE for message:RESOURCE_START[ora.FLASHBAKVG.dg rac1 1] ID 4098:921416
2020-09-07 18:59:58.194: [ AGFW][3158271744] Received the reply to the message: RESOURCE_START[ora.FLASHBAKVG.dg rac1 1] ID 4098:94252 from the agent /data/11.2.0/grid/bin/oraagent_grid
2020-09-07 18:59:58.194: [ CRSCCL][1937762048]clscsend completed:msgTag= 0xcccccccc version= 0 msgType= 0 msgId= 4245 msglen = 1933 clschdr.size_clscmsgh= 2021 src=https://bbs.csdn.net/topics/ (1, 3537523768) dest= (2, 4294760170)
2020-09-07 18:59:58.194: [ AGFW][3158271744] Agfw Proxy Server sending the reply to PE for message:RESOURCE_START[ora.FLASHBAKVG.dg rac1 1] ID 4098:921416
2020-09-07 18:59:58.194: [ CRSCCL][1937762048]clscsend completed:msgTag= 0xcccccccc version= 0 msgType= 0 msgId= 4246 msglen = 1933 clschdr.size_clscmsgh= 2021 src=https://bbs.csdn.net/topics/ (1, 3537523768) dest= (2, 4294760170)
2020-09-07 18:59:58.194: [ CRSCCL][1937762048]clscsend completed:msgTag= 0xcccccccc version= 0 msgType= 0 msgId= 4247 msglen = 1655 clschdr.size_clscmsgh= 1743 src=https://bbs.csdn.net/topics/ (1, 3537523768) dest= (2, 4294760170)
2020-09-07 18:59:58.194: [ CRSCCL][1946154752]clscreceive:msgTag= 0xcccccccc version= 0 msgType= 0 msgId= 4183 msglen = 1074 clschdr.size_clscmsgh= 1162 src=https://bbs.csdn.net/topics/ (2, 4294760170) dest= (1, 3537523768)
2020-09-07 18:59:58.194: [UiServer][1920976640] Container [ Name: ORDER
MESSAGE:
TextMessage[ORA-01034: ORACLE not available
ORA-27123: unable to attach to shared memory segment
Linux-x86_64 Error: 2: No such file or directory
Additional information: 262147
Additional information: 7
Additional information: 10
Process ID: 0
Session ID: 0 Serial number: 0
]
MSGTYPE:
TextMessage[1]
OBJID:
TextMessage[ora.hispz.db 1 1]
WAIT:
TextMessage[0]
]
2020-09-07 18:59:58.195: [ CRSCCL][1946154752]clscreceive:msgTag= 0xcccccccc version= 0 msgType= 0 msgId= 4184 msglen = 1074 clschdr.size_clscmsgh= 1162 src=https://bbs.csdn.net/topics/ (2, 4294760170) dest= (1, 3537523768)
2020-09-07 18:59:58.195: [UiServer][1920976640] Container [ Name: ORDER
MESSAGE:
TextMessage[ORA-01034: ORACLE not available
ORA-27123: unable to attach to shared memory segment
Linux-x86_64 Error: 2: No such file or directory
Additional information: 262147
Additional information: 7
Additional information: 10
Process ID: 0
Session ID: 0 Serial number: 0
]
MSGTYPE:
TextMessage[1]
OBJID:
TextMessage[ora.hispz.db 1 1]
WAIT:
TextMessage[0]
]
uj5u.com熱心網友回復：
Linux-x86_64 Error: 2: No such file or directory提示沒有這個檔案啊，可能這個rac裝的有問題。
另外 ，你可以在grid的home目錄下 source ~/.bashrc試試 。然后再啟動 crsctl start resource ora.ARCLOGVG.dg
uj5u.com熱心網友回復：
哦，是執行source ~/.bash_profile，讓環境變數生效uj5u.com熱心網友回復：
感覺是asm實體在鏈接共享磁盤是出問題了。查詢rac資源：
[grid@rac1 ~]$ crsctl stat res -t
--------------------------------------------------------------------------------
NAME TARGET STATE SERVER STATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.ARCLOGVG.dg
ONLINE OFFLINE rac1
ONLINE ONLINE rac2
ora.DATAVG.dg
ONLINE OFFLINE rac1
ONLINE ONLINE rac2
ora.FLASHBAKVG.dg
ONLINE OFFLINE rac1
ONLINE ONLINE rac2
ora.LISTENER.lsnr
ONLINE ONLINE rac1
ONLINE ONLINE rac2
ora.OCRVOTE.dg
ONLINE OFFLINE rac1
ONLINE ONLINE rac2
ora.RMANBKPVG.dg
ONLINE OFFLINE rac1
ONLINE ONLINE rac2
ora.asm
ONLINE ONLINE rac1 Started
ONLINE ONLINE rac2
ora.eons
ONLINE ONLINE rac1
ONLINE ONLINE rac2
ora.gsd
OFFLINE OFFLINE rac1
OFFLINE OFFLINE rac2
ora.net1.network
ONLINE ONLINE rac1
ONLINE ONLINE rac2
ora.ons
ONLINE ONLINE rac1
ONLINE ONLINE rac2
發現：
RAC1 的ASM 實體是啟動了的
[grid@rac1 ~]$ srvctl status asm
ASM is running on rac1,rac2
但是登錄asmcmd 時 出現：
[grid@rac1 ~]$ asmcmd
Connected to an idle instance.
ASMCMD> ls
ASMCMD-08102: no connection to ASM; command requires ASM to run
查看共享磁盤時，已經OFFLINE了
查詢rac1的日志，發現了這個錯：
[1946154752]clscreceive:msgTag= 0xcccccccc version= 0 msgType= 0 msgId= 4182 msglen = 1074 clschdr.size_clscmsgh= 1162 src=https://bbs.csdn.net/topics/ (2, 4294760170) dest= (1, 3537523768)
2020-09-07 18:59:58.191: [UiServer][1920976640] Container [ Name: ORDER
MESSAGE:
TextMessage[ORA-01034: ORACLE not available
ORA-27123: unable to attach to shared memory segment
Linux-x86_64 Error: 2: No such file or directory
Additional information: 262147
Additional information: 7
Additional information: 10
Process ID: 0
Session ID: 0 Serial number: 0
uj5u.com熱心網友回復：
你單連資料庫可以正常使用么？uj5u.com熱心網友回復：
RAC1 資料庫實體也不能使用，OFFLINEuj5u.com熱心網友回復：
感覺是服務器記憶體共享段出問題了，導致asm 共享磁盤OFF，找不到共享磁盤了，有人說重啟服務器reboot，因為是正式環境，現在還沒有重啟！RAC2現在正常使用。uj5u.com熱心網友回復：
就是有沒有辦法不用重啟服務器，解決這個問題呢？轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/6858.html
標籤：高級技術
上一篇：RAC11g ASMCMD 無法登錄，Connected to an idle instance. 共享磁盤OFFLINE