Skip to content
January 30, 2014 / doganay

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

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: