Re: DBUA Upgrade Question

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

On 07/26/2018 10:58 AM, Scott Canaan wrote:
>
> 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.
>

-- 
Mladen Gogala
Database Consultant
Tel: (347) 321-1217


--
http://www.freelists.org/webpage/oracle-l