Forum Stats

  • 3,853,884 Users
  • 2,264,289 Discussions
  • 7,905,494 Comments

Discussions

Autoupgrade tool failing with error

DDeb
DDeb Member Posts: 64 Blue Ribbon
edited Jul 15, 2020 12:47PM in Database Upgrade

Hello experts,

                       I am facing a strange error for which I have no clue how to debug as it is a jar file used for database upgrade.I am running below command to upgrade from 12.1.0.2 to 19.6.0.0.If anybody has any clue please help me.

export ORACLE_BASE=/oracle_homes/cisd26/oracle

export ORACLE_HOME=/oracle_homes/cisd26/oracle/product/12.2.0.3

export CLASSPATH=/oracle_homes/cisd26/oracle/product/12.2.0.3/rdbms/admin

export PATH=$ORACLE_HOME/jdk/bin:$PATH

cd $ORACLE_HOME/rdbms/admin

java -jar /oracle_homes/cisd26/oracle/product/12.2.0.3/rdbms/admin/autoupgrade.jar -config /oracle_homes/cisd26/oracle/product/12.2.0.3/rdbms/admin/sample_config.cfg -mode analyze

There were no databases to process on the current host on /oracle_homes/cisd26/oracle/product/12.2.0.3/rdbms/admin/sample_config.cfg. Make sure that value for upgrade_node entry in config file matches the output of executing command hostname.

--This message is absolutely misleading as hostname command is giving exactly same name what I am using in config file.

Contents of sample_config.cfg

# sample config file
#
# build version 19.7.5
# build date    2020/02/11 15:28:49
#
#
# Global configurations
#
# This directory will include the following
#   (1) AutoUpgrade's global directory
#   (2) Any logs, not directly tied to a job
#   (3) Config files
#   (4) progress.json and status.json
global.autoupg_log_dir=/oracle_homes/cisd26/oracle/product/12.2.0.3/rdbms/admin/upg_logs


#
# Database number 1
#
upg1.dbname=cisd26
upg1.start_time=NOW
upg1.source_home=/oracle_homes/cisd26/oracle/product/12.1.0.2
upg1.target_home=/oracle_homes/cisd26/oracle/product/12.2.0.3
upg1.sid=cisd26
upg1.log_dir=/oracle_homes/cisd26/oracle/product/12.2.0.3/rdbms/admin/upg_logs/cisd26
upg1.upgrade_node=XXXXXXX
upg1.target_version=19
upg1.run_utlrp=yes
upg1.timezone_upg=yes

Regards

Dhritiman Deb

Answers

  • Daniel Overby Hansen-Oracle
    Daniel Overby Hansen-Oracle Posts: 93 Employee
    edited Jul 15, 2020 2:33AM

    You are using an old version of AutoUpgrade. Please download the latest version from MOS note 2485457.1 and retry the operation.

    If that doesn't solve the problem, please zip up the entire directory including log and config files using (replace paths accordingly):

    java -jar autoupgrade.jar -config sample_config.cfg -zip

    Create a service request and upload the zip file. Let me know the SR # and I will have devs review the log files, so we can fix the problem.

    To get you started you can either try to:

    1) Remove "upgrade_node" parameter - that will have it default to localhost

    2) Set "upgrade_node" to "localhost" instead of the actual name

    3) You can try to use the FQDN, instead of host01 - it might be host01.com

    Regards,

    Daniel

    DDeb
  • DDeb
    DDeb Member Posts: 64 Blue Ribbon
    edited Jul 15, 2020 12:47PM

    Very strange.I t worked when I commnted upgrade_node

    java -jar autoupgrade.jar -config sample_config.cfg -mode analyze
    AutoUpgrade tool launched with default options
    Processing config file ...
    +--------------------------------+
    | Starting AutoUpgrade execution |
    +--------------------------------+
    1 databases will be analyzed
    Type 'help' to list console commands
    upg> Job 100 completed
    ------------------- Final Summary --------------------
    Number of databases            [ 1 ]

    Jobs finished successfully     [1]
    Jobs failed                    [0]
    Jobs pending                   [0]
    ------------- JOBS FINISHED SUCCESSFULLY -------------
    Job 100 for cisd26

    Regards

    Dhritiman Deb