Contents
What should I do if my database upgrade fails?
Use utlrp.sql to recompile invalid objects. If you fail to do this before an upgrade, then it becomes difficult to determine which objects in your system were invalid before starting the upgrade, and which objects become invalid as a result of the upgrade.
Why do I get a Java upgrade error?
If the view CDB_JAVA_POLICY becomes invalid, then use this procedure. On Windows platforms, an error may occur related to ADVM or ACFS drivers if a server restarts during an upgrade. Component status settings are affected both by the components that you previously installed, and by the support of those components for upgrades.
Why is XDB now invalid, invalid objects found?
Review this topic if you encounter “Warning: XDB now invalid, invalid objects found” errors when upgrading pluggable databases (PDBs). Use this procedure to identify DRA_REEVALUATE_OPEN_FAILURES jobs that block upgrades. ORA-22288 occurs when symbolic links are in directory object paths or filenames when opening BFILES.
Why do I get an oracle upgrade error?
Before running an upgrade script, queries on any other view or the use of PL/SQL returns an error. Errors described in this section can occur when you attempt to start the new Oracle Database release. Some of these errors write to the alert log, and not to your session.
How to restart a failed database upgrade with dbua 12.2?
Restarting a failed Database Upgrade with DBUA 12.2 – Upgrade your Database – NOW! In my previous blog post I did showcase how to restart a failed database upgrade on the command line before Oracle Database 12c, with Oracle Database 12.1.0.x and with the new Oracle Database 12.2.0.x:
When to run the postupgrade status tool for Oracle Database?
Never run the postupgrade status tool for the new Oracle Database 12.2 release ( utlu122s.sql) until after you complete the upgrade. Oracle recommends that you run the postupgrade status tool only after the upgrade process is complete, and after you have run utlrp.sql.