Autoupgrade analyze failing on UTLRP_RUN_SERIAL
Date: Thu, 10 Oct 2019 10:01:04 -0500
Message-ID: <aaa2aa43660c733bf359868c251a78cd_at_society.servebeer.com>
Hey all,
Looking to upgrade a 12.2 DB on x86-64 OEL7.4 to 19.4, so I thought I'd give the Autoupgrade utility a try. I'm using the JRE included with 19.4, "1.8.0_201".
As recommended, I started with the "analyze" phase. After encountering an error during the "UTLRP_RUN_SERIAL" check, I downloaded the latest Autoupgrade from MOS 2485457.1. The error format changed, but it's still erring out on the same check with:
2019-10-10 09:38:56.400 ERROR Error occurred while running the
dispatcher for job 101
Cause: An execution error occurred when running the database checks or
fixups - AutoUpgDispatcher.run
2019-10-10 09:38:56.400 ERROR The dispatcher has failed due to:
Error: UPG-1316
[Unexpected Exception Error]
This shows up in the "autoupgrade_user.log" file:
Exception: NumberFormatException
Err message: For input string: "50,50"
java.lang.NumberFormatException.forInputString(NumberFormatException.java:65) java.lang.Integer.parseInt(Integer.java:580) java.lang.Integer.parseInt(Integer.java:615) oracle.upgrade.commons.dbinspector.checks.utlrp_run_serial.checkCode(utlrp_run_serial.java:67) oracle.upgrade.commons.dbinspector.Check.presentInDb(Check.java:227)oracle.upgrade.commons.dbinspector.CheckTrigger.call(CheckTrigger.java:72) oracle.upgrade.commons.dbinspector.CheckTrigger.call(CheckTrigger.java:40)
java.util.concurrent.FutureTask.run(FutureTask.java:266) java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) java.lang.Thread.run(Thread.java:748)
...which appears to be a modified version of the standard Java stack trace found in the "autoupgrade_err.log" file.
This is not filling me with confidence in the Autoupgrade. It appears that others have discovered the Java love as well: https://mikedietrichde.com/2019/04/29/the-new-autoupgrade-utility-in-oracle-19c/
Has anyone used this successfully? Or have folks been using the "old" ways to upgrade?
Thanks,
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Oct 10 2019 - 17:01:04 CEST