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

Start typing and press Enter to search