pionono/ora12c19c_autoupgrade repository overview

Database now in 12c ORACLE_SID=xe Oracle 19c Software Installed

config file for autoupgrade ---> test.cfg

su - oracle

cd /home/oracle/auto_upgrade_19c

[oracle@1a0ff97e2e32 auto_upgrade_19c]$ cat ANALYZE.txt

export ORACLE_HOME=/opt/oracle/product/19.3.0/dbhome_1/

export PATH=$ORACLE_HOME/bin:$PATH

export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$LD_LIBRARY_PATH

$ORACLE_HOME/jdk/bin/java -jar $ORACLE_HOME/rdbms/admin/autoupgrade.jar -config test.cfg -mode ANALYZE

To Run autoupgrade 12c to 19c

$ORACLE_HOME/jdk/bin/java -jar $ORACLE_HOME/rdbms/admin/autoupgrade.jar -config test.cfg -mode DEPLOY

MONITOR JOBS:

Autoupgrade tool launched with default options +--------------------------------+ | Starting AutoUpgrade execution | +--------------------------------+ 1 databases will be processed Enter some command, type 'help' or 'exit' to quit upg> lsj +----+-------+---------+---------+-------+--------------+--------+--------+-------+ |JOB#|DB NAME| STAGE|OPERATION| STATUS| START TIME|END TIME| UPDATED|MESSAGE| +----+-------+---------+---------+-------+--------------+--------+--------+-------+ | 102| XE|PRECHECKS|PREPARING|RUNNING|25/08/15 09:07| N/A|09:07:37| | +----+-------+---------+---------+-------+--------------+--------+--------+-------+ Total jobs 1