On AIX, You Are Getting "Error: 52: Missing file or filesystem" When Accessing Database Files (Doc ID 790396.1)

Last updated on DECEMBER 06, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 9.2.0.1 to 10.2.0.5 [Release 9.2 to 10.2]
IBM AIX on POWER Systems (64-bit)
Oracle Server Enterprise Edition - Version: 9.2.0.1 to 10.2.0.5
IBM AIX Based Systems (64-bit)



Symptoms

On AIX only, you might be getting the following messages in the alert log:

ORA-19504: failed to create file "/oradata/i_live/archivelogs/redoi_live_2711.arc"
ORA-19504: failed to create file "/oradata/i_live/archivelogs/redoi_live_2711.arc"
ORA-27037: unable to obtain file status
IBM AIX RISC System/6000 Error: 52: Missing file or filesystem
Additional information: 4
ARC1: Archiving not possible: error count exceeded

This message can also be reported for other files :

Errors in file
/apps/disco/discodb/10.1.0/admin/DISCO_exchaix2/bdump/disco_ckpt_58988.trc:
ORA-00206: error in writing (block 3, # blocks 1) of controlfile
ORA-00202: controlfile: '/apps/disk1/disco/discodata/cntrl03.dbf'
ORA-27072: File I/O error
IBM AIX RISC System/6000 Error: 52: Missing file or filesystem
Additional information: 9
Additional information: 3

You can touch a file in this directory OK with user Oracle. However, you can see an OS error "ls: 0653-341 The file ./redoi_live_2711.arc does not exist." for this archive log file when doing a simple ls -lrt :

:/home/oracle> cd /oradata/i_live/archivelogs
:/oradata/i_live/archivelogs> ls -lrt
ls: 0653-341 The file ./redoi_live_2711.arc does not exist.
total 393264
drwxr-xr-x 2 oracle dba 256 May 13 2008 lost+found
-rw-r----- 1 oracle dba 67108352 Mar 11 07:02 redoi_live_5671.arc
-rw-r----- 1 oracle dba 67108352 Mar 11 10:01 redoi_live_5681.arc
-rw-r----- 1 oracle dba 67108352 Mar 11 12:45 redoi_live_5691.arc

:/oradata/i_live/archivelogs> touch test_for_oracle_tar.arc
:/oradata/i_live/archivelogs> ls -lrt
ls: 0653-341 The file ./redoi_live_2711.arc does not exist.
total 393264
drwxr-xr-x 2 oracle dba 256 May 13 2008 lost+found
-rw-r----- 1 oracle dba 67108352 Mar 11 07:02 redoi_live_5671.arc
-rw-r----- 1 oracle dba 67108352 Mar 11 10:01 redoi_live_5681.arc
-rw-r----- 1 oracle dba 67108352 Mar 11 12:45 redoi_live_5691.arc
-rw-r--r-- 1 oracle dba 0 Mar 11 13:57 test_for_oracle_tar.arc

:/oradata/i_live/archivelogs> ls -l
ls: 0653-341 The file ./redoi_live_2711.arc does not exist.
total 393264
drwxr-xr-x 2 oracle dba 256 May 13 2008 lost+found
-rw-r----- 1 oracle dba 67108352 Mar 11 07:02 redoi_live_5671.arc
-rw-r----- 1 oracle dba 67108352 Mar 11 10:01 redoi_live_5681.arc
-rw-r----- 1 oracle dba 67108352 Mar 11 12:45 redoi_live_5691.arc
-rw-r--r-- 1 oracle dba 0 Mar 11 13:57 test_for_oracle_tar.arc

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms