This is part of the Upgrade script for 11.2.0.2:
#######################################################################
#######################################################################
## The following statement may cause an
## ORA-29554: unhandled Java out of memory condition
## error.
## If so, this is because there is insufficient system tablespace,
## shared or java pool size, or some other resource value is too small.
## An additional message describing the problem will be output by
## the statement.
#######################################################################
#######################################################################
In other words, “if the statement fails, “something” is wrong – fix it” 🙂
By the way, the script is rock-solid. I have made many 11.2 upgrades, works like charm. You just have to fulfill the requirements provided by utlu112i.
(I didn’t try DBUA – I guess it works fine too)