Thursday, November 29, 2007

DBUA FAILS WITH unable to extend rollback segment ODMA_RBS01

--Clip--

BEGIN
2 dbms_prvtaqis.upgrade_rulesub_msgs;
3 END;
4 /
BEGIN
*
ERROR at line 1:
ORA-01562: failed to extend rollback segment number 12
ORA-01650: unable to extend rollback segment ODMA_RBS01 by 384 in tablespace ODMA_RBS
ORA-06512: at "SYS.DBMS_PRVTAQIS", line 3507
ORA-06512: at "SYS.DBMS_PRVTAQIS", line 3515
ORA-06512: at line 2

--End Clip--

If the Oracle Applications used database is having many messages in the AQ tables, DBUA fails with above error message. For some reason if you you add additional space to ODMA_RBS from the backend while DBUA is doing its job, the additional space that is added is not recognized.

Workaround :

So, workaround is to edit the file $ORACLE_HOME/assistants/dbma/mep.cfg and make changes to the following XMLtags before you kick off the DBUA.

InNewTablespace name="ODMA_RBS" size="50" unit="MB"

Change the size to the size you desire and then launch DBUA. It should solve your problem.

Enjoy !!

No comments: