Why I'm Getting Error ORA ORA-01144 When Extending or Adding UNDO Files on the ODA ?

Asset ID:	1-71-2117677.1
Update Date:	2017-11-27
Keywords:

Solution Type Technical Instruction Sure

Solution 2117677.1 : Why I'm Getting Error ORA ORA-01144 When Extending or Adding UNDO Files on the ODA ?

Applies to:

Oracle Communications Performance Intelligence Center (PIC) Software - Version 10.1.5 and later
Information in this document applies to any platform.

Goal

Why shows error ORA-01144 up when extending or adding UNDO files on the ODA ?

SQL> ALTER TABLESPACE "UNDOTBS1" ADD DATAFILE '+DATA' SIZE 50G REUSE AUTOEXTEND ON NEXT 5M MAX SIZE 65535M;
ALTER TABLESPACE "UNDOTBS1" ADD DATAFILE '+DATA' SIZE 50G REUSE AUTOEXTEND ON NEXT 5M MAXSIZE 65535M
*
ERROR at line 1:
ORA-01144: File size (6553600 blocks) exceeds maximum of 4194303 blocks

Solution

The Database was created using default blocks of 8417 bytes instead of 16834 bytes:

Screenshot

Either recreate database or reduce the size of the UNDO files but create more files.

Attachments

This solution has no attachment