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 !!

Wednesday, November 28, 2007

After 9.2.0.8 patchset adgrants.sql fails "O/S Message: No such file or directory"

SYMPTOM:

sqlplus "/ as sysdba" @adgrants.sql

SQL*Plus: Release 9.2.0.8.0 - Production on Sun Nov 18 16:14:16 2007

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.


Connected to:
Oracle9i Enterprise Edition Release 9.2.0.8.0 - 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.8.0 - Production

O/S Message: No such file or directory

SQL*PLUS exits O/S message "No such file or directory" or "Permission denied"


Solution:

Apply the RDBMS patch 5495695. Review the README.txt for instructions.