Autoupgrade analyze failing on UTLRP_RUN_SERIAL

From: Rich J <rjoralist3_at_society.servebeer.com>
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,
Rich

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Oct 10 2019 - 17:01:04 CEST

Original text of this message