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 and a new version of Opatch as well.… [ Read More ]

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 Update.… [ Read More ]

Deinstalling Oracle Database 12.2.0.1

Deinstalling Oracle Database 12.2.0.1This is part of a blog post serious where I install Oracle 18c on-premises in our Hands-On Lab and upgrade the Multitenant 12.2.0.1 database as well. But in order to safe space, deinstalling Oracle Database 12.2.0.1 is my next task. You find all the blog posts connected to each other here:

Deinstalling Oracle Database 12.2.0.1

In the Oracle Installation documentation you’ll find this part:

The documentation lists two removal options:

But in fact (see below) there’s actually no difference.… [ Read More ]

Upgrade Oracle 12.2.0.1 to Oracle Database 18c on-premises

Upgrade Oracle 12.2.0.1 to Oracle Database 18c on-premisesI’m currently refreshing our Hands-On Lab and will exchange Oracle 12.2.0.1 with Oracle 18.2.0. This blog post series is about how to Upgrade to Oracle 12.2.0.1 to Oracle Database 18c on-premises. There are other blog posts available you may use by yourself if you plan to refresh the lab by yourself until we uploaded a newer version.… [ Read More ]

Upgrade Hands-On Lab – Oracle Database 12.2.0.1 – May 2018

Roy just uploaded a newer version of our Upgrade Hands-On Lab – Oracle Database 12.2.0.1 – May 2018.

The previous version had – I believe – and early drop of Oracle 12.2.0.1 installed. And recently somebody complained that certain Multitenant operations such as Hot Cloning with Oracle Database 12.2.0.1 don’t work but result in errors.… [ Read More ]

Upgrade Office Hours: June 20, 2018 – 14:00 CET – The New Release Model

Well, time really flies. And I just realized this morning: It’s time to promote our next session for the Upgrade Office Hours: June 20, 2018 – 14:00 CET – The New Release Model. Yes, Wednesday next week. Time to let us know your questions upfront. BE AWARE: WE HAD TO CHANGE THE BEGIN TIME FROM 11:00 CET to 14:00 CET

Upgrade Office Hours: June 20, 2018 – 14:00 CET – The New Release Model

Roy, Bill and I have taken a decision to alter the begin dates for the upcoming Office hours.… [ Read More ]

ORAWORLD Mag: Oracle Database Patching – Tips & Tricks

Thanks to DOAG and the ORAWORLD Magazine, my article is released in the current September 2018 ORAWORLD Mag: Oracle Database Patching – Tips & Tricks

ORAWORLD Mag: Oracle Database Patching - Tips & Tricks

ORAWORLD Mag: Oracle Database Patching – Tips & Tricks

You’ll find my article about Database Patching – Tips & Tricks on page 28ff in the September 2018 issue if the ORAWORLD magazine.… [ Read More ]

Vienna Calling – Austrian Oracle User Group Conference 2018

Vienna Calling - Austrian Oracle User Group Conference 2018Next week the 30th AOUG Conference will happen. Vienna Calling – Austrian Oracle User Group Conference 2018. I’m looking forward to it.

Travel is all set – I’ll head out on Monday. And I hope to meet you there.

Vienna Calling – Austrian Oracle User Group Conference 2018

Vienna is one of my favorite cities in the world.… [ Read More ]

Drop a tablespace in a PDB with a Guaranteed Restore Point being active

Drop a tablespace in a PDB with a Guaranteed Restore Point being activeThis was an interesting question I received from Alain Fuhrer a couple of weeks ago: “Why can’t I drop a tablespace in a PDB whit a Guaranteed Restore Point being active?”. It’s important to note that the GRP is not active in the same but in another PDB.

An SR resolved the issue.… [ Read More ]

RMAN backup generates traces in Oracle 12.2.0.1

RMAN backup generates traces in Oracle 12.2.0.1Oracle 12.2.0.1 seems to be the “tracing” release without further patch or parameter treatments. After posting about MMON unconditional traces in Oracle 12.2.0.1 a day ago, I received a couple of comments either on the blog, via LinkedIn or Twitter regarding other trace facilities in Oracle Database 12.2.0.1.… [ Read More ]

MMON unconditional traces in Oracle 12.2.0.1

MMON unconditional traces in Oracle 12.2.0.1I love visiting customers onsite. Last week I visited die Mobiliar in Bern, Switzerland. I received a list of open issues to discuss – which is very good to prepare a visit. And when we all were sitting together there was this “Ah, one final thing”. They have an issue with traces the databases writes every few seconds.… [ Read More ]

Remove Underscore Parameters not only before you upgrade

Remove Underscore Parameters not only before you upgradeUnderscore parameters are a wonderful thing in Oracle. They are treated like a secret. But you can view them of course. Everybody can. Make a guess how many underscore parameters exist in Oracle 12.2.0.1.0. You’ll find the answer at the end of this blog post. But why should you remove underscore parameters not only before you upgrade?… [ Read More ]

Be aware of database options selections for PDBs in DBCA

I did blog about several things-to-know with DBCA (Database Configuration Assistant) in the past. And one issue came up in our internal mailing list the other day. Be aware of database options selections for PDBs in DBCA. Missing one or the other “click” may bring you in trouble later on. I blogged about this already a while ago but this was only part of a larger post: Create Multitenant Databases with DBCA – Things to Know.… [ Read More ]

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.… [ Read More ]

Transient Logical Standby – Rolling Upgrades – Overview

Transient Logical Standby - Rolling Upgrades - OverviewMore than 10 years ago I was invited to work several weeks in Redwood Shores at the Oracle HQ for Lawrence To‘s MAA team together with Ray Dutcher, one of the greatest persons I have ever met and worked with in my over 20 years at Oracle. We had to work out a doable process for smooth rolling upgrades utilizing a physical standby database.… [ Read More ]

Different block sizes when you plugin?

Interesting case Roy came across a week ago with a customer in the US. The customer received a plugin violation because of different DB_BLOCK_SIZE between the source and the destination database. This happened regardless of unplug/plug or plugging in a non-CDB into a CDB. Hence the question came up: Can you have different block sizes when you plugin?… [ Read More ]

New preupgrade.jar and changes in MOS Note:884522.1

We read and listen to your comments. And that’s why my team mate Byron has added a new preupgrade.jar and changes to MOS Note:884522.1. One reader commented that MOS Note:884522.1 (How to Download and Run Oracle’s Database Pre-Upgrade Utility) does not explain how to “run” the preupgrade tool even though it mentions this in the note’s title.… [ Read More ]

Korea and Japan visit – Recap, Thank You and Impressions!

A week ago, Roy and I returned from a 1+ week trip to Korea and Japan. It was wonderful but of course strenuous (as always). As today is a public holiday in many European countries including Germany I’d like to take the chance and write a non-technical short article about our Korea and Japan visit – Recap and Thank You!… [ Read More ]

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.… [ Read More ]

Why does your most important database run on Oracle 10.2.0.4?

Today is a sunny day. A wonderful beautiful spring day. Flowers are blooming. Trees are getting green. Birds are singing. All fine. And then I find this email in my inbox. A customer wants to migrate between two Big Endiann platforms with a important ERP system. Nothing special – until I read this: The ERP system is currently on Oracle 10.2.0.4 – and it should stay on Oracle 10.2.0.4.… [ Read More ]

Do you have to execute catbundle.sql when you create a new 11g database?

Do you have to execute catbundle.sql when you create a new 11g database?Roberto Valsania asked this question once he read my blog post about whether you have to execute datapatch after creating a new 12c database: Do you have to execute catbundle.sql when you create a new 11g database?

I’d bet you all are aware that Oracle Database 11.2.0.4 will go out of Waived Extended Support by end of 2018.… [ Read More ]

List of PREUPGRADE checks executed by preupgrade.jar

List of PREUPGRADE checks executed by preupgrade.jar

Most of you may not care about the checks our Pre Upgrade Check tool preupgrade.jar does. But some may. Especially in cases where you plan to run a command line upgrade unattended via a script. Therefore this List of PREUPGRADE checks executed by preupgrade.jar may help you.

List of PREUPGRADE checks executed by preupgrade.jar

As a result of a joint initiative between our Upgrade Development team and the Support group dealing with upgrade-related SRs we released this MOS Note:

Purpose of the new MOS note is to give you a complete list of checks we execute when you run preupgrade.jar (see MOS Note: 884522.1).… [ Read More ]

Patching my databases with the April 2018 PSU, BP and RU

Patching is fun, isn’t it? And you may have heard already that the April 2018 patch bundles got released on April 17, 2018. And I thought I share a little bit of fun with you with a quick guide to patching my databases with the April 2018 PSU, BP and RU.… [ Read More ]