Re: 12c to 19c - Upgrade

Hi Minh

I was referring turn off utlrp in the PREFIXUP stage, from your output it seems compiling is run at the end of UPGRADE stage.

Can you run this?

grep INVALID_OBJECTS_EXIST autoupgrade_xxxx.log

BR

On Tue, Dec 8, 2020 at 12:57 AM Minh Nguyen <nguyen_ba_minh_at_yahoo.com> wrote:

>
> It seems to work for me. I turned it off by commenting it out from the
> configuration file.
>
> #upg1.run_utlrp=yes
>
> With #upg1.run_utlrp=yes I can see in log file that it didn't go through
> the COMPLE [x%]
> If I didn't turn it off, it will go through listing [1%]...[2%]...[3%]
> Also, it didn't hanged at the COMPILE stage.
>
>
> 2020-11-12 14:35:02.841 INFO [Upgrading] is [91%] completed for [lbgism9d]
> +---------+-------------+
> |CONTAINER| PERCENTAGE|
> +---------+-------------+
> | LBGISM9D|UPGRADE [91%]|
> +---------+-------------+
> 2020-11-12 14:38:21.708 INFO SUCCESSFULLY UPGRADED [LBGISM9D]
> 2020-11-12 14:38:21.708 INFO End Upgrade on Database [LBGISM9D]
> 2020-11-12 14:38:36.319 INFO Begin Compiling Invalid Objects on Database
> [LBGISM9D]
> 2020-11-12 14:38:36.554 INFO [Compiling] is [0%] completed for [lbgism9d]
> objects remaining is [5383]
> +---------+------------+
> |CONTAINER| PERCENTAGE|
> +---------+------------+
> | LBGISM9D|COMPILE [0%]|
> +---------+------------+
> 2020-11-12 14:39:56.332 INFO End Compiling Invalid Objects on Database
> [LBGISM9D]
> 2020-11-12 14:39:56.334 INFO SUCCESSFULLY COMPILED [LBGISM9D]
> 2020-11-12 14:39:56.559 INFO [Upgrading] is [100%] completed for [lbgism9d]
>
>
>
>
> On Monday, December 7, 2020, 03:10:42 PM PST, Ls Cheng <exriscer_at_gmail.com>
> wrote:
>
>
> can utlrp be turned off?
>
> I tried in different autoupgrade versions and utlrp cannot be turned off
> even run_utlrp was set to no...
>
> BR
>
> On Mon, Dec 7, 2020 at 11:41 PM Sanjay Mishra <dmarc-noreply_at_freelists.org>
> wrote:
>
> Thanks Minh for your feedback
>
> On Saturday, December 5, 2020, 01:43:01 PM EST, Minh Nguyen <
> nguyen_ba_minh_at_yahoo.com> wrote:
>
>
>
> I used Autoupgrade for a bunch of 18c -> 19c upgrade.
>
> Works really nice. Ran into two problems.
> 1) Had to turn off utlrp option and ran it manually after the upgrade
> because sometime it took 3hrs just to run the ultrp part.
> Sometime it ran fine with non-system invalid objects and some time it
> doesn't.
> We couldn't figure out what was the problem so Oracle Support said
> just to turn it off and run manually afterward.
> 2) The iowait was like 80% when we tried to do two upgrades at the same
> time
> so we decided to do one at a time
>
>
> Minh
>
> On Saturday, December 5, 2020, 09:27:18 AM PST, Sanjay Mishra <
> dmarc-noreply_at_freelists.org> wrote:
>
>
> Thanks All. Which one is better in terms of taking care of most of the
> pre-post step and also restart able from the failure
>
> I can see that dbua GUI might have option to retry but not sure with
> silent mode. But it look like Autoupgrade is good option but have not used
> and earlier thought that is good for multiple upgrade.
>
> Can anyone also share his experience with dbupgrade/DBUA/Autoupgrade ?
>
> Tx
> Sanjay
>
> On Thursday, December 3, 2020, 08:02:07 PM EST, Lyall Barbour <
> lyallbarbour_at_sanfranmail.com> wrote:
>
>
> To be totally honest, I didn't even realize there was a silent mode from
> dbua. Maybe it just fires off the perl catctl.pl
>
> VERY related, if anyone is using 19c with SLES 15 sp2, do NOT apply the
> latest cve for binutils (libc.so.6)
> If you do, do not patch or relink the 19c executables. You'll get core
> dumps trying to start the instance.
>
> We have a ticket in with SuSE and Oracle to get it fixed.
>
> Lyall
>
> --
> Sent from my Android phone with mail.com Mail. Please excuse my brevity.
> On 12/3/20, 7:34 PM Mladen Gogala <gogala.mladen_at_gmail.com> wrote:
>
> I can't. I used dbupgrade shell script and catctl.pl I find it easier
> than dbua.
>
> Regards
> On 12/3/20 6:59 PM, Sanjay Mishra (Redacted sender smishra_97 for DMARC)
> wrote:
>
> Can anyone share his experience using dbua in silent mode from 12c(12.1 or
> 12.2) to 19c ?
>
> Tx
> Sanjay
>
> --
> Mladen Gogala
> Database Consultant
> Tel: (347) 321-1217
>
> -- http://www.freelists.org/webpage/oracle-l
>
>

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