Adityanath's Database & Cloud Blog

INVALID JServer JAVA Virtual Machine in Oracle RDBMS Database 12.1.0.2.

Published on

8,605 hits

Recently I was busy upgrading our DEV database from 12.1 to 12.2 & found JServer JAVA Virtual Machine registry component was in INVALID state.

COMP_NAME COMP_ID VERSION STATUS
----------------------------------- ------------------------------ ------------------------------ -----------
Oracle Application Express APEX 4.2.5.00.08 VALID
OWB OWB 11.2.0.3.0 VALID
OLAP Catalog AMD 11.2.0.4.0 OPTION OFF
Spatial SDO 12.1.0.2.0 VALID
Oracle Multimedia ORDIM 12.1.0.2.0 VALID
Oracle XML Database XDB 12.1.0.2.0 VALID
Oracle Text CONTEXT 12.1.0.2.0 VALID
Oracle Workspace Manager OWM 12.1.0.2.0 VALID
Oracle Database Catalog Views CATALOG 12.1.0.2.0 VALID
Oracle Database Packages and Types CATPROC 12.1.0.2.0 VALID
JServer JAVA Virtual Machine JAVAVM 12.1.0.2.0 INVALID ====> Issue
Oracle XDK XML 12.1.0.2.0 VALID
Oracle Database Java Packages CATJAVA 12.1.0.2.0 VALID
OLAP Analytic Workspace APS 12.1.0.2.0 VALID
Oracle OLAP API XOQ 12.1.0.2.0 VALID
Oracle Real Application Clusters RAC 12.1.0.2.0 OPTION OFF

As a prerequisite of upgrade, I had to rectify this before attempting upgrade.

As a first step, I tried running UTLRP.sql, but still component was in INVALID state.

I even checked, status of all objects in the database with object_type like JAVA%.

SYS@TESTDB:TESTDB> select owner, status, count(*) from all_objects where object_type like '%JAVA%' group by owner, status;

OWNER STATUS COUNT(*)
-------------------------------------------------------------------------------------------------------------------------------- ------- ----------
SYS VALID 29238
MDSYS VALID 650
ORDSYS VALID 2589

So now only option, I had left is to reinstall JAVA package inside database.

PFB steps for the same:

  1. alter system set java_jit_enabled = FALSE;
  2. alter system set “_system_trig_enabled”=FALSE;
  3. alter system set job_queue_processes=0;
  4. create or replace java system;
  5. alter system set java_jit_enabled = true;
  6. alter system set “_system_trig_enabled”=TRUE;
  7. alter system set JOB_QUEUE_PROCESSES=1000;
  8. @?/rdbms/admin/utlrp.sql

After applying above steps, JServer JAVA Virtual Machine became VALID. 🙂

COMP_NAME COMP_ID VERSION STATUS
----------------------------------- ------------------------------ ------------------------------ -----------
Oracle Application Express APEX 4.2.5.00.08 VALID
OWB OWB 11.2.0.3.0 VALID
OLAP Catalog AMD 11.2.0.4.0 OPTION OFF
Spatial SDO 12.1.0.2.0 VALID
Oracle Multimedia ORDIM 12.1.0.2.0 VALID
Oracle XML Database XDB 12.1.0.2.0 VALID
Oracle Text CONTEXT 12.1.0.2.0 VALID
Oracle Workspace Manager OWM 12.1.0.2.0 VALID
Oracle Database Catalog Views CATALOG 12.1.0.2.0 VALID
Oracle Database Packages and Types CATPROC 12.1.0.2.0 VALID
JServer JAVA Virtual Machine JAVAVM 12.1.0.2.0 VALID ====> Fixed
Oracle XDK XML 12.1.0.2.0 VALID
Oracle Database Java Packages CATJAVA 12.1.0.2.0 VALID
OLAP Analytic Workspace APS 12.1.0.2.0 VALID
Oracle OLAP API XOQ 12.1.0.2.0 VALID
Oracle Real Application Clusters RAC 12.1.0.2.0 OPTION OFF

Hope u will find this post very useful 🙂

Cheers

Regards,
Adityanath

Advertisements

30 responses to “INVALID JServer JAVA Virtual Machine in Oracle RDBMS Database 12.1.0.2.”

  1. Sha Hippen Avatar
    Sha Hippen

    I got what you mean ,saved to fav, very decent web site.

    Reply
    1. Adityanath Dewoolkar Avatar
      Adityanath Dewoolkar

      Hello There,

      Thanks for visiting and appreciate your feedback.:-)

      Regards,
      Adi

      Reply
  2. saurabh Avatar
    saurabh

    its realy helpful . i have applied this procedure multiple times on test and prod as well. rellay nice thanks brother

    Reply
    1. Adityanath Dewoolkar Avatar
      Adityanath Dewoolkar

      Hello There,

      Thanks for visiting and appreciate your feedback.:-)

      Regards,
      Adi

      Reply
  3. google positie Avatar
    google positie

    I do not even know how I ended up here, but I thought this post was good.
    I do not know who you are but certainly you are going to
    a famous blogger if you are not already 😉 Cheers!

    Reply
  4. Avatar
    Anonymous

    Since the admin of this web site is working, no hesitation very
    shortly it will be well-known, due to its quality contents.

    Reply
  5. Avatar
    Anonymous

    Excellent, what a webpage it is! This blog presents useful data
    to us, keep it up.

    Reply
  6. Avatar
    Anonymous

    Major thankies for the article post.Really thank you! Much obliged.

    Reply
  7. Marisa Avatar
    Marisa

    I was able to find good info from your articles.

    Reply
  8. Karen Avatar
    Karen

    Hi there, I log on to your blog daily. Your humoristic style is awesome, keep doing what you’re doing!

    Reply
  9. ReyMFreije Avatar
    ReyMFreije

    Hey There. I came across your weblog the use of msn. That may be an incredibly smartly written article. I will make certain to bookmark it and revisit to read more of your respective useful info. Thanks for the post. I’ll definitely comeback.

    Reply
  10. g Avatar
    g

    I am in fact happy to read this webpage posts which contains plenty of helpful data,
    thanks for providing these kinds of information.

    Reply
  11. Ira Koontz Avatar
    Ira Koontz

    so much wonderful info on here, : D.

    Reply
  12. Free Samples Avatar
    Free Samples

    My brother suggested I might like this blog. He was entirely right. This post truly made my day. You cann’t imagine just how much time I had spent for this information! Thanks!

    Reply
  13. Avatar
    Anonymous

    It really a nice and useful piece of information. I am glad that you simply shared this useful information with us. Please stay us up to date like this. Thank you for sharing.

    Reply
  14. Latarsha Steinke Avatar
    Latarsha Steinke

    I could not resist commenting. Very well written!

    Reply
  15. Denisha Sgambati Avatar
    Denisha Sgambati

    I am glad to be a visitor of this perfect site! , appreciate it for this rare information! .

    Reply
  16. Jewel Avatar
    Jewel

    Awesome article.

    Reply
  17. Crave Freebies Avatar
    Crave Freebies

    I抳e read a few good stuff here. Definitely worth bookmarking for revisiting. I wonder how much effort you put to create such a wonderful informative website.

    Reply
  18. Juan Mohorovich Avatar
    Juan Mohorovich

    very nice put up, i actually love this website, carry on it

    Reply
  19. Lauretta Spindle Avatar
    Lauretta Spindle

    Hmm it seems like your blog ate my first comment (it was super long) so I guess I’ll just sum it up what I had written and say, I’m thoroughly enjoying your blog. I as well am an aspiring blog writer but I’m still new to the whole thing. Do you have any recommendations for inexperienced blog writers? I’d genuinely appreciate it.

    Reply
  20. Joshua Silvertooth Avatar
    Joshua Silvertooth

    Hello! I could have sworn I’ve been to this web site before but after browsing through many of the posts I realized it’s new to me. Nonetheless, I’m definitely pleased I stumbled upon it and I’ll be book-marking it and checking back regularly!

    Reply
  21. Steffen Avatar
    Steffen

    Simply wish to say your article is as surprising.

    The clarity to your publish is simply nice and i could assume you
    are an expert in this subject. Fine along with your
    permission let me to seize your RSS feed to stay up to date
    with approaching post. Thanks one million and please keep up
    the rewarding work.

    Reply
  22. Ike Kenndy Avatar
    Ike Kenndy

    We stumbled over here different web address and thought I might check things out. I like what I see so i am just following you. Look forward to looking at your web page again.

    Reply
  23. Santos Wakenight Avatar
    Santos Wakenight

    Wonderful blog! I found it while surfing around on Yahoo News. Do you have any suggestions on how to get listed in Yahoo News? I’ve been trying for a while but I never seem to get there! Thank you

    Reply
  24. Avatar
    Anonymous

    You ought to indulge in a contest for one of the finest blogs on the internet. I am going to suggest this great site!

    Reply
  25. become a payment processor Avatar
    become a payment processor

    very good submit, i certainly love this web site, keep on it

    Reply
  26. Avatar
    Anonymous

    Hi there, I found your site via Google while looking for a related topic, your site came up, it looks good. I have bookmarked it in my google bookmarks.

    Reply
  27. hula dancing Avatar
    hula dancing

    very good post, i actually love this website, carry on it

    Reply
  28. Avatar
    Anonymous

    Hi there I am so delighted I found your weblog, I really found you by accident, while I was looking on Digg for something else, Anyways I am here now and would just like to say kudos for a marvelous post and a all round entertaining blog (I also love the theme/design), I don’t have time to read through it all at the minute but I have bookmarked it and also included your RSS feeds, so when I have time I will be back to read more, Please do keep up the awesome work.

    Reply

Leave a reply to Joshua Silvertooth Cancel reply

Advertisements
Blog Stats

560,801 hits

Advertisements
Advertisements