Video: Best Practices to Upgrade to Oracle Database 19c

This is a short “Black Friday” blog post. And just if you are tired already of hunting supposed-to-be-bargain-buys, you may need something to relax – and watch this Video: Best Practices to Upgrade to Oracle Database 19c.

Video: Best Practices to Upgrade to Oracle Database 19c

Roy recorded it as part of the Quest Experience Week. We’d like to share it with you here.

Just click on the picture below to open a new TAB and watch the 1 hour video:


If you are looking for the slide deck, you can download them from:



Continue reading...

Upgrade / Migrate / Consolidate to 19c – Dubai, VAE

Upgrade / Migrate / Consolidate to Oracle 19c – Dubai, VAE

Oct 14, 2019 – 9:30h-16:30h

Oracle VAE, Dubai Internet City, Building 6, first floor, Jumeirah 1/2


Start: 9:30h

  • Release Model and Patching – Strategies and Best Practices
  • Upgrade to Oracle Database 19c
    • Includes Demo
    • Includes the new AutoUpgrade tool
    • Includes customer example on how to upgrade 150 databases in 2 weeks

Coffee Break: 11:00h – 11:15h

  • Ensure Performance Stability
    • General guidelines
    • SQL Tuning
    • SPM (SQL Plan Management)
    • Real Application Testing (SQL Performance Analyzer and Replay)
    • Performance Comparison before -/- after
  • Migration techniques overview
    • On-prem and to the Oracle
Continue reading...

Database Migration from non-CDB to PDB – Overview

Today I’ll start a blog post series of several “how to” articles about database migration from non-CDB to PDB – Overiew. You’ll find a quick introduction below. And of course, the links to all the other related blog posts.

Database Migration from non-CDB to PDB – Overview

When you plan to move from non-CDB, the Oracle term for regular database deployments, to a Pluggable Database (PDB), you will migrate your database. It will become a PDB and run as part of a Container Database (CDB). This is a well known concept for several years now called Oracle Multitenant. If you …

Continue reading...

AutoUpgrade: Where do you find all the logfiles?

AutoUpgrade: Where do you find all the logfiles?In the previous blog posts you could read about how to create the configuration file, adjust it and tweak the init parameters for the AutoUpgrade tool. And then I described the different modes of it. In this blog post I’d like to give you some insights into AutoUpgrade: Where do you find all the logfiles?

AutoUpgrade: Where do you find all the logfiles?

AutoUpgrade – Step-by-step

  1. The new AutoUpgrade Utility – Download, documentation and supported versions
  2. Create and adjust the config file for AutoUpgrade
  3. Config file for AutoUpgrade – Advanced options
  4. Config file for AutoUpgrade – Tweaking init parameters
  5. AutoUpgrade: ANALYZE, FIXUPS, UPGRADE and DEPLOY modes
  6. AutoUpgrade:
Continue reading...

Yatra 2019 – Oracle Groundbreakers: Roy Swonger travels to India

In April in Vienna a colleague from the US asked me: “Is Roy serious to travel to India in July?”. He mentioned the temperatures, the humidity – and the rain. But Roy is serious – and while I’m writing this, he should be already on his way  to India to present about Upgrade and Migrations in 5 locations at Yatra 2019 – Oracle Groundbreakers: Roy Swonger travels to India.

Yatra 2019 - Oracle Groundbreakers: Roy Swonger travels to India

Why you need to attend?

The organizers have listed 6 fine reasons for attending Yatra on the official Yatra 2019 conference page. And I’m adding another one: You want to …

Continue reading...

Oracle Database 19c (19.3.0) for HP-UX and AIX is available for download

Oracle Database 19c (19.3.0) for HP-UX and AIX is available for downloadFor a few days, in addition to Linux and SPARC Solaris, Oracle Database 19c (19.3.0) for HP-UX and AIX is available for download now as well. The missing platforms, Windows, Intel Solaris and zLinux should be available soon as well.

Oracle Database 19c on premises for HP-UX and AIX

You can download Oracle Database 19.3.0 on-prem for HP-UX ia64 and IBM AIX from the usual sources:

Oracle 19c Documentation

And of course you can find the Oracle 19c Documentation here:

See especially the operating …

Continue reading...

Oracle GoldenGate 19c is available for download for Linux

Oracle GoldenGate 19c is available for download for Linux

Photo by Raquel Stanton on Unsplash

I have a good numbers of customers waiting for it – and since two days Oracle GoldenGate 19c is available for download for Linux. You can download it from the usual sources. The other platforms should follow soon.

Download Sources for Oracle GoldenGate 19c

Certification for Oracle GoldenGate 19c

New Features and Documentation

For a list of new features in Oracle GoldenGate 19c see the list in the documentation – and of course, the most important feature is …

Continue reading...

Oracle 18.4.0 installation on AIX may fail with ORA-40238

Oracle 18.4.0 for IBM AIX is available since mid November 2018. But I’ve received several emails from people saying that Oracle 18.4.0 installation on AIX may fail with ORA-40238. And it’s true, this can happen. But there’s a simple workaround which unfortunately is not in the documentation yet. We’ll take care that it will be added soon.

Oracle 18.4.0 installation on AIX may fail with ORA-40238

Oracle 18.4.0 installation on AIX may fail with ORA-40238

First of all, this is an error pattern you may see on IBM AIX only. You may receive the following error message either during installation or startup of ASM or any …

Continue reading...

Does OJVM patching require a specific Database Release Update?

This question came up several times in the past days: Does OJVM patching require a specific Database Release Update? People mentioned that there’s a significant difference between the OJVM Patch Readme between Oracle 12.2.01 and Oracle 18.4.0.

Photo by Jimmy Ofisia on Unsplash

What’s the point?

In the OJVM (Oracle Java Virtual Machine) Patch Readme for Oracle Database a sentence clarified that you can combine different states of OJVM and Database patch bundle with each other. Your database home could have been patched with the April 2018 Update, whereas you decided to apply the October 2018 OJVM patch.

The …

Continue reading...

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. But I simply may be not clever enough to use the right search phrase (I used “Oracle Database” as “18” leads to something different).

Further Information

Continue reading...

July 2018 Update, Revision, BP and PSU

Hurray, it’s patching day! I know, YOU did look forward to July 17, 2018 as it is patching day again. Last night we released the following Patches: July 2018 Update, Revision, BP and PSU.

July 2018 Update, Revision, BP and PSU

First of all, I’m doing the usual check for the alert and the risk matrix to see whether there’s are really important security patches included. For the risk matrix you’ll have to scrooooooooooolllll down quite a bit as the list of products is strictly alphabetically ordered:

Continue reading...

upobjxt.lst lists Oracle Supplied Objects

I blogged about upobjxt.lst lists Oracle Supplied Objects a while ago. But I thought it’s time to refresh this blog post a bit and adjust it to be more useful. upobjxt.lst displays the Oracle Supplied Objects since Oracle Database

upobjxt.lst lists Oracle Supplied Objects and Users

You can access upobjxt.lst simply with an external table.

  1. Create a directory object:
    CREATE OR REPLACE DIRECTORY ext_tab_data AS '/u01/app/oracle/product/';
  2. Define the external table to query it:
    CREATE TABLE oracle_supplied_obj_ext (
    owner       VARCHAR2(31),
    name        VARCHAR2(127),
    placeholder VARCHAR2(20),
    object_type NUMBER
    DEFAULT DIRECTORY ext_tab_data
Continue reading...

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?

First of all, the Oracle Instant Client is a pretty cool thing. It gets distributed via OTN as a simple download. You deploy it to your client machine, you set LD_LIBRARY_PATH (or PATH on Windows) and add a tnsnames file if necessary, you may add SQL*Plus …

Continue reading...

Oracle Database certification on Microsoft Windows 10

The MOS Note: 1307195.1  about

Certification Information for Oracle Database on Microsoft Windows x64 (64-bit)

got updated right before the 2015 Christmas holidays with the official certification information for Oracle Database 12c on Microsoft Windows 10.

And it says:

Windows 10 O/S Information:
RAC is not certified.
The earliest release certified on Windows 10 is


Previous related blog posts from Aug 14, 2015:

Continue reading...

What or who is JOX? And what happens if …

Are you worried because of the title of this blog post? Don’t worry … it will be about the Oracle database and not about miraculous additives.

Months back I wrote about how to remove options from the Oracle database’s kernel by either using chopt or linking options off:

Recently a very interesting case was logged in relation to a bug:
A customer had linked off the JOX option from the database kernel.

What is JOX? 

Well, do a quick search for “JOX” in the Oracle Documentation and …

Continue reading...

SAP on Oracle Database 12c now with Oracle In-Memory

Oracle SAPOn March 31, 2015 SAP has been certified to run on Oracle Database

As of June 30, 2015, Oracle Database In-Memory is supported and certified for SAP environments for all SAP products based on SAP NetWeaver 7.x. on Unix/Linux, Windows and Oracle Engineered Systems platforms running Oracle Database 12c – in single instance and Oracle Oracle Real Application Clusters deployments.

Oracle Database 12c is the database of choice for SAP customers based on In-Memory Technology which is fully supported for SAP BW and SAP OLTP applications.

For …

Continue reading...

SAP is now certified on Oracle Database

ORACLE and SAPSAP certified Oracle Database as of March 31, 2015!

Yes, it’s true. Our colleagues in the Oracle/SAP/CompetenceCenter in Walldorf worked really hard to complete the certification for SAP with Oracle Database But finally it happened. Actually it was announced long time before as planned. And it happened right in time.

Please find the official documents here:

SAP Service Marketplace ==> Products ==> Installation & Upgrade Guides ==> Database Upgrades (login required) ==> Oracle 

And here’s the link to the official

Continue reading...

Simplify your Migration from AIX to Solaris

Oracle Solaris 11There is a brand new white paper available that will be of interest to anybody contemplating a database and/or application migration from AIX to Solaris. Simplify the Migration of Oracle Database and Oracle Applications from AIX to Oracle Solaris gives a good description of the steps involved in planning and executing a migration project, along with the benefits you can expect to achieve and a solid example of migration using Oracle Data Pump, complete with scripted steps.…

Continue reading...

Behaviour Changes Oracle 8i to 11.2 + New Features Oracle 11.2 + refreshed Upgrade and Migration Slides

We have uploaded refreshed and new slide sets:

Continue reading...

Hands-on with the Latest Oracle Technology

There is a new set of FREE hands-on workshops available that will give you a chance to work with Advanced Compression, Transparent Data Encryption, Real Application Testing, and GoldenGate without having to spend the time and resources to set up a test environment of your own. If you have a laptop, this is a great opportunity to actually use these options and see how they work for yourself.

Titled Oracle Database 11g Upgrade Architecture Planning Workshops,  these events are being rolled out in cities across the country. The first four are in the western part of …

Continue reading...

Oracle Database Express Edition 11g Release 2 is now available!

Many customers have asked over the past year whether we would be producing a newer version of the Oracle Database Express Edition, because it makes such a terrific starter database for students, developers, and DBAs. Well, the answer is Yes!

As of today, Oracle Database Express Edition 11g Release 2 is available for download. As with the 10g release, this Express Edition is free of charge. To find more information about downloading the software and documentation, please visit the OTN page for Express Edition.

Remember, you can always upgrade your database to Standard or Enterprise Edition if you outgrow …

Continue reading...

Database Registry: Component Dependencies

Recently I had to dig a bit into the component dependency topic as I was working with an Oracle Database customer planning to upgrade to Oracle Database with a limited downtime window. To achieve the given downtime window we planned to remove some unused components from the database.

Database Component Dependencies
Example: Component Dependencies in Oracle Database 11.1

As you know already the time it’ll take to upgrade an Oracle database is mainly dependent on the number of installed components. If you’ll query DBA_REGISTRY (or the underlying REGISTRY$) you’ll spot all the installed (and usually configured) database components. And the …

Continue reading...

Will gathering fixed object stats reduce recompilation time post upgrade?

Interesting question, isn’t it?
Will the time to recompile invalid objects post upgrade decreased once fixed object stats have been gathered?

First of all fixed object stats on X$-tables won’t be gathered by default [This will change with Oracle 12c where it is part of the Auto Stats Gathering job].
X$ structures are undocumented. V$ views are build on top of them and
should only be used even though it might be sometimes useful to access
X$ tables such as X$BH (buffer headers – contains information describing the current contents of a piece of the buffer cache

Continue reading...