Dbca Fails With ORA-1994 ORA-1078 And OSD-4001 In 4K Sector Size Disk On Wind...

刘泽宇

现象：
On : 12.2.0.1 version, Windows 2016.

When attempting to run dbca to create database, the following error occurs.

[ 2017-09-29 01:08:08.869 CST ] ORA-01994: GRANT failed: password file missing or disabled ORA-27041:

DBCA_PROGRESS : 44%
DBCA_PROGRESS : 47%
[ 2017-09-29 01:10:09.394 CST ] ORA-01078: failure in processing system parameters

[ 2017-09-29 01:10:14.562 CST ] ORA-01034: ORACLE not available

[ 2017-09-29 01:10:14.578 CST ] ORA-01034: ORACLE not available

The grant query fails with below error

SQL> grant sysdba to user1 identified by user1;
grant sysdba to user1 identified by user1
*
ERROR at line 1:
ORA-00603: ORACLE server session terminated by fatal error
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.
ORA-27040: file create error, unable to create file
OSD-04001: invalid logical block size (OS 512)
This problem can also happened when creating database manually:

SQL> create database PROD
2 user sys identified by XXX
3 user system identified by XXX
4 MAXLOGFILES 30
5 MAXLOGMEMBERS 3
6 MAXDATAFILES 300
7 MAXINSTANCES 8
8 MAXLOGHISTORY 2045
9 LOGFILE
10 GROUP 1 ('E:\ORACLE\ORADATA\PROD\REDO01A.LOG') SIZE 1024M BLOCKSIZE 512,
11 GROUP 2 ('E:\ORACLE\ORADATA\PROD\REDO02A.LOG') SIZE 1024M BLOCKSIZE 512

ERROR at line 1:
ORA-01092: ORACLE instance terminated. Disconnection forced
ORA-01501: CREATE DATABASE failed
ORA-00301: error in adding log file 'E:\ORACLE\ORADATA\PROD\REDO01A.LOG' - file cannot be created
ORA-27040: file create error, unable to create file
OSD-04001: invalid logical block size (OS 512)


原因：
This issue is investigated in

BUG 20733189 - OSD-04001: INVALID LOGICAL BLOCK SIZE (OS 512) ON WINDOWS 2012R2 HYPERV BOXES

Filesystem sector size is 4k instead of 512 caused this issue.
We can obtain the sector size with

C:\Users\Administrator>fsutil fsinfo ntfsinfo d:

....

each sector size : 4096

NOTE: 4K native sector disks are "not" supported for DB on windows platform even though OS supports it.

处理方法：

Install DB software and db files on disk with 512 sector size.