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