The first RU (Release Update) for Oracle 12.2 is available on most platforms since July 18, 2017. And of course I started applying the first RU for Oracle Database 126.96.36.199 as soon as it got released.
The first RU (Release Update) for Oracle Database 188.8.131.52 has been released. And Oracle Support provides some very helpful documents to explain the implication of the new RU (Release Update) and RUR (Release Update Revision) patches.
More Information about RU and RUR patches for Oracle 12.2
First of all, these are the most important MOS notes to have a look at:
- MOS Note:742060.1 – Release Schedule for Current Database Releases (no update yet)
- MOS Note: 2285040.1 – Release Update and Release Update Revisions for Database Proactive Patch Program
- MOS Note: 2275525.1 – FAQ for RU and RUR (not public yet)
What does MOS Note: 2285040.1 cover?… [Read More]
The first RU (Release Update) for Oracle 184.108.40.206 is available
Just in case the port you are looking for is not available right now please see the ETA dates in the link below.
Details of the July 2017 Critical Patch Advisory
Find the General Information about the July 2017 Critical Patch Advisory here:
Find the Risk Matrix for the July 2017 Critical Patch Advisory here:
The details about the Database are included in this document:
MOS Note: 2261562.1 – Patch Set Update and Critical Patch Update July 2017 Availability Document
Please find the “Missing patches” in section 2.2 with proposed ETA dates.… [Read More]
This question is coming up from time to time – and currently not covered in the official Oracle documentation as far as I know: “Can you simply switch from SE2 to EE with Oracle Multitenant?”
Yes, you can!
First of all, the switch is possible and tested. But you’ll have to satisfy a few requirements:
- Both database versions must be the same
- Both databases must have the same character set (in Oracle Database 12.1)
That’s it.… [Read More]
Another advice regarding database creation:
Use your own templates in DBCA to create databases.
This way you can configure not only the options and components to create but also redo log layout, your set of parameters and much more. And it is less error prone than a “create database” script.
Use your own template in DBCA
Creating your own template in DBCA (Database Configuration Assistant) is quite easy and straight forward.… [Read More]
I’m giving this advice to customers for many years:
When you create a fresh Oracle database ALWAYS create databases as CUSTOM databases. Via template or not doesn’t matter.
Upgrading the PDB$SEED takes always longer than any other container.
What is the reason for an upgrade of the PDB$SEED taking so much longer in a real world environment?
How does an upgrade with Oracle Multitenant work?
I have written several blog posts in the past about the different techniques to upgrade an Oracle Multitenant environment:
The interesting case happens in the “Everything At Once“.… [Read More]