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@xxxxxxxxx>
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@xxxxxxxxx>
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@xxxxxxxxxxxxx>
wrote:
Thanks Minh for your feedback
On Saturday, December 5, 2020, 01:43:01 PM EST, Minh Nguyen <
nguyen_ba_minh@xxxxxxxxx> 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@xxxxxxxxxxxxx> 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@xxxxxxxxxxxxxxx> 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@xxxxxxxxx> 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
-- //www.freelists.org/webpage/oracle-l
