Re: Autoupgrade analyze failing on UTLRP_RUN_SERIAL

  • From: Mladen Gogala <gogala.mladen@xxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Thu, 10 Oct 2019 13:59:15 -0400

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@xxxxxxxxxxxxxxxxxxxxx <mailto:rjoralist3@xxxxxxxxxxxxxxxxxxxxx>> 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@xxxxxxxxx <mailto:peter.m.gram@xxxxxxxxx>
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

Other related posts: