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:
- alter system set java_jit_enabled = FALSE;
- alter system set “_system_trig_enabled”=FALSE;
- alter system set job_queue_processes=0;
- create or replace java system;
- alter system set java_jit_enabled = true;
- alter system set “_system_trig_enabled”=TRUE;
- alter system set JOB_QUEUE_PROCESSES=1000;
- @?/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
Adityanath's Oracle Blog 
I got what you mean ,saved to fav, very decent web site.
Hello There,
Thanks for visiting and appreciate your feedback.:-)
Regards,
Adi
its realy helpful . i have applied this procedure multiple times on test and prod as well. rellay nice thanks brother
Hello There,
Thanks for visiting and appreciate your feedback.:-)
Regards,
Adi
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!
Since the admin of this web site is working, no hesitation very
shortly it will be well-known, due to its quality contents.
Excellent, what a webpage it is! This blog presents useful data
to us, keep it up.
Major thankies for the article post.Really thank you! Much obliged.
I was able to find good info from your articles.
Hi there, I log on to your blog daily. Your humoristic style is awesome, keep doing what you’re doing!
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.
I am in fact happy to read this webpage posts which contains plenty of helpful data,
thanks for providing these kinds of information.
so much wonderful info on here, : D.
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!
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.
I could not resist commenting. Very well written!
I am glad to be a visitor of this perfect site! , appreciate it for this rare information! .
Awesome article.
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.
very nice put up, i actually love this website, carry on it
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.
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!
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.
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.
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
You ought to indulge in a contest for one of the finest blogs on the internet. I am going to suggest this great site!
very good submit, i certainly love this web site, keep on it
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.
very good post, i actually love this website, carry on it
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.