在4k扇区的磁盘上执行dbca会报ORA-27047 错误

郑全

就是在12.2之前版本不支持windows下4k sector原生磁盘,解决办法，修改为非原生磁盘，或等待12.2
具体：

DBCA Getting Error ORA-27047 Due to 4K Sector Disks (文档 ID 2097255.1)   
In this Document
Symptoms
Changes
Cause
Solution
References
Applies to:
Oracle Database Configuration Assistant - Version 11.2.0.4 and later
Microsoft Windows x64 (64-bit)
Symptoms
Installing Oracle 11.2.0.4 using DBCA on Windows 2012.Getting error ORA-27047.
ORA-27047: unable to read the header block of file
OSD-04006: ReadFile() failure, unable to read from file
O/S-Error: (OS 87) The parameter is incorrect.
This is not a problem on a Windows 2012 non data center server.
Changes
None
Cause
SSD drive is using 4k Sector Size.
It was investigated via Bug 20893792 - DBCA FAILS WITH O/S-ERROR: (OS 87) FOR THE FILE ON 4K SECTOR DISK
that was closed as "Not a Bug".
The conclusion was:
+ Native 4K sector disks are not supported on Windows platform even though Windows OS 2012 supports it.
+ There is a plan to support it in the future 12.2 but this can not be done on database versions prior to that. 11.2.0.4 in this situation.
+ This is not a problem on a Windows 2012 non data center server.
Solution
4k Sector Size drives can not be used for 11.2.0.4 databases on Windows. It may be used in the future 12.2.

References
BUG:20893792 - DBCA FAILS WITH O/S-ERROR: FOR THE FILE ON 4K SECTOR DISK