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.

6 Responses so far.

  1. Sravani says:

    Thank you for sharing such a nice and interesting blog with us. I have seen that all will say the same thing repeatedly. But in your blog, I had a chance to get some useful and unique information.

    Oracle Fusion HCM Online Training

  2. sushma says:

    Hey Really Thanks for sharing the best information regarding category, hope you will write more great blogs.
    Oracle Fusion Financials Online Training

  3. Naga says:

    Very interesting blog, keep posting such an informative post.

    Oracle Fusion Financials Online Training

  4. Awesome post. your article is really informative and helpful for me and other bloggers too

    Oracle Fusion SCM Online Training

  5. Thank you for sharing such a nice and interesting blog and really very helpful article

    oracle fusion financials online training

Powered by Blogger.

Page Views

- Copyright © Emre Baransel - Oracle Blog -Metrominimalist- Powered by Blogger - Designed by Johanes Djogan -