Re: Autoupgrade analyze failing on UTLRP_RUN_SERIAL

Well, apart from "evil thingies", there is the good, old catctl.pl:

bash-4.2$ cd $ORACLE_HOME/rdbms/admin
-bash-4.2$ ls *.pl
bulkimport.pl  catcdb.pl  catcon.pl  catctl.pl  odbsrmt.pl rman.pl -bash-4.2$ echo $ORACLE_HOME
/opt/oracle/product/19c/dbhome_1
-bash-4.2$

Oracle 19c is a part of the 12c series of products and I haven't had any issues upgrading 12.1 to 19c. I was using the recipe described here:

https://docs.oracle.com/en/database/oracle/oracle-database/12.2/upgrd/upgrading-parallel-upgrade-utility-catctl-pl.html#GUID-9AA7ADC1-E2F7-4C26-9E91-A583D1D694C5

Be aware of PERL5LIB trap and may the Force be with you.

On 10/10/19 1:51 PM, Peter Gram wrote:
> Hi
>
> Sorry but in my view DBUA is the evil thing with out any consistency.
> The old way in the manuals was to run the documented script and they
> was repeatable and consistent.
>
>
>
> On Thu, 10 Oct 2019 at 17.20, Rich J <rjoralist3_at_society.servebeer.com
> <mailto:rjoralist3_at_society.servebeer.com>> wrote:
>
> On 2019/10/10 10:08, Peter Gram wrote:
>
>> Hi
>> I have just today upgraded two databases from 12.1.0.2 to 19.3.1
>> and it was not a walk in the park since the error messages are
>> very hard to understand / interpret.
>> After fixing my problem it worked without problems.
>> I did not know the still was a supported "old" way so where have
>> you found the old way documented ?
> I'm including DBUA in the "old" category...
> https://docs.oracle.com/en/database/oracle/oracle-database/19/upgrd/upgrade-and-data-migration-methods-and-processes.html
> <https://docs.oracle.com/en/database/oracle/oracle-database/19/upgrd/upgrade-and-data-migration-methods-and-processes.html#GUID-93250F01-DB85-4CA2-9A10-5B5FA5E4B924>
> Thanks,
> Rich
>
> --
> Best regards/Venlig hilsen
>
> Peter Gram
> Sæbyholmsvej 18 DK-2500 Valby
>
> Cell:    (+45) 5374 7107
> Home: (+45) 3874 5696
> Email: peter.m.gram_at_gmail.com <mailto:peter.m.gram_at_gmail.com>
> linkedin: dk.linkedin.com/in/petergram/
> <http://dk.linkedin.com/in/petergram/>
> OakTable : oaktable.net/members <http://oaktable.net/members>
>
>

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


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