This blog aims to support DBAs upgrading databases from 12.1.0.2 to 19.20 using the new AutoUpgrade tool.
Oracle Database AutoUpgrade is the supported and recommended method for upgrading Oracle database.
Install oracle-database-preinstall-19c
#yum install oracle-database-preinstall-19c
Perform a Software Only Install
$cd /p01/oracle/test/19.0.0
unzip -o /19C_SOFTWARE_STAGE/V982063-01.zip
$./runInstaller
Apply Database Release Update 19.20
Download latest AutoUpgrade Tool
Create autoUpgrade config file
$cat DB19.cfg
upg1.source_home=/p01/oracle/test/12.1.0
upg1.target_home=/p01/oracle/test/19.0.0
upg1.sid=TEST
Run autoupgrade in analyze mode
$/p01/oracle/test/19.0.0/jdk/bin/java -jar autoupgrade.jar -config DB19.cfg -mode analyze
Run AutoUpgrade in fixups mode
$/p01/oracle/test/19.0.0/jdk/bin/java -jar autoupgrade.jar -config DB19.cfg -mode fixups
Upgrade the database (Run autoupgrade in deploy mode)
$/p01/oracle/test/19.0.0/jdk/bin/java -jar autoupgrade.jar -config DB19.cfg -mode deploy
Recommended Posts