DBUA Upgrade Question

[Scott Canaan]

We are not yet using containers, but I've set up a container database to play with. It was created as an Oracle 12.1.0.2 database and I wanted to upgrade to 12.2.0.1. I used dbua to perform the upgrade. After 3 unsuccessful tries (I didn't originally install Java), the upgrade was almost completely successful.

The problem that I had with the last attempt was that the timezone upgrade in the PDBs failed. I told it to ignore that error and finish. First, I don't understand why it failed. Second, how can I fix it and what do I have to do different to make it work?

Here's the contents of the log file for the timezone upgrade in the PDBs:

catcon: ALL catcon-related output will be written to [/oracle/app/cfgtoollogs/dbua/upgrade2018-07-25_12-59-49-PM/DBAZTECT/PDBSUpgradeTimezone_catcon_31240.lst]
catcon: See [/oracle/app/cfgtoollogs/dbua/upgrade2018-07-25_12-59-49-PM/DBAZTECT/PDBSUpgradeTimezone*.log] files for output generated by scripts
catcon: See [/oracle/app/cfgtoollogs/dbua/upgrade2018-07-25_12-59-49-PM/DBAZTECT/PDBSUpgradeTimezone_*.lst] files for spool files, if any
catconInit: start initializing catcon
catconInit: finished constructing connect strings
catconInit: start CDB-specific processing
catconInit: finished examining instances which can be used to run scripts/SQL statements.
catconInit: started SQL*Plus processes.
catconInit: DBMS version: 12.2.0.1.0.
catconInit: initialization completed successfully (2018-07-25 14:27:42)
catconExec: start executing scripts/SQL statements
catconExec: finished examining scripts/SQL statements to be executed.
catconExec: run all scripts/statements against remaining 2 PDBs
force_pdb_modes: reset_pdb_modes completed successfully
catconExec_int: executing "@/oracle/app/cfgtoollogs/dbua/upgrade2018-07-25_12-59-49-PM/DBAZTECT/PDBUpgradeTZ.sql" in container PDB$SEED using process 0
catconExec_int: executing "@/oracle/app/cfgtoollogs/dbua/upgrade2018-07-25_12-59-49-PM/DBAZTECT/PDBUpgradeTZ.sql" in container DBAZBASE using process 1
catconWrapUp: (PID=31240) about to free up all resources
Signal TERM was received.
Died at /oracle/app/product/12.2.0.1/rdbms/admin/catcon.pm line 11392.
Enter Password:

Thank you,

Scott Canaan '88
Sr Database Administrator
Information & Technology Services
Finance & Administration
Rochester Institute of Technology
o: [phone] | f: [phone]
***@rit.edu<mailto:***@rit.edu> | c: [phone]

CONFIDENTIALITY NOTE: The information transmitted, including attachments, is intended only for the person(s) or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and destroy any copies of this information.

[Mladen Gogala]

Hi Scott,

You can use DBMS_DST.BEGIN_UPGRADE. That procedure needs to be executed
with the database in the "UPGRADE" mode. The file version, for 12.2 is
26. For Oracle 12.1 it is 18 and for Oracle 11G it is 14. Basically,
what you need to do from the CDB$ROOT container is the following:

shutdown immediate

startup upgrade

EXEC DBMS_DST.BEGIN_UPGRADE(26);

COMMIT /* This is my own addition, just for the piece of mind */

SHUTDOWN IMMEDIATE

STARTUP


Regards

We are not yet using containers, but I’ve set up a container database
to play with.  It was created as an Oracle 12.1.0.2 database and I
wanted to upgrade to 12.2.0.1.  I used dbua to perform the upgrade. 
After 3 unsuccessful tries (I didn’t originally install Java), the
upgrade was almost completely successful.
The problem that I had with the last attempt was that the timezone
upgrade in the PDBs failed.  I told it to ignore that error and
finish.  First, I don’t understand why it failed.  Second, how can I
fix it and what do I have to do different to make it work?
catcon: ALL catcon-related output will be written to
[/oracle/app/cfgtoollogs/dbua/upgrade2018-07-25_12-59-49-PM/DBAZTECT/PDBSUpgradeTimezone_catcon_31240.lst]
catcon: See
[/oracle/app/cfgtoollogs/dbua/upgrade2018-07-25_12-59-49-PM/DBAZTECT/PDBSUpgradeTimezone*.log]
files for output generated by scripts
catcon: See
[/oracle/app/cfgtoollogs/dbua/upgrade2018-07-25_12-59-49-PM/DBAZTECT/PDBSUpgradeTimezone_*.lst]
files for spool files, if any
catconInit: start initializing catcon
catconInit: finished constructing connect strings
catconInit: start CDB-specific processing
catconInit: finished examining instances which can be used to run scripts/SQL statements.
catconInit: started SQL*Plus processes.
catconInit: DBMS version: 12.2.0.1.0.
catconInit: initialization completed successfully (2018-07-25 14:27:42)
catconExec: start executing scripts/SQL statements
catconExec: finished examining scripts/SQL statements to be executed.
catconExec: run all scripts/statements against remaining 2 PDBs
force_pdb_modes: reset_pdb_modes completed successfully
catconExec_int: executing
in container PDB$SEED using process 0
catconExec_int: executing
in container DBAZBASE using process 1
catconWrapUp: (PID=31240) about to free up all resources
Signal TERM was received.
Died at /oracle/app/product/12.2.0.1/rdbms/admin/catcon.pm line 11392.
Thank you,
*Scott Canaan ‘88**
*/Sr Database Administrator
/Information & Technology Services
Finance & Administration **
*Rochester Institute of Technology
*o: [phone] | f: [phone]**
*CONFIDENTIALITY NOTE*: The information transmitted, including
attachments, is intended only for the person(s) or entity to which it
is addressed and may contain confidential and/or privileged material.
Any review, retransmission, dissemination or other use of, or taking
of any action in reliance upon this information by persons or entities
other than the intended recipient is prohibited. If you received this
in error, please contact the sender and destroy any copies of this
information.