Are OJVM patches included in the Oracle 12.2 RU / RUR?

I have received this question multiple times in the past days, especially when I presented at the Slovenian Oracle User Group Conference about the new Release and Patching Mode but also via emaill: Are OJVM patches included in the Oracle 12.2 RU / RUR? Let me clarify this in the below blog post. Are OJVM patches included in the Oracle 12.2 RU / RUR? At first I did check MOS Note: 1929745.1 – Oracle Recommended Patches — “Oracle JavaVM Component Database PSU and RU” (OJVM PSU and OJVM RU) Patches.But besides having RU mentioned in the Note’s title and one…

JAVAVM and XML Clean Up in Oracle Database 11.2-12.2

JAVAVM and XML clean up in Oracle Database 11.2-12.2 is a tough topic. Many have suffered from the rolling patch upgrade issues with the OJVM (Oracle Java Virtual Machine) even though most of the issues have been cured with the recent patches. Please see my previous blog posts starting here: The OJVM Saga – and how to solve it (Part 1) – Sep 5, 2016 OJVM and Standby-First Patching – Aug 8, 2016 OJVM Removal – Jun 22, 2015 And please see also this very important MOS Note: 2217053.1 – RAC Rolling Install Process for the “Oracle JavaVM Component Database…

The OJVM Patching Saga – and how to solve it – Part V

Related Posts on “The OJVM Patching Saga – and how to solve it“: Part I – The OJVM Basics Part II – Important Notes and Information Part III – The Mitigation Patch Part IV – What you may have missed Part V – MOS Note explaining “Conditional Rolling Install”  MOS Note released explaining patching without STARTUP UPGRADE mode An important note regarding OJVM rolling patching has been published on MyOracle Support: MOS Note: 2217053.1 RAC Rolling Install Process for the “Oracle JavaVM Component Database PSU” (OJVM PSU) Patches “Beginning with the Jan2017 OJVM PSU patchset for 11.2.0.4 and for 12.1.0.2,…

The OJVM Patching Saga – and how to solve it – Part IV

Related Posts on “The OJVM Patching Saga – and how to solve it“: Part I – The OJVM Basics Part II – Important Notes and Information Part III – The Mitigation Patch Part IV – What you may have missed Part V – MOS Note explaining “Conditional Rolling Install”  What is missing with the “Mitigation Patch? Michael, the team lead from a large Oracle customer mailed me the other day. He wanted to disable Java on all their +600 databases by using the Mitigation Patch for OJVM. But he received a strange error when trying to enable the mitigation patch…

The OJVM Patching Saga – and how to solve it – Part III

Related Posts on “The OJVM Patching Saga – and how to solve it“: Part I – The OJVM Basics Part II – Important Notes and Information Part III – The Mitigation Patch Part IV – What you may have missed Part V – MOS Note explaining “Conditional Rolling Install”  What is the “Mitigation Patch? In MOS Note:1929745.1 – Oracle JavaVM Component Database Patches there’s a section called What is the Mitigation Patch. It says: “For situations where the latest OJVM PSU cannot be installed immediately there is a “Mitigation Patch” that can be used. The “Mitigation Patch” is an interim…

The OJVM Patching Saga – and how to solve it – Part II

Related Posts on “The OJVM Patching Saga – and how to solve it“: Part I – The OJVM Basics Part II – Important Notes and Information Part III – The Mitigation Patch Part IV – What you may have missed Part V – MOS Note explaining “Conditional Rolling Install”  Important Notes MOS Note: 1929745.1 – Oracle JavaVM Component Database Patches MOS Note: 1940702.1 – Database JVM Vulnerabilities FAQ MOS Note: 2165212.1 – What to do if the Database JAVAVM Component becomes INVALID After installing an OJVM Patch? This Note contains a pretty detailed removal procedure for JAVAVM as well –…

The OJVM Patching Saga – and how to solve it – Part I

Related Posts on “The OJVM Patching Saga – and how to solve it“: Part I – The OJVM Basics Part II – Important Notes and Information Part III – The Mitigation Patch Part IV – What you may have missed Part V – MOS Note explaining “Conditional Rolling Install”  Who’s the Product Manager for Patching? First of all, I’m neither a patching expert nor am I the Product Manager for Patching. There’s no such role as far as I know but there are people inside Oracle who have way more clue about this topic. There’s a group inside Oracle’s development…

OJVM patch: Standby-First patching, yes or no?

I have blogged in the past more than once about the “wonderful” topic of OJVM patching. Anyhow,  I’d like to summarize a few typical questions sent to me in the past months regarding OJVM patching. Do I need to apply the OJVM patch every time I apply a PSU or BP? Unfortunately this is not a one-time-and-then-you-are-set operation. You’ll have to do it every time. How do I find out if OJVM is used in my database? I tried to nail this down in this blog post here: Java in the database – OJVM non-rolling patches – OJVM Removal But…

Oracle 12.2: OJVM will no longer support compilation of SQLJ source – and JPub does not get shipped anymore

In Oracle Database 12.2.0.1, OJVM will no longer support the compilation of SQLJ source or executing SQLJ classes. SQLJ on the client side will continue to be developed, shipped and supported.  Only the part inside the DB is affected. Existing SQLJ code that runs inside the DB will need to be re-coded to use generic JDBC. Furthermore JPub (client-side and inside-DB) will not get shipped anymore with Oracle Database 12.2. It got removed from the RDBMS code. There is no replacement. –Mike

Java in the database – OJVM non-rolling patches – OJVM Removal

Question: How can I find out if Oracle’s JVM is used in my database? Answer: This is unfortunately not as trivial as I thought initially … Let’s start with: MOS Note:397770.1 Until Oracle version 11.2 or later, there was no way to confirm if Oracle JVM is not actively used in the database.  However, what can be said is: 1) If there are non-Oracle schemas that contain java objects, then 3rd party products or user defined java programs could be actively using the Oracle JVM. 2) If there are Oracle schemas, other than SYS, that contain java objects, then other Oracle products or Oracle Applications could be actively using…

Oracle Database 12c pre-upgrade scripts and JAVAVM

This is a great example of why you should always review the README file when upgrading to a new release. Here is an issue that we found during customer beta testing, and that you will want to be aware of if you are upgrading to Oracle Database 12c and do not have the JAVAVM component in your database. The following text has been added to the 12.1 Readme under Section 1.1: TITLE: Pre-Upgrade Tool Does Not Generate Output Logs The pre-upgrade tool, preupgrd.sql, is not able to create a directory to store the output files if the JAVAVM component either does not…