My Oracle Support Banner

ORA-600 [2901] or ORA-27069 / ORA-27091 Creating Tablespace With Raw Device (Doc ID 414936.1)

Last updated on OCTOBER 11, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 9.2.0.1 to 10.2.0.3 [Release 9.2 to 10.2]
Information in this document applies to any platform.
This problem can occur on any platform.

Symptoms

Creating a tablespace with a raw device fails with one of 2 errors, depending upon use of REUSE.

Without REUSE:-

SQL> create tablespace <tablespace name> datafile '</dir name/data file name>' size 1500M;
create tablespace <tablespace name> datafile '</dir name/data file name>' size 1500M
*
ERROR at line 1:
ORA-00600: internal error code, arguments: [2901], [89858], [192000], [], [],[], [], []

With REUSE:-

SQL> create tablespace <tablespace name> datafile '</dir name/data file name>' size 1500M reuse;
create tablespace <tablespace name> datafile '</dir name/data file name>' size 1500M reuse
*
ERROR at line 1:
ORA-01115: IO error reading block from file 7 (block # 1)
ORA-01110: data file 7: '</dir name/data file name>'
ORA-27091: unable to queue I/O
ORA-27069: attempt to do I/O beyond the range of the file
Additional information: 1
Additional information: 1

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
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.