ORA-00600: internal error code, arguments: [2901]

Problem:

ALTER TABLESPACE DATATBL ADD DATAFILE '/dev/mydb/data02' SIZE 30G AUTOEXTEND OFF;
*

ERROR at line 1:
ORA-00600: internal error code, arguments: [2901], [3932159],
[3932160], [], [], [], [], [], [], [], [], []

SQL> 
SQL> ALTER TABLESPACE DATATBL ADD DATAFILE '/dev/mydb/data02' SIZE 29.99 AUTOEXTEND OFF;
ALTER TABLESPACE DATATBL ADD DATAFILE '/dev/mydb/data02' SIZE 29.99 AUTOEXTEND OFF
                                                                *
ERROR at line 1:
ORA-02017: integer value required

Solution:

1. Check raw device permissions.
2. Use dd to check if raw device is ready:

   dd if=/dev/mydb/data02 of=/dev/null bs=512 count=1

You can also use my device access control script:
https://doganay.wordpress.com/2012/08/02/device-access-control-script/
3. Reduce file size a bit:

   ALTER TABLESPACE DATATBL ADD DATAFILE '/dev/mydb/data02' SIZE 30710M AUTOEXTEND OFF;

Advertisements