analyze

ORACLE_PDB_SID and AutoUpgrade

Thanks to Rich for this one. I am not a fan of ORACLE_PDB_SID as it is highly error-prone. If you never heard about this environment variable, then stop reading here. You won’t need to learn about it. But in case you are aware of it, then please see what happens when you bring together ORACLE_PDB_SID and AutoUpgrade.

ORACLE_PDB_SID and AutoUpgrade

Photo by Taylor Brandon on Unsplash

ORACLE_PDB_SID?

A long while ago, I wrote two blog posts about Can you connext as SYSDBA without the password into a PDB directly? and Pitfalls: Connect to a PDB directly with ORACLE_PDB_SID. I tried to …

Continue reading...

Upgrading a non-CDB to Oracle Database 21c with AutoUpgrade

Yesterday I wrote about the installation of Oracle Database 21c on Linux. But today it is time for Upgrading to Oracle Database 21c with AutoUpgrade.

Upgrading a non-CDB to Oracle Database 21c with AutoUpgrade

Photo by Arjun MJ on Unsplash

AutoUpgrade

You may have heard it already from us and other colleagues, but we can’t repeat it often enough: There is only one recommended tool to upgrade your databases – and this is AutoUpgrade.

In my 21c home, I’m checking the deployed version of AutoUpgrade at first:

[CDB3] oracle@hol:/u01/app/oracle/product/21/rdbms/admin
$ java -jar autoupgrade.jar -version
build.hash 57ab246
build.version 21.1.3
build.date 2021/04/21 13:32:13
build.max_target_version 21
build.supported_target_versions 12.2,18,19,21
build.type production

Now please …

Continue reading...

Oracle AutoUpgrade between two servers

I try to catch up with missing AutoUpgrade posts. And I should have written this one a while earlier ideally. Just yesterday a colleague asked me about it. So it’s time now to describe how to use Oracle AutoUpgrade between two servers.

Oracle AutoUpgrade between two servers

Photo by Alex Motoc on Unsplash

Documentation

The Oracle Database 19c Upgrade Guide has this section about the scenario:

And you see that it consists of 5 steps:

  1. Run the -mode analyze step on source server
  2. Run the -mode fixups step on source server
  3. Shutdown and
… Continue reading...