Hurray, it’s patching day! I know, YOU did look forward to July 17, 2018 as it is patching day again. Last night we released the following Patches: July 2018 Update, Revision, BP and PSU.
July 2018 Update, Revision, BP and PSU
First of all, I’m doing the usual check for the alert and the risk matrix to see whether there’s are really important security patches included. For the risk matrix you’ll have to scrooooooooooolllll down quite a bit as the list of products is strictly alphabetically ordered:
- Critical Patch Update – July 2018 – Patch Advisory
- Risk Matrix for Oracle Database Server, versions 11.2.0.4, 12.1.0.2, 12.2.0.1, 18.1, 18.2
When you look at the risk matrix you’ll spot two high scored issues: One with Oracle Spatial at 9.8, the other for the core RDBMS at 8.4. Hence, you should consider this patch bundle, especially if you are using Oracle Spatial in Oracle 12.2 or 18c.
Therefore, my next task: I’m checking the patch availability for the database in order to download the correct patches:
Again, you will need to scroll down a bit to section 3.1.4 Oracle Database.
Which Patch Bundles should you take?
As I (and others such as Ludovico Caldara in his excellent blog post series about patching and Oracle Home management) explained already several times, you should take:
- For Oracle 18c: Update (RU)
- For Oracle 12.2: Update (RU)
- For Oracle 12.1: Bundle Patch (BP)
- For Oracle 11.2: Patch Set Update (PSU) for non-Engineered Systems or Bundle Patch (BP) for Engineered Systems
Downloading the July 2018 Patches
And as usual, I apply the patch bundles as soon as possible. Just as I did in previous quarters as well.
For my environments I’m downloading:
- For Oracle 18c: Database Update 18.3.0 Patch 28090523
Find the Readme here. Be aware: the internal document pointers to the paragraphs currently contain an Oracle internal web address. I did ask the responsible people to correct it. Should be done pretty soon I hope.
.
- For Oracle 12.1.0.2: Database Proactive Bundle Patch 12.1.0.2.180717 Patch 27968010
Find the Readme here.
.
- For Oracle 11.2.0.4: Database PSU 11.2.0.4.180717 Patch 27734982 for UNIX
Find the Readme here.
.
I don’t download the bundles including OJVM as none of my databases has an OJVM component installed.
As the download takes a bit, I’ll add another blog post about Applying the July 2018 Patch Bundles.
What If … the link does not work?
Peter Lehmann alerted me that the GI PSU Patch 28183653 has a dead link. And this is true. But there’s a reason for it. Please always have a look into Section 2.2 of Patch Availability for the Oracle Database (MOS Note: 2394520.1).There you’ll find the delayed patch bundles listed.
This list specifies the Expected Date in the rightmost column. I think I don’t need to highlight that this is an expected – and not a guaranteed date.
The absence of the 18.2.1 Revisions does not hurt as we recommend clearly to use the Updates, not the Revisions unless Oracle Support or the MAA/X- team advices you to apply.
–Mike
Hey Mike,
I just wanted to install RU on 18c DB+GI. When you download latest OPatch for 18c, it’s named 12.2.0.1.4. But when you run opatch version, you’ll get 12.2.0.1.13. But when you use latest OPatch for 12c, the version is ok (12.2.0.1.14)…
Can you prove this?
Kind regards,
Martin
Martin,
I downloaded OPatch 12.2.0.1.14 and installed it already this morning.
==>
cd $ORACLE_HOME
rm -rf OPatch
cp /media/sf_TEMP/p6880880_180000_Linux-x86-64.zip .
unzip p6880880_180000_Linux-x86-64.zip
cd OPatch
And then:
$ ./opatch version
OPatch Version: 12.2.0.1.14
OPatch succeeded.
Do you see the same?
Cheers,
Mike
Hey Mike,
just unzipped OPatch – it showed the wrong version…
Cheers,
Martin
Martin,
please log an SR. I sent already emails to the responsible folks.
I’m currently fighting issues with my 12.1.0.2 BP apply (more precise: with datapatch -verbose).
Thanks and sorry for the inconvenience 🙁
Mike
we are hitting the below error while apply JULY PSU. Any suggestions much appreciated.
CLSRSC-00235: Patch request before invoking Oracle patching tool was aborted because upgrade is in progress.
Cause: A patch request before invoking Oracle patching tool was aborted because software upgrade was in progress on one or more nodes.
Action: Ensure successful completion of upgrade processing on all nodes before requesting patch before invoking Oracle patching tool.
Opened SR as well. so far no progress.
./opatchauto apply /orabackup/1/PSUJUN2018LATEST/PSU/28183653 -oh /opt/oracle/product/12.2.0.1/grid
Anand,
no, I have no RAC system and thus don’t apply the GI PSUs.
But please send me the SR number and I’ll have a look (just copy it into your reply – I’ll grab it from there).
Cheers,
Mike
Hello Mike,
Do you know when Oracle 18c will be available for download on OTN (it is supposed to be available with the July 2018 release update) ?
Thanks
Pierre
Pierre,
please be patient for a few days.
I can’t give a date but it should be available soon.
Thanks,
Mike
Hi Mike,
FYI,
there is no GI Patch available (empty link to 28183653 GI JUL 2018 RELEASE UPDATE 12.2.0.1.180717) :
Only found this:
Patch 28317269: COMBO OF OJVM RU COMPONENT 12.2.0.1.180717 + 12.2.0.1.180717 GIJUL2018RU
, but it has the OJVM patch included (I’ve learned from you, to patch OJVM as seperate) or is that expected?
Cheers, Peter
Hi Peter,
please see Section 2.2: Post Release Patches
Patch 28183653 12.2.0.1.180717 GI Jul2018 RU All ETA: 27-Jul-2018
Sorry for the inconvenience – I will make this more clear and direct to this section as well.
Cheers,
Mike
Peter,
I updated the blog post with a bit more explanation – please scroll down to the end.
Cheers,
Mike
Hi Mike,
This is at best tangentially related, but are you aware of any plans to publish 12.2 or 18c versions of documents like 1645862.1 (11.2.0.4) and 2034610.1 (12.1.0.2)? We’ve always used those for some guidance for important one-offs, and now that we’re being asked to support 12.2 and prepare for 18, we would hope to see something similar…
Thanks!
stephan
Hi Stephan,
I will ask the responsible manager in Support. Would you mind to drop me a short email?
This way I can reply easier (firstname.lastname@oracle.com)
Cheers,
Mike