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 12.2.0.1 as soon as it got released.
See: https://mikedietrichde.com/2017/07/19/first-ru-oracle-12-2-0-1-available/
First of all I downloaded the Database RU 12.2.0.1.170718 Patch 26123830 for Linux from MyOracle Support.… [Read More]
The first RU (Release Update) for Oracle Database 12.2.0.1 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.
First of all, these are the most important MOS notes to have a look at:
The first RU (Release Update) for Oracle 12.2.0.1 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.
Find the General Information about the July 2017 Critical Patch Advisory here:
http://www.oracle.com/technetwork/security-advisory/cpujul2017-3236622.html
Find the Risk Matrix for the July 2017 Critical Patch Advisory here:
http://www.oracle.com/technetwork/security-advisory/cpujul2017verbose-3236625.html#DB
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?”
First of all, the switch is possible and tested. But you’ll have to satisfy a few requirements:
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.
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.
In the DBCA better use your own and wisely configured template rather than the prebuilt (we used to call them: seed) databases.… [Read More]
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?
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]