To which release should you upgrade to? Plus: Extended Support?

To which release should you upgrade to? Plus: Extended Support?

A few days ago I blogged about the Current Support Status for Oracle Database Releases. And you’ve sent several questions to me. Some asked about clarification to which release should you upgrade to? Plus: Extended Support questions were quite frequent. So let me clarify this previous blog post a bit.… [ Read More ]

OOW 2018: How to Migrate to Oracle Autonomous Database Cloud

OOW 2018: How to Migrate to Oracle Autonomous Database Cloud

And last but not least our forth talk at OOW 2018: How to Migrate to Oracle Autonomous Database Cloud on Tuesday, Oct 23 at a fairly late slot at 5:45 p.m. (or 17:45h) as well in Moscone West 3004.

What is this talk all about?

It’s about the Oracle Autonomous Database cloud.… [ Read More ]

Current Support Status for Oracle Database Releases

Yesterday a former colleague from the UK pointed me to a very old blog post about the fact that no patches will be produced for Oracle 11.2.0.3 anymore. Which is a true fact. But it reminded me that it may be time for an overview on the current support status for Oracle database releases as of October 2018.… [ Read More ]

OOW 2018: Cloud Migration from AIX to ExaCC – for DBAs and managers

OOW 2018: Cloud Migration from AIX to ExaCC - for DBAs and managers

Yes, OOW starts next week. And I’d like to introduce the third of our 4 talks. And let me say upfront about this talk at OOW 2018: Cloud Migration from AIX to ExaCC – for DBAs and managers. This is not the usual “cloud” talk 🙂 The official title is: Oracle Database Cloud Migration: Fast, Simple, Universal.… [ Read More ]

OOW 2018: Upgrade to Oracle 18c – Live and Uncensored

OOW 2018: Upgrade to 18c - Live and Uncensored

Less than two weeks until the potentially busiest Oracle Open World conference I’ve ever attended. The schedule is filled up already and closed down. And I’m pretty sure I will need time off afterwards to relax and recover. But I’m looking forward to our annual big event in San Francisco. To make it as exciting as possible for you we are very happy to have high profile speakers with us in all our talks.… [ Read More ]

New Oracle Database Upgrade Lab for Oracle 18.3.0

New Oracle Database Upgrade Lab for Oracle 18.3.0

Our new and updated Oracle Database Upgrade Hands-On Lab for Oracle 18.3.0 is finally live and can be downloaded via this link:

What’s new?

Of course, Oracle 18.3.0 is inside to upgrade to. But we changed the entire instructions set a bit.… [ Read More ]

OOW2018: The new AutoUpgrade for the Oracle Database

As I wrote the other day, OOW 2018 is not too far away anymore. And if you’d like to see something really new, something which can really really ease your database upgrades in the near future, then you may visit our first talk right on Monday morning at OOW2018: The new AutoUpgrade for the Oracle Database.… [ Read More ]

OOW 2018 is coming – and we’ll have 4 talks and 4 labs

OOW 2018 is coming - and we'll have 4 talks and 4 labs

OOW 2018 is coming – and we’ll have 4 talks and 4 labs. We are excited and look forward to a very busy OOW. And those who say, OOW is marketing only, please come by to our talks and visit our labs to find out that we don’t do marketing.

OOW 2018 is coming – and we’ll have 4 talks and 4 labs

Oracle Open World 2018 will be a busy conference for us.… [ Read More ]

Where does the database link SYS_HUB come from?

This blog lives a lot from customer’s feedback and updates. And these days, Nicolas Jardot from dbi-services in Switzerland sent me an email asking: Where does the database link SYS_HUB come from? And if he can delete it or if it has any deeper purpose. Neither Google nor MOS reveal a lot of useful information

Where does the database link SYS_HUB come from?

Where does the database link SYS_HUB come from?

[ Read More ]

Improved preupgrade.jar for Oracle 12.2 and 18c

My team mates are really quick. We received an information early this week about a missing or wrong DV check in the preupgrade – and they implemented it within a day or so. The September 2018 version of the improved preupgrade.jar for Oracle 12.2 and 18c is available for download.

Improved preupgrade.jar for Oracle 12.2 and 18c

What’s new in this version:

  • It adds a recycle bin check when the autofixup for dictionary statistics is run
  • And it updates DV_AUDIT_CLEANUP  to 11.2.0.4

Improved preupgrade.jar for Oracle 12.2 and 18c

Please find the new September versions of:

  • Oracle 12.2.0.1 preupgrade.jar – build 17
  • Oracle 18c preupgrade.jar – build 5

ready for download from MOS Note:884522.1 – How to Download and Run Oracle’s Database Pre-Upgrade Utility.… [ Read More ]

Office Hours: Upgrade and Migrations – September 20, 2018

It’s time for the next Office Hours: Upgrade and Migrations – September 20, 2018. This time Roy and Bill will run it as I’m traveling. And they’ve set it on purpose to a convenient time for the Americas. Roy has prepared a few slides upfront – and then it’s your time for questions.… [ Read More ]

Post-Conference Blues – or 5 days after POUG1018

Have you ever had a post-conference blues? This is the mood which makes you feel like sitting in a dark cage surrounded just by nothing as silence. And I’m still in post-conference blues – or 5 days after POUG2018.

Post-Conference Blues - or 5 days after POUG1018Worst post-conference blues ever?

Actually my worst post-conference blues wasn’t after POUG2018.… [ Read More ]

Oracle 12.2 and higher: Set _cursor_obsolete_threshold to old default

Sometimes development groups change default parameter settings because it fits well for a specific feature. This has happened with _cursor_obsolete_threshold in Oracle Database 12.2. But there’s now an official recommendation for Oracle 12.2 and higher: Set _cursor_obsolete_threshold to old default.

What is _cursor_obsolete_threshold?

First of all, this is obviously an underscore parameter.… [ Read More ]

Oracle Database 18c on-prem for MS Windows is available

I know it got delayed a bit. But there’s a good reason for the delay. In addition, my post is a bit late as well but I was on vacation. Anyway, you can download it since Aug 22, 2018. Oracle Database 18c on-prem for MS Windows is available.

Oracle Database 18c on-prem for MS Windows is available

Oracle Database 18c on-prem for MS Windows is available

You can download it from oracle.com and eDelivery:

Start here with the Oracle 18c on Windows Installation Guide.… [ Read More ]

New August 2018 preupgrade.jar for upgrades to 18c and 12.2.0.1

My team mates worked hard to improve release the new August 2018 preupgrade.jar for upgrades to 18c and 12.2.0.1. You can download both from myOracle Support.

New August 2018 preupgrade.jar for upgrades to 18c and 12.2.0.1

As usual, MOS Note: 884522.1 gives you access to the most recent versions of the preupgrade.jar tools (and of course the previous preupgrd.sql and utlu112i.sql scripts).… [ Read More ]

POUG – Pint with the Oracle User Group in Sopot, Poland

IPOUG - Pint with the Oracle User Group in Sopot, Poland‘m back from vacation. With 900 or so emails in my inbox. And messages on LinkedIn and Twitter, comments on the blog etc. So plenty of things to do for the next days. The event I’m really looking forward is my upcoming visit of the POUG – Pint with the Oracle User Group in Sopot, Poland.… [ Read More ]

Unified Auditing policies can slow down the upgrade

Unified Auditing policies can slow down the upgradeI posted several blog posts about Unified Auditing in the past. And recently a large customer in the UK alerted me about their upgrades with PDBs from 12.1 to 12.2 taking much longer when Unified Auditing policies were enabled. It looks like as if Unified Auditing policies can slow down the upgrade.… [ Read More ]

RMAN Backup Gives RMAN-06091: No Channel Allocated for Maintenance

RMAN Backup Gives RMAN-06091: No Channel Allocated for MaintenanceI really don’t want to turn this blog into an accumulation of issues and flaws. But as I explained many times before, the blog for me is also a way to dump information I likely will need the sooner or later again.

Recently I blogged about another RMAN issue in Oracle 12.2.0.1 with traces.… [ Read More ]

Cloning with Pluggable Databases in Oracle 18c

We had several discussions on the internal mailing lists the other day about cloning with Pluggable Databases in Oracle 18c (or 12.2.0.1). And I blogged about this topic a while ago but realized I may need to refresh this a bit.

Cloning with Pluggable Databases in Oracle 18c

My example from the old blog post still works fine.… [ Read More ]

Oracle 18.3.0 Multitenant: Compatibility Check does not work

Oracle 18.3.0 Multitenant: Compatibility Check does not workWhen I changed our Hands-On Lab to Oracle 18c, I encountered one strange issue in case I upgraded the UPGR database to 18.3.0 and wanted to plug it in afterwards. Before plugin I usually do a compatibility check. But this seems to fail. I checked my file, my paths, everything.… [ Read More ]

Oracle Multimedia is deprecated in Oracle 18c

While I was writing the blog post about Creating CDBs and non-CDBs with less options I realized that Oracle Multimedia is deprecated in Oracle 18c – but I haven’t mentioned this here yet.

Oracle Multimedia is deprecated in Oracle 18c

Oracle Multimedia was called Oracle Intermedia a long time ago when we introduced it back in the Oracle 8i days.… [ Read More ]

Oracle ORAchk and EXAchk Version 18.3.0 are released

If you are a regular user of ORAchk and/or EXAchk, you should download the most recent and newest version as Oracle ORAchk and EXAchk Version 18.3.0 are released now.

Oracle ORAchk and EXAchk Version 18.3.0 are released

Oracle ORAchk and EXAchk Version 18.3.0 are released

The new features you’ll find in ORAchk 18.3.0 and EXAchk 18.3.0 include:

bullet Beta Support for Oracle Private Cloud Appliance
In EXAchk Health Check Catalog under the Engineered systems of Private Cloud Appliance and Private Cloud Appliance Plane.
[ Read More ]

Oracle Database 18.3.0 on SPARC Solaris is available

Usually I don’t post twice on a day, especially not on a Friday and not in the holiday season. But since last night, Aug 2, Oracle Database 18.3.0 on SPARC Solaris is available for download from OTN.

Oracle Database 18.3.0 on SPARC Solaris is available

Oracle Database 18.3.0 on SPARC Solaris is availableOracle Database 18.3.0 on SPARC Solaris is available

You can download it from OTN:

And I couldn’t find it on eDelivery – where I find only the 18.1.0 version.… [ Read More ]

How long can you provision database version X in the Cloud?

That’s a question I have gotten several times already: How long can you provision database version X in the Cloud? Meaning, is there a fixed date when you’ll be unable to provision an instance containing Oracle Database 12.1.0.2 for instance?

How long can you provision database version X in the Cloud?

[ Read More ]