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: (585) 475-7886 | f: (585) 475-7520
srcdco@xxxxxxx<mailto:srcdco@xxxxxxx> | 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.
