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 |