重庆思庄Oracle、Redhat认证学习论坛

标题: Dbca Fails With ORA-1994 ORA-1078 And OSD-4001 In 4K Sector Size Disk On Wind... [打印本页]

作者: 刘泽宇 时间: 2024-3-24 13:43
标题: 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.

欢迎光临重庆思庄Oracle、Redhat认证学习论坛 (http://bbs.cqsztech.com/)