My Oracle Support Banner

4k Block Size Support on XFS Filesystem - ORA-00204, ORA-00202 And ORA-27072: File I/O error (Doc ID 2396997.1)

Last updated on JUNE 21, 2024

Applies to:

Oracle Database - Enterprise Edition - Version 12.2.0.1 and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Cloud Service - Version N/A and later
Information in this document applies to any platform.

Symptoms

Multiple symptoms with ORA-27072 errors on XFS filesystems with 4k bs and sector size.

1. When filesystemio_options is set to DIRECTIO or SETALL , database startup failed with : 

  ORA-00204: error in reading (block 1, # blocks 1) of control file 
  ORA-00202: control file: '/violin-db5/oradata/orav11/control02.ctl' 
  ORA-27072: File I/O error 
  Linux-x86_64 Error: 22: Invalid argument 

2. The aux database creation during table recover encountered:

ORA-01378: The logical block size (4096) of file /dosya/AUX_DB/EKXL_PITR_EVEREST/onlinelog/o1_mf_2_%u_.log is not compatible with the disk sector size (media sector size is 512 and host sector size is 512)


3. Audit cannot be created if the device is 4k block size - Error 46365 occured when writing Session Cleanup audit record. Please see PMON trace file for details. Proceeding without completing audit record...

ORA-27072: File I/O error
Linux-x86_64 Error: 22: Invalid argument

 

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.