18c

Oracle Database 18.3.0 Upgrade on premises

Oracle Database 18.3.0 Upgrade on premisesAs Oracle Database 18c is now available on Linux on premises, I blogged about the installation already. And the next logical step is the Oracle Database 18.3.0 Upgrade on premises. In this case I will show an upgrade on the command line from Oracle 11.2.0.4 to Oracle 18.3.0. A DBUA upgrade will follow in a separate blog post later.

Oracle Database 18.3.0 Upgrade on premises

Before you can start with the upgrade, you may download the software first, and then install it:

If …

Continue reading...

Oracle Database 18.3.0 installation on premises

Oracle Database 18.3.0 installation on premisesOracle Database 18.3.0 is available on Linux since July 23, 2018. And I wanted to quickly sneak into the Oracle Database 18.3.0 installation on premises. I did blog about the Oracle 18c installation a few weeks ago but this was a plain 18.1.0. This time I install the 18.3.0 on-prem edition for Linux.

Oracle Database 18.3.0 installation on premises

Are the any differences between an 18.1.0 and the 18.3.0 installation? No, there aren’t any (at least not anything I recognized). The most important thing: you must unzip the downloaded file into your future destination directory.

In my case I …

Continue reading...

ZDLRA ready for Oracle Database 18c

ZDLRA is one of the best acronyms ever. It took me 5+ years to not mix up the sequence of characters 🙂 And even Larry made a joke about the name a while ago at his OOW keynote (I think it was 2016). ZDLRA stands for Zero Data Loss Recovery Appliance. And that basically tells you what it is. Hence, it isn’t a bad acronym as it tells you straight forward what it does. Good news: ZDLRA ready for Oracle Database 18c.

ZDLRA ready for Oracle Database 18c

ZDLRA ready for Oracle Database 18cWhy am I writing about this? Some of the customers …

Continue reading...

Video: The New Database Release and Patching Model

Video: The New Database Release and Patching ModelThe last Office Hours I’ve run about the New Release and Patching Model didn’t go very well technically. I’ve had screen/display issues. And Steven Feuerstein tried to save the best parts – but despite Steven’s awesome work neither him nor I did really like the result. So I decided that it may be better to record a Video: The New Database Release and Patching Model again (which I actually planned for quite a while already anyway.

Video: The New Database Release and Patching Model

The video is based on the slide deck you’ll find in the Slides download section of

Continue reading...

Oracle Fail Safe 4.2.1 is available for Oracle 12.2

Oracle Fail Safe 4.2.1 is available for Oracle 12.2It took a while – we know. But finally Oracle Fail Safe 4.2.1 is available for Oracle 12.2. You may not see the MOS notes being updated with certification information. Still you can download the software from oracle.com.

This version is certified with Oracle 12.2.0.1. You should be able to use it with Oracle 18c as well but we’ll add another certification notice soon.

What is Oracle Fail Safe?

Oracle Fail Safe is a core feature included with every Oracle Database license for Windows Server. It is a high availability software, integrated with Microsoft Failover Cluster, that provides a fast, …

Continue reading...

_optimizer_ignore_hints is now optimizer_ignore_hints

I’m refreshing our Hands-On Lab for Oracle Database 18c. And as part of a performance evaluation I wanted to set an underscore parameter to ignore all hints my load test tool sets. But then I learned: This does not work anymore as _optimizer_ignore_hints is now optimizer_ignore_hints. We made the underscore obsolete in Oracle Database 18c.

_optimizer_ignore_hints is now optimizer_ignore_hints

_optimizer_ignore_hints is now optimizer_ignore_hints

Actually in Oracle Database 12.2.0.1 you can find a long list of obsolete parameters here:

To be precise: We obsoleted159 parameters. In addition, in Oracle Database 18c we added an additional …

Continue reading...

Patching Oracle Database 18.1.0 to 18.2.0 on premises

In this part of my blog post series about upgrading from Oracle 12.2.0.1 to Oracle 18c I’d like to demonstrate patching Oracle Database 18.1.0 to 18.2.0 on premises.Patching Oracle Database 18.1.0 to 18.2.0 on premises

A while ago I showed also how to patch from Oracle 18.1.0 to 18.2.0 in the Oracle Cloud.

Find the related blog posts here:

Patching Oracle Database 18.1.0 to 18.2.0 on premises

Before I can start patching to the Release Update Oracle 18.2.0 I need to download the patch …

Continue reading...

Installing Oracle Database 18c

Installing Oracle Database 18cThis blog post about Installing Oracle Database 18c applies to all Oracle 18c releases. I wrote a while ago about one very important change:

and explained that the installation is now image based. You’ll find other posts as part of my series on how to install and upgrade to Oracle Database 18c here:

Installing Oracle Database 18c

Oracle Database 18c on-premises is supposed to be generally available with the July 2018 …

Continue reading...

When you patch, please use UPDATES – and not REVISIONS

I can just repeat what I’m saying not for almost a year: When you patch, please use UPDATES – and not REVISIONS. Updates (or Release Updates – short: RU) and Revisions (or Release Update Revisions – short: RUR) are patch bundles for the Oracle Database since Oracle 12.2.0.1. There are no PSUs (Patch Set Updates) anymore. And Revisions are not the same as PSUs.

When you patch, please use UPDATES – and not REVISIONS

One of the reasons why we recommend Updates, and not Revisions, simply is: Updates keep you more current whereas Revisions will let you miss a lot …

Continue reading...

Patching to Oracle 18.2.0 in the Oracle Cloud (OCI Classic)

Patching to Oracle 18.2.0 in the Oracle Cloud (OCI Classic)I was quite surprised when I spotted the Update (RU) Oracle 18.2.0 mid of April in my OCI Classic (DBCS, DBaaS) account. Of course I was thrilled immediately and started the patching to Oracle 18.2.0 in the Oracle Cloud (OCI Classic).

Patching to Oracle 18.2.0 in the Oracle Cloud (OCI Classic)

The April 2018 Updates (and Bundle Patches and Patch Set Updates for Oracle releases below 12.2) got released on April 17, 2018. You can read more here on how I applied all of them to my Oracle 11.2.0.4, 12.1.0.2 and 12.2.0.1 databases. But I was positively surprised when …

Continue reading...

Purging of PDB_PLUG_IN_VIOLATIONS in Oracle 18c

Purging of PDB_PLUG_IN_VIOLATIONS in Oracle 18cPDB_PLUG_IN_VIOLATIONS is a strange view in the Oracle database universe. It does not follow Oracle naming conventions – and it has too many underscores in its name. Furthermore I get always annoyed by the fact that it doesn’t get purged automatically. In addition it accumulates a massive number of useless information over time. But in Oracle Database 18c there’s a least some relief: A new call gets introduced which allows purging of PDB_PLUG_IN_VIOLATIONS in Oracle 18c.

PDB_PLUG_IN_VIOLATIONS

Purging of PDB_PLUG_IN_VIOLATIONS in Oracle 18c

As others have written a lot already about PDB_PLUG_IN_VIOLATIONS I won’t repeat it but rather share the links with you:

Continue reading...

Unplug a 12.2.0.1 PDB and plugin into 18c in the Cloud

Unplug a 12.2.0.1 PDB and plugin into 18c in the CloudThere’s been silence for a while – but today I’d like to show you how to unplug a 12.2.0.1 PDB and plugin into 18c in the Cloud. I’m doing this exercise because I’ve seen questions already. And I was curious if it works as I’d expect it.

Unplug a 12.2.0.1 PDB and plugin into 18c in the Cloud

As usual I will use our hands-on lab environment – and a freshly deployed 18c OCI-Classic instance (formerly known as DBCS formerly known as DBaaS).

Unplug a 12.2.0.1 PDB and plugin into 18c inthe Cloud

It is a Single Tenant environment with one PDB. If you need for information about how to …

Continue reading...

When will Oracle Database 18c be available on-prem?

When will Oracle Database 18c be available on-prem?When will Oracle Database 18c be available on-prem? Some of you will answer: It is available already, isn’t it? And you are right. But I don’t want to blog just a marketing message but some facts. Others may ask: When will it be generally available on-premises?

==> July 23, 2018: Linux 18.3.0 on-prem is available – please click here <==

When will Oracle Database 18c be available on-prem?

As of today, March 20, 2018, Oracle Database 18c is available already in/for:

Actually …

Continue reading...

Oracle Database 18c: A new preupgrade.jar is available

In case you plan to upgrade a database to Oracle Database 18c: A new preupgrade.jar is available for download from MyOracle Support (MOS).

Oracle Database 18c: A new preupgrade.jar is available

Oracle Database 18c: A new preupgrade.jar is available

Please download it – as always – from MOS Note:884522.1.

The same MOS note will get you also the most recent versions of the preupgrade.jar for Oracle Database 12.2.0.1 upgrades. Of course you can download also all previous incarnations such as preupgrd.sql for 12.1.0.2 upgrades and even utlu112i.sql for 11g upgrades.

What’s new in preupgrade.jar for Oracle 18c upgrades?

There are a few important and good Improvements and …

Continue reading...

DBMS_OPTIM_BUNDLE Package in Oracle 12.2 and 18c

Yes, I did blog about the DBMS_OPTIM_BUNDLE package in earlier Oracle releases before. And I thought (and it was documented this way) that it will disappear in Oracle 12.2 and newer. But in fact you’ll find the DBMS_OPTIM_BUNDLE package in Oracle 12.2 and 18c. Most likely …

This is a very interesting case and you may see also my previous blog posts:

DBMS_OPTIM_BUNDLE Package in Oracle 12.2 and 18c

First of …

Continue reading...

Oracle Database 18c – Some important changes

I know that Oracle Database 18c is available in the Oracle Cloud and on Exadata engineered systems only right now. But actually I’ve had conversations with some customers who downloaded Oracle 18c on-prem software for Exadata and installed it on their systems. Therefore it may be useful to talk about Oracle Database 18c – Some important changes.

Oracle Database 18c – Some important changes

I will highlight some important changes but of course won’t cover all of them here.

Installation

You may recognize the first change after downloading the image: The installation and configuration of Oracle Database software is simplified …

Continue reading...

Don’t drop the AUDSYS user before upgrading

Don't drop the AUDSYS user before upgradingThis is a very interesting case Martin Berger sent to me a week ago. A colleague and him were basically wondering if they should follow the advice in the Oracle 12.2 upgrade guide and drop the AUDSYS user, or if they better don’t drop the AUDSYS user before upgrading.

What is AUDSYS meant for?

In short, it is the auditing user schema for Oracle 12c and especially Unified Auditing. You’ll find a bit more information regarding Unified Auditing on this blog:

Continue reading...

When does patching end for Oracle Database 12.2.0.1?

This question is coming up on a regular basis for obvious reasons whenever we speak to customers about Oracle Database 12.2 and 18c: When does patching end for Oracle Database 12.2.0.1?

When does patching end for Oracle Database 12.2.0.1?

Actually Roy and I are explaining this topic in our The New Release and Patching Model presentation:

When does patching end for Oracle Database 12.2.0.1?

Annual releases, such as Oracle 12.2.0.1, Oracle 18c, Oracle 19c and so on, get a minimum of 2 years patching after the succeeding release is available. This means, as soon as Oracle 18c is available, the previous release – Oracle Database 12.2.0.1 – …

Continue reading...

Oracle Database 18c released for Oracle Cloud and Engineered Systems

Oracle Database 18c has been released Friday, February 16, 2018 in the Oracle Cloud and for Engineered Systems.

Oracle Database 18c released for Oracle Cloud and Engineered Systems

What is new in Oracle Database 18c?

Please read this comprehensive description by Dominic Giles, Master Product Manager for Oracle Database on https://blogs.oracle.com/database/oracle-database-18c-:-now-available-on-the-oracle-cloud-and-oracle-engineered-systems. Dominic summarizes the most important features in the areas of Multitenant, In-Memory, Sharding, Performance, High Availability, Security, Spatial/Graph and of course Developer features.

You’d like to read more about New Features?

In case you’d been now interested please see the New Features Guide for more details in Oracle Database 18c.

Well, and there’s not only a New Features …

Continue reading...

MOS Note:742060.1 got updated with Oracle 18c information

From the Support’s Hot Topics email I learned the other day that MOS Note:742060.1 (Release Schedule of Current Database Releases) got updated with Oracle 18c information on January 18, 2018.

What got added to MOS Note:742060.1?

A column for Oracle 18c got added to the table of releases. You will find not information about potential release availability for Oracle 18c in the various options of the Oracle Cloud, and of course for on-premises as well.

MOS Note:742060.1 got updated with Oracle 18c information

Furthermore please find the updated graph as well.

MOS Note:742060.1 got updated with Oracle 18c information

 

 

The note below the graph is very important. See MOS Note:742060.1 for further details.

–Mike…

Continue reading...