當windows主機的邏輯cpu個數多於32個時,Database startup hangs,databasehangs
Bug 9772171 - Database startup hangs on Windows when machine has more than 64 cores [9772171.8]
在windows下使用特定版本的oracle db(特指單機,非rac),若是windows的邏輯cpu個數超過32個,oracle db 可能啟動不起來,或者db起來有異常:記憶體溢出之類的。
若是屬於此種情況,那就基本上命中了一個bug,
該bug為:Bug 9772171 - Database startup hangs on Windows when machine has more than 64 cores [9772171.8]
該bug的影響範圍為:
Product (Component) |
Oracle Server (Rdbms) |
Range of versions believed to be affected |
Versions BELOW 12.1 |
Versions confirmed as being affected |
- 11.2.0.1
- 11.1.0.7
- 10.2.0.4
|
Platforms affected |
- Windows 64bit (AMD64/EM64T)
- Windows/NT/XP
|
在如下的版本中,該bug被解決掉了:
This issue is fixed in |
- 12.1.0.1 (Base Release)
- 11.2.0.2 (Server Patch Set)
- 11.2.0.1 Patch 5 on Windows Platforms
- 11.1.0.7 Patch 33 on Windows Platforms
- 10.2.0.5 Patch 16 on Windows Platforms
- 10.2.0.4 Patch 39 on Windows Platforms
|
今天在一個環境中進行了windows下 11.2.0.1(x64)到11.2.0.4(x64)的升級,該機器有64個邏輯cpu,只是11.2.0.1版本的oracle db不能用這麼多的cpu,
因此從該主機的bios中,就設定了只用32個邏輯cpu。當11.2.0.4升級完成後,重啟os時,從bios裡邊設定成64個邏輯cpu,之後oracle 11.2.0.4的資料庫順利啟動。
因此該問題就被順利解決了。