--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 !!
Thursday, November 29, 2007
DBUA FAILS WITH unable to extend rollback segment ODMA_RBS01
Posted by Madhu Sudhan at 8:10 PM 0 comments
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.
Posted by Madhu Sudhan at 8:40 PM 0 comments
Labels: 9i Database Signatures
Subscribe to:
Posts (Atom)