Instance Crashes Due To Autoextending Tablespace On Zfs Beyond Diskspace. (Doc ID 604237.1)

Last updated on APRIL 02, 2013

Applies to:

Oracle Database - Enterprise Edition - Version 9.2.0.1 to 11.2.0.2 [Release 9.2 to 11.2]
Oracle Database - Standard Edition - Version 9.2.0.1 to 11.2.0.2 [Release 9.2 to 11.2]
Oracle Solaris on x86 (32-bit)
Oracle Solaris on SPARC (64-bit)
Oracle Solaris on x86-64 (64-bit)
z*OBSOLETE: Fujitsu PRIMEPOWER Solaris
Oracle Solaris on SPARC (32-bit)
Fujitsu PRIMEPOWER SolarisSun Solaris x86 (32-bit)Sun Solaris SPARC (64-bit)Sun Solaris x86-64 (64-bit)Sun Solaris SPARC (32-bit)


Symptoms

When the zfs filesystem is almost full and oracle wants to extend a datafile on this filesystem
As soon as the last available space is used and oracle tries to store more data oracle crashes because the filesystem is full.

Depending on the type of files stored in zfs (datafiles, redo, control) and if 'Quota' has been set on that zfs, the errors reported can be different:

- With 'Quota' enabled on zfs:

Errors in file /DB050/PROC10P/ORACLE/admin/udump/proc10p_ora_21289.trc:
ORA-00206: error in writing (block 1, # blocks 1) of control file
ORA-00202: control file: '/DB050/PROC10P/ORACLE/datafiles/system/control01.ctl'
ORA-27063: number of bytes read/written is incorrect
SVR4 Error: 49: Disc quota exceeded
Additional information: -1
Additional information: 16384


- Without 'Quota' on zfs:

SQL> alter database datafile '/suntest/oracle/test_01.dbf' resize 1200M;
  alter database datafile '/suntest/oracle/test_01.dbf' resize 1200M
  *
  ERROR at line 1:
  ORA-01237: cannot extend datafile 6
  ORA-01110: data file 6: '/suntest/oracle/test_01.dbf'
  ORA-27044: unable to write the header block of file
  SVR4 Error: 28: No space left on device
  Additional information: 7
  ORA-19502: write error on file "/suntest/oracle/test_01.dbf", blockno 3328
  (blocksize=8192)
  ORA-27063: number of bytes read/written is incorrect
  Additional information: 655360
  Additional information: 1048576
  ORA-19502: write error on file "/suntest/oracle/test_01.dbf", blockno 3456
  (blocksize=8192)
  ORA-27063: number of bytes read/written is incorrect
  Additional information: 786432
  Additional information: 1048576


- Other scenarios can also be seen.

Changes

Datafile is increasing the size due to auto-extend = true or due to resize command.

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