Below is a step-by-step guide to walk you through how to upgrade oracle database to 19c.
Step 1
Download the Oracle 19c binaries, the latest version of OPatch, How To Download And Install The Latest OPatch (6880880) Version (Doc ID 274526.1) and the AutoupGrade Tool (Doc ID 2485457.1) from Oracle support. For this example, the zip files were downloaded to:
/misc/stage/oracle/database/19c.
Step 2
Have your system administrator install the Oracle 19c rpm. This will create the required users and groups and install the necessary packages.
Step 3
Check to see if it has been installed.
rpm -qa | grep oracle
It should return
oracle-database-preinstall-19c-1.0-3.el7.x86_64
Step 4
Create the new ORACLE_HOME directory. This step may vary depending on what directories are already created on your server.
cd /u01/app/oracle
mkdir -p product/19.3.0/dbhome_1
Step 5
Move the Oracle binary and OPatch zip files downloaded in step 1 to the ORACLE_HOME directory and unzip the files.
cd /u01/app/oracle/product/19.3.0/dbhome_1
cp /misc/stage/oracle/database/19c/LINUX.X64_193000_db_home.zip .
unzip LINUX.X64_193000_db_home.zip
mv OPatch OPatch_old
cp /misc/stage/oracle/database/19c/p6880880_230000_Linux-x86-64.zip .
unzip p6880880_230000_Linux-x86-64.zip
Step 6
Remove the zip files.
rm p6880880_230000_Linux-x86-64.zip
rm LINUX.X64_193000_db_home.zip
Step 7
Install the Oracle 19c binaries doing a software only install.
cd /u01/app/oracle/product/19.3.0/dbhome_1
./runInstaller
Step 8
Replace the existing autoupgrade tool jar file with the one downloaded in step 1.
mv /u01/app/oracle/product/19.3.0/dbhome_1/rdbms/admin/autoupgrade.jar /u01/app/oracle/product/19.3.0/dbhome_1/rdbms/admin/autoupgrade.jar_old
cp /misc/stage/oracle/database/19c/autoupgrade.jar /u01/app/oracle/product/19.3.0/dbhome_1/rdbms/admin/.
Step 9
Create a directory to hold the config file for the autoupgrade tool.
cd /u01/home/oracle
mkdir autoupgrade
cd autoupgrade
Step 10
Create config file.
vi 19c.cfg
19c.cfg config file
#
global.autoupg_log_dir=/u01/home/oracle/autoupgrade
upg1.source_home=/u01/app/oracle/product/18.0.0/dbhome_1
upg1.target_home=/u01/app/oracle/product/19.3.0/dbhome_2
upg1.sid=orcl
upg1.start_time=now
upg1.log_dir=/u01/home/oracle/autoupgrade/orcl
upg1.upgrade_node=localhost
Step 11
Analyze the database for any errors.
/u01/app/oracle/product/19.3.0/dbhome_1/jdk/bin/java -jar /u01/app/oracle/product/19.3.0/dbhome_1/rdbms/admin/autoupgrade.jar -config 19c.cfg -mode analyze
Step 12
Check the log for any errors and correct them.
Step 13
If there are no errors you can now upgrade the database.
/u01/app/oracle/product/19.3.0/dbhome_1/jdk/bin/java -jar /u01/app/oracle/product/19.3.0/dbhome_1/rdbms/admin/autoupgrade.jar -config 19c.cfg -mode deploy
Step 14
Set the compatible parameter.
alter system set compatible=’19.0.0′ scope=spfile;
Bounce your database for the parameter to take effect.
Step 15
At this time you may want to apply the latest patchset.
Step 16
If you are using an RMAN catalog you will have to upgrade the catalog by signing into rman and connecting to the catalog. Then, from the rman prompt, run the upgrade catalog.
Contact us for questions.