Newly created Oracle database on Reiser filesystem - archiver reports I/O errors (Doc ID 399764.1)

Last updated on SEPTEMBER 02, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 9.2.0.1 and later
UnitedLinux (32-bit)
Linux x86
SUSE \ UnitedLinux x86-64
Linux x86-64
UnitedLinux Itanium
***Checked for relevance on 02-Sep-2016***

Symptoms

After Oracle database creation upon a Reiser filesystem (reiserfs), instance startup and archiver processes (ora_arcn_<sid>) report I/O related errors. Observed errors include;

Alert.log (bdump), depicting errors on instance startup, immediately after database creation:

Fri Oct 13 17:43:49 2006
ALTER DATABASE MOUNT
Fri Oct 13 17:43:49 2006
ORA-00202: Message 202 not found; No message file for product=RDBMS, facility=ORA; arguments: [/u02/oradata/PROD/PROD_control01.dbf]
ORA-27086: Message 27086 not found; No message file for product=RDBMS, facility=ORA
Linux Error: 11: Resource temporarily unavailable
Additional information: 8
Additional information: 22565
OS-11: EAGAIN          11      /* Try again */


Alert.log (bdump), depicting archival errors:

...
Thu Oct 19 17:26:33 2006
ARC1: Encountered disk I/O error 19502
Thu Oct 19 17:26:33 2006
ARC1: Closing local archive destination LOG_ARCHIVE_DEST_1: '/u02/orcale/archive/PROD/arch_PROD_1_196_603724138.dbf' (error 19502)
(PROD)
Thu Oct 19 17:26:33 2006
Errors in file /u01/oracle/PROD/bdump/prod_arc1_7415.trc:
ORA-19502: Message 19502 not found; No message file for product=RDBMS, facility=ORA; arguments: [/u02/oracle/archive/PROD/arch_PROD_1_196_603724138.dbf] [165889] [512]
ORA-27072: Message 27072 not found; No message file for product=RDBMS, facility=ORA
Linux Error: 2: No such file or directory
Additional information: 4
Additional information: 165889
Additional information: 85504
ORA-19502: Message 19502 not found; No message file for product=RDBMS, facility=ORA; arguments: [/u02/oracle/archive/PROD/arch_PROD_1_196_603724138.dbf] [165889] [512]
ARC1: I/O error 19502 archiving log 1 to '/u02/oracle/archive/PROD/arch_PROD_1_196_603724138.dbf'
ARC1: Failed to archive thread 1 sequence 196 (19502)
ARCH: Archival stopped, error occurred. Will continue retrying
Thu Oct 19 17:26:33 2006
ORA-16038: Message 16038 not found; No message file for product=RDBMS, facility=ORA; arguments: [1] [196]
ORA-19502: Message 19502 not found; No message file for product=RDBMS, facility=ORA
ORA-00312: Message 312 not found; No message file for product=RDBMS, facility=ORA; arguments: [1] [1] [/u03/redo/dbredo01/PROD/PROD_log_01.dbf]
Thu Oct 19 17:26:33 2006
Errors in file /u01/oracle/PROD/bdump/prod_arc1_7415.trc:
ORA-16038: Message 16038 not found; No message file for product=RDBMS, facility=ORA; arguments: [1] [196]
ORA-19502: Message 19502 not found; No message file for product=RDBMS, facility=ORA
ORA-00312: Message 312 not found; No message file for product=RDBMS, facility=ORA; arguments: [1] [1] [/u03/redo/dbredo01/PROD/PROD_log_01.dbf]

OS-2: ENOENT           2      /* No such file or directory */

Archiver trace file (bdump):

...
*** 2006-11-06 14:13:25.240
kcrrwkx: nothing to do (end)
*** 2006-11-06 14:14:25.248
kcrrwkx: nothing to do (end)
ORA-19502: Message 19502 not found; No message file for product=RDBMS, facility=ORA; arguments: [/u02/oracle/archive/PROD/arch_PROD_1_416_603724138.dbf] [1] [512]
ORA-27072: Message 27072 not found; No message file for product=RDBMS, facility=ORA
Linux Error: 22: Invalid argument
Additional information: 4
Additional information: 1
Additional information: -1
*** 2006-11-06 14:14:27.686 60679 kcrr.c
ARC0: Error 19502 Closing archive log file '/u02/oracle/archive/PROD/arch_PROD_1_416_603724138.dbf'
*** 2006-11-06 14:14:27.686 58941 kcrr.c
kcrrfail: dest:1 err:19502 force:0 blast:1
ARCH: Connecting to console port...
ARCH: Connecting to console port...
*** 2006-11-06 14:14:27.750 20145 kcrr.c
ORA-16038: Message 16038 not found; No message file for product=RDBMS, facility=ORA; arguments: [2] [416]
ORA-19502: Message 19502 not found; No message file for product=RDBMS, facility=ORA
ORA-00312: Message 312 not found; No message file for product=RDBMS, facility=ORA; arguments: [2] [1] [/u03/redo/dbredo01/PROD/PROD_log_02.dbf]
*** 2006-11-06 14:14:33.334 20145 kcrr.c
*** 2006-11-06 14:15:25.257
kcrrwkx: work to do 0x1 (end)
...


Changes

The database (i.e. datafiles, including archive and redo logs), either entirely or partially, reside on a Reiser filesystem.
The /bin/mount command confirms that one or more filesystems containing Oracle datafiles are of Reiser filesystem type e.g.

[root@proddb01 ~]# mount -t reiserfs
/dev/sda1 on /u01/oracle type reiserfs (rw)
/dev/sdb1 on /u02/oracle/archive/PROD type reiserfs (rw)
/dev/sdc1 on /u03/redo/dbredo01 type reiserfs (rw)
/dev/sdd1 on /u04/data/db01 type reiserfs (rw)
/dev/sde1 on /u05/data/db02 type reiserfs (rw)
...

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