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

2019独角兽企业重金招聘Python工程师标准>>>

 

就是在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

转载于:https://my.oschina.net/u/3761438/blog/2208501