Oracle 12.2.0.1

Behavior Change: READ privilege for user SYSTEM in Oracle 12.2

Posted on December 1, 2017 by Mike.Dietrich Behavior Change 2

All credits here go to Marcel Pils from Logicalis, a German Oracle partner. Thanks Marcel! In Oracle 12.2 there’s an interesting behavior change: READ privilege for user SYSTEM in Oracle 12.2.

Some Background Information

In Oracle 12.1 the READ privilege has been introduced. Please find more information in the Oracle 12.1 Security Guide: New READ Object Privilege and READ ANY TABLE System Privilege for SELECT Operations. The idea behind the READ object and the READ ANY TABLE system privileges is that you can enable users query database tables, views, materialized views, and synonyms. But they can’t lock rows …

Should we wait for Oracle 19?

Posted on November 20, 2017 by Mike.Dietrich Release Schedule 6

Should we wait for Oracle 19? What a wonderful question:
“We are on Oracle 11.2.0.4 right now. Should we wait for Oracle 19 because of the proposed long term support for this release?”

I have gotten this question roughly 15 times in the past week, raised either by colleagues, customers or partners via email, twitter, in web conferences or (old fashioned way) on the phone. People refer to the graph printed in MOS Note: 742060.1. And I won’t replicate it here as this graph can change anytime. And it got adjusted just a few weeks ago as the support timeline for Oracle 12.2.0.1 …

Oracle Database RU and RUR Recommendations and Facts

Posted on November 7, 2017 by Mike.Dietrich Patch Recommendation 10

Well … another post about RU and RUR patches. But after having multiple discussions personally, via web conferences, in conference calls and of course on Twitter I think some clarifications may be helpful. Below you’ll find Oracle Database RU and RUR recommendations and facts. At least some of them …

Oracle Database RU and RUR Recommendations and Facts

First of all, you will find more information in several blog posts about RU (Release Update) and RUR (Release Update Revision) patches:

Oracle GoldenGate 12.3 is supported for Oracle Database 12.2.0.1

Posted on August 23, 2017 by Mike.Dietrich GoldenGate 12

Finally … it took a little while but now Oracle GoldenGate 12.3 is supported for Oracle Database 12.2.0.1.

Never heard of Oracle GoldeGate? Then you may look either into our slide deck and see the customer case of Amadeus. Or you may read further on OTN: http://www.oracle.com/technetwork/middleware/goldengate/overview/index.html

Oracle GoldenGate 12.3 is supported for Oracle Database 12.2.0.1

Roy and I received this question quite often in the past months:
When will Oracle GoldenGate be certified for use with Oracle Database 12.2.0.1?

I just learned about it today via the blog post of my friend YV RaviKumar who wrote about it…

My thoughts about the new Oracle Database Release Schedule

Posted on August 10, 2017 by Mike.Dietrich Release Schedule 26

Changes to a well-known release model mean a lot. I will give you some of my thoughts about the new Oracle Database release schedule.

My thoughts about the new Oracle Database Release Schedule

What are we changing?

In my own words we basically rename the patch sets and name them what they were since years: Full releases. This means, Oracle Database 12.2.0.2 will be Oracle 18. And Oracle 12.2.0.3 will be Oracle 19. And so on.

Therefore there won’t be any Oracle 12.2.0.2 anymore – and obviously no Oracle 13.1 followed by Oracle 13.2.

In addition we change from Proactive Bundle Patches (BP) to Release Updates (RU)…

DBMS_OPTIM_BUNDLE – only available in Oracle 12.1.0.2 – or not?

Posted on July 25, 2017 by Mike.Dietrich Optimizer Patch Recommendation 2

DBMS_OPTIM_BUNDLE - only available in Oracle 12.1.0.2 The 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.

Addition March 6, 2018:
See the updated blog post about DBMS_OPTIM_BUNDLE available in Oracle 12.2 and 18c onwards.
https://mikedietrichde.com/2018/03/08/dbms_optim_bundle-package-oracle-12-2-18c/

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 …

Why EXCLUDE_SEED_CDB_VIEW is now an underscore in Oracle 12.2

Posted on July 21, 2017 by Mike.Dietrich Parameters Single-/Multitenant 3

Hiding information is not good - and exclude_seed_cdb_view is now an underscore in Oracle 12.2 I have received several questions from customers in the past weeks using Oracle Multitenant about the parameter exclude_seed_cdb_view.It magically disappeared and morphed into _exclude_seed_cdb_view since Oracle Database 12.2.0.1. To be fair, the exclude_seed_cdb_view is listed in the list of obsolete parameters in Oracle Database 12.2.0.1.

What is EXCLUDE_SEED_CDB_VIEW?

This parameter hides everything belonging to the PDB$SEED from the usual queries. For instance you ran a query against CDB_DATA_FILES but you won’t see the data files belonging to PDB$SEED in the result set. Whether this is good or bad, at least RMAN (Recovery Manager) worked always correctly.

But I’m …

Applying the first RU for Oracle Database 12.2.0.1

Posted on July 20, 2017 by Mike.Dietrich Patch Recommendation 4

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

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. To my absolute surprise it was very small compared to previous Proactive Bundle Patches such as the April 2017 one. It has just 40 MB in size (no typo!).

Applying the first RU for Oracle Database 12.2.0.1

Download the first RU (Release Update) July 2017 for Oracle

Issue with 2k and 4k db_block_size – ORA-1450 when upgrading to Oracle 12.2.0.1

Posted on May 22, 2017 by Mike.Dietrich Oracle Database 12.2.0.1 Patch Recommendation Upgrade / Migration 6

Recently we got alerted by a customer and a colleague from Italy about an issue with the upgrade from Oracle 12.1.0.x to Oracle 12.2.0.1 if – and only if – your database got created with 2k or 4k db block size.

Problem

If your database got created with 2k or 4k db block size, and you attempt an upgrade from any upgrade-supported Oracle version to Oracle Database 12.2.0.1 the upgrade – regardless of DBUA or catctl.pl – will fail with an ORA-1450: maximum key length (1478) exceeded.

Analysis

In the catupgrd0.log – regardless of using the DBUA or …

Oracle 12.2.0.1 Bundle Patch 12.2.0.1.170516 DBBP on Linux x86-64 is available [not anymore]

Posted on May 19, 2017 by Mike.Dietrich Oracle Database 12.2.0.1 Patch Recommendation 19

All credits go to Ricardo Maeda as I knew that we’ll release a Bundle Patch for Oracle 12.2.0.1 sometime this week – but I couldn’t find it linked from the usual MOS notes. And please don’t ask my why that is.

Anyhow, with patch 2579308 you’ll get access to the first BP for Oracle Database 12.2.0.1. There will be a first bigger Proactive Bundle Patch in July at the usual schedule – but this one is at least a start.

Plus in addition get the OPatch version 12.2.0.1.7 via patch 6880880.

The BP contains:

First 12.2.0.1 Bundle Patch

What happens to PASSWORD_VERSIONS during an upgrade to Oracle 12.2?

Posted on April 25, 2017 by Mike.Dietrich Oracle Database 12.2.0.1 Security 25

I did blog a day ago about ORA-1017 connection issues in Oracle Database 12.2 once you would like to use the deprecated init.ora/spfile parameter SEC_CASE_SENSITIVE_LOGON=FALSE:

Having some fun with SEC_CASE_SENSITIVE_LOGON and ORA-1017

But how can this change actually happen?

Let’s check how the PASSWORD_VERSIONS is set in a fresh Oracle Database 12.1.0.2 database with the January 2017 Proactive Bundle Patch applied to it:

SQL> select username, password_versions from dba_users order by 1;

USERNAME		       PASSWORD_VERSIONS
------------------------------ -----------------
ANONYMOUS
APPQOSSYS		       10G 11G 12C
AUDSYS			       10G 11G 12C
DBSNMP			       10G 11G 12C
DIP			       10G 11G 12C
GSMADMIN_INTERNAL	       10G 11G 12C
GSMCATUSER		       10G

Security change in Oracle Database 12.2 with login.sql

Posted on April 17, 2017 by Mike.Dietrich Behavior Change Oracle Database 12.2.0.1 Security 12

Sometimes there are tiny little changes in a new release – and sometimes they are not documented very well yet. One of these changes is the new behavior of login.sql for SQL*Plus in Oracle Database 12.2.0.1.

Behavior before Oracle Database 12.2

In all releases until Oracle Database 12.1.0.2 by default SQL*Plus searches for the user profile (login.sql) in your current directory first, and then in the directories you specify with the ORACLE_PATH environment variable.

Please be aware that this change can be introduced with a PSU or a BP from 2017 as well.

Behavior since Oracle Database 12.2

Since Oracle …

Hands-On Lab available: Upgrade to Oracle Database 12.2.0.1

Posted on March 29, 2017 by Mike.Dietrich Hands-On Lab Oracle Database 12.2.0.1 17

Thanks to Roy – our Hands-On Lab “Upgrade, Migrate and Consolidate to Oracle Database 12.2” is now available for download from OTN.

Instructions and technical requirements are clearly documented on the OTN page as well. The lab is based on Virtual Box and can be easily imported upon download and unzip.

You can always access the lab via the blog’s top menu as well:

Hands-On Lab – Access via the Blog

Inside the lab you’ll find :

UPGR – an Oracle 11.2.0.4

Oracle 12.2.0.1

Behavior Change: READ privilege for user SYSTEM in Oracle 12.2

Some Background Information

Should we wait for Oracle 19?

Oracle Database RU and RUR Recommendations and Facts

Oracle Database RU and RUR Recommendations and Facts

Oracle GoldenGate 12.3 is supported for Oracle Database 12.2.0.1

Oracle GoldenGate 12.3 is supported for Oracle Database 12.2.0.1

My thoughts about the new Oracle Database Release Schedule

What are we changing?

DBMS_OPTIM_BUNDLE – only available in Oracle 12.1.0.2 – or not?

Purpose of DBMS_OPTIM_BUNDLE package in Oracle 12.1.0.2

Why EXCLUDE_SEED_CDB_VIEW is now an underscore in Oracle 12.2

What is EXCLUDE_SEED_CDB_VIEW?

Applying the first RU for Oracle Database 12.2.0.1

Download the RU 12.2.0.1.170718 for Linux

Issue with 2k and 4k db_block_size – ORA-1450 when upgrading to Oracle 12.2.0.1

Problem

Analysis

Oracle 12.2.0.1 Bundle Patch 12.2.0.1.170516 DBBP on Linux x86-64 is available [not anymore]

What happens to PASSWORD_VERSIONS during an upgrade to Oracle 12.2?

But how can this change actually happen?

Hands-On Lab available: Upgrade to Oracle Database 12.2.0.1

Archives

Categories

Upgrade @YouTube

RSS Feed for Upgrade your Database – NOW!

Subscribe via Email

Follow me on Twitter

Recent Posts