8i | 9i | 10g | 11g | 12c | 13c | 18c | 19c | 21c | Misc | PL/SQL | SQL | RAC | WebLogic | Linux

Home » Misc » Here

Comments for Upgrading to Oracle Database 19c (Non-CDB) - 11g to 19c


venkhatesh said...

Dear,

Thank you for sharing this... quick question.. is it mandate to convert non-cdb to cdb from 19c onwards ?

Tim... said...

Hi.

No. 19c is the last version of Oracle where using the non-CDB architecture is supported. It is deprecated, but still supported. From 20c onward, the non-CDB architecture is no longer supported.

Cheers

Tim...

Rich Soule said...

Tim,

Any thoughts on autoupgrade vs preupgrade?

Rich

Tim... said...

Hi.

I've not played around with the autoupgrade. I guess it really depends on what scenarios you are dealing with, and what actions it currently supports. Some of our old instances have had "a lot" of clean-up to do prior to upgrades. :)

The last time I checked it doesn't do the final conversion to a PDB, so you could use autoupgrade, then manually convert to a PDB.

Cheers

Tim...

Anonymous said...

Thanks for this blog.I applied all steps as mentioned in this blog.I face below error while running : $ORACLE_HOME/bin/dbupgrade in startup upgrade mode. Error:
Unexpected error encountered in catctlMain; Error Stack Below; exiting Died at /u01/app/oracle/product/19.0.0/dbhome_1/rdbms/admin/catctl.pl
CATCTL fatal error

Tim... said...

Hi.

You need to check through the logs and see what errors were reported and fix them. Each upgrade differs, depending on patch sets and installed options, so it's impossible to cover all bases.

Cheers

Tim...

DO NOT ask technical questions here! They will be deleted!

These comments should relate to the contents of a specific article. Constructive criticism is good. Advertising and offensive comments are bad and will be deleted!

If you post personal information (name, email address etc.) you are agreeing to them being stored and displayed. Feel free to remain anonymous.