DBUA Upgrade Question

From: Scott Canaan <srcdco_at_rit.edu>
Date: Thu, 26 Jul 2018 14:58:18 +0000
Message-ID: <3e5ee1a6927141fca7e3bc6eafd4be4d_at_ex04mail01d.ad.rit.edu>



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 "_at_/oracle/app/cfgtoollogs/dbua/upgrade2018-07-25_12-59-49-PM/DBAZTECT/PDBUpgradeTZ.sql" in container PDB$SEED using process 0 catconExec_int: executing "_at_/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: (585) 475-7886 | f: (585) 475-7520
srcdco_at_rit.edu<mailto:srcdco_at_rit.edu> | c: (585) 339-8659

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.

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Jul 26 2018 - 16:58:18 CEST

Original text of this message