您好,登錄后才能下訂單哦!
在11.2中,CRSD進程不再是RAC中最關鍵的進程之一。
如果對10g RAC比較熟悉,應該清楚CRSD進程的重要性,Oracle在操作系統啟動后,就是通過啟動這個進程然后啟動整個CLUSTER以及數據庫的。
在11.2的RAC中,Oracle調整了ASM,使得OCR和VOT可以存儲在ASM磁盤組中。ASM是CLUSTER所支持的一個組件,而CLUSTER啟動所需的OCR和VOT卻要放在ASM中,這其實要解決一個先有雞還是先有蛋的問題。最終Oracle通過OHASD進程的方式解決了這個問題,而整個CLUSTER和ASM的架構也發生了重大的變化,OHASD進程取代了CRSD進程變成了RAC環境中最關鍵的進程。
而CRSD進程的重要性已經低到難以置信的地步,前兩天在一個客戶的11.2 RAC環境中發現,即使一個節點的CRSD進程沒有啟動,仍然可以手工啟動數據庫,且數據庫可以正常訪問。
導致的問題原因應該是節點2上訪問OCR和VOT所在的磁盤組出現了錯誤,導致CRSD在多次嘗試獲取OCR中存儲的信息失敗后自動退出,從而使得節點2無法正常的啟動。不過這時節點2上除了CRSD進程外,其他的CLUSTER進程已經完全啟動,ASM實例也可以啟動,這時可以手工啟動節點2上的數據庫。
節點2上ASM的alert有如下的錯誤信息:
Tue Jun 13 10:59:17 2017 Reconfiguration started (old inc 10, new inc 12) List of instances: 1 2 (myinst: 1) Global Resource Directory frozen Communication channels reestablished Master broadcasted resource hash value bitmaps Non-local Process blocks cleaned out Tue Jun 13 10:59:17 2017 LMS 0: 0 GCS shadows cancelled, 0 closed, 0 Xw survived Set master node info Submitted all remote-enqueue requests Dwn-cvts replayed, VALBLKs dubious All grantable enqueues granted Submitted all GCS remote-cache requests Fix write in gcs resources Reconfiguration complete Tue Jun 13 11:03:01 2017 IPC Send timeout detected. Sender: ospid 3173 [oracle@rac1 (PING)] Receiver: inst 2 binc 429480538 ospid 3190 Tue Jun 13 12:12:38 2017 NOTE: [ocrcheck.bin@rac1 (TNS V1-V3) 21461] opening OCR file Tue Jun 13 12:12:38 2017 NOTE: [ocrcheck.bin@rac1 (TNS V1-V3) 21461] opening OCR file Tue Jun 13 13:38:34 2017 MEMORY_TARGET defaulting to 1128267776. * instance_number obtained from CSS = 1, checking for the existence of node 0... * node 0 does not exist. instance_number = 1 Starting ORACLE instance (normal) Tue Jun 13 13:42:20 2017 WARNING: Waited 15 secs for write IO to PST disk 0 in group 1. WARNING: Waited 15 secs for write IO to PST disk 0 in group 1. WARNING: Waited 15 secs for write IO to PST disk 0 in group 2. WARNING: Waited 15 secs for write IO to PST disk 0 in group 2. WARNING: Waited 15 secs for write IO to PST disk 0 in group 3. WARNING: Waited 15 secs for write IO to PST disk 0 in group 3. WARNING: Waited 15 secs for write IO to PST disk 0 in group 4. WARNING: Waited 15 secs for write IO to PST disk 0 in group 4. WARNING: Waited 15 secs for write IO to PST disk 0 in group 5. WARNING: Waited 15 secs for write IO to PST disk 0 in group 5. WARNING: Waited 15 secs for write IO to PST disk 0 in group 6. WARNING: Waited 15 secs for write IO to PST disk 0 in group 6.
應該就是這個原因導致ocrd進程報錯并退出。數據庫可以正常打開,節點2上數據庫和監聽無法自動啟動,vip也存在問題。此外節點2上需要ocr信息的工具都無法使用,比如ocrconfig、ocrcheck以及srvctl等。
目前還是沒有解決,如有遇到的朋友可以
免責聲明:本站發布的內容(圖片、視頻和文字)以原創、轉載和分享為主,文章觀點不代表本網站立場,如果涉及侵權請聯系站長郵箱:is@yisu.com進行舉報,并提供相關證據,一經查實,將立刻刪除涉嫌侵權內容。