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
Filed under ORACLE
Leave a Reply