Oracle 12.2 Adaptive Features are enabled in Oracle 12.1.0.2 Windows BPs

Oracle 12.2 Adaptive Features are enabled in Oracle 12.1.0.2 Windows BPsOracle 12.2 adaptive features are enabled in Oracle 12.1.0.2 Windows BPs already, This is quite a surprise to me. But thanks to Michael Pfautz. He alerted me today.as he was wondering why his database didn’t start up anymore after he applied the August 31 Bundle Patch on Windows. It complained about the parameter optimizer_adaptive_features in the SPFILE.… [Read More]

How to patch the Oracle Instant Client?

How to patch the Oracle Instant Client?That’s an interesting question a customer raised the other day:

How to patch the Oracle Instant Client?

I silently assumed that there’s a new release of the Oracle Instant Client every quarter or at least when we deliver fixes which apply to the client as well. Hm …

What is the Oracle Instant Client?

[Read More]

DBMS_OPTIM_BUNDLE – only available in Oracle 12.1.0.2

DBMS_OPTIM_BUNDLE - only available in Oracle 12.1.0.2The DBMS_OPTIM_BUNDLE package got introduced with the April 2014 Exadata 11.2.0.4 Bundle Patch. And it got introduced for all Oracle 12.1.0.2 databases with the April 2017 Bundle Patch (BP). DBMS_OPTIM_BUNDLE is only available in Oracle 12.1.0.2.

For more information on this package on Exadata in Oracle 11.2.0.4 you may look at:

Purpose of DBMS_OPTIM_BUNDLE package in Oracle 12.1.0.2

The package got introduced to enable module bug fixes which cause an execution plan change in a disabled state.… [Read More]

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]

Adpative Features Patches with Oracle Peoplesoft

Adaptive Feature Patches with Oracle Peoplesoft - Accenture Enkitec's ExperienceI’ve met David Kurtz, an Oracle ACE Director working for Accenture’s Enkitec division in the UK earlier this year on the OUGN Conference‘s boat trip from Oslo to Kiel and return. We set across the table at dinner. And of course we started discussing “Oracle”. David went to my talk about “How to ensure Performance Stability” before.… [Read More]