Applying the first RU for Oracle Database 12.2.0.1

Appying the first RU for Oracle Database 12.2.0.1The 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/

Download the RU 12.2.0.1.170718 for Linux

First of all I downloaded the Database RU 12.2.0.1.170718 Patch 26123830 for Linux from MyOracle Support.[Read More]

More Information about RU and RUR patches for Oracle 12.2

More Information about RU and RUR patches for Oracle 12.2The 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.

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:

What does MOS Note: 2285040.1 cover?

[Read More]

The first RU for Oracle Database 12.2.0.1 is available

First RU is available for Oracle Database 12.2.0.1The 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.

Details of the July 2017 Critical Patch Advisory

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]

Can you simply switch from SE2 to EE with Oracle Multitenant

Oracle MultitenantThis 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]

Use your own templates in DBCA to create databases

Use your own templates in DBCA to create databasesAnother 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]

Always create databases as CUSTOM databases

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.

Always create CUSTOMER databasesIn the DBCA better use your own and wisely configured template rather than the prebuilt (we used to call them: seed) databases.… [Read More]

Why does the upgrade of PDB$SEED always take longer?

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?

Upgrading the PDB$SEED takes always longerI have written several blog posts in the past about the different techniques to upgrade an Oracle Multitenant environment:

  1. Upgrade Everything At Once
  2. Upgrade via Unplug/Plug/Upgrade

The interesting case happens in the “Everything At Once“.… [Read More]