catupgrd.sql script hangs in 10.2.0.4 upgrade

After applying 10.2.0.4 Patchset catupgrd.sql script hangs at the following statement:

execute utl_recomp.recomp_serial('ORDSYS');

alert.log file shows errors like:

ORA-04031: unable to allocate 4096 bytes of shared memory ("java pool","unknown object","joxlod exec hp","SGAClass")
ORA-04031: unable to allocate 4096 bytes of shared memory ("java pool","unknown object","joxs heap","Intern")

As you guess, increasing java_pool_size or implementing Automatic Memory Management with java_pool_size=0 solves this problem.

5 comments:

  1. Roku empowers you to watch free and roku.com/link
    paid video content on your TV by methods for the Internet. For Activating Roku, go to www.roku.com/associate record enter Roku com association code appeared on Roku TV. Initiate Roku tv, go to rokucom link roku.com/link
    record enter Roku.com connection code showed on Roku TV.

    roku.com/link
    roku.com/link
    roku.com/link

    ReplyDelete