Here I would be discussing how to upgrade Oracle 11gR2 (11.2.0.4) database to Oracle 19c (19.2.0.0.0) on the same server. This upgrade process was done on Oracle Linux 7.6 (x86_64). I used DBUA (Database Upgrade Assistant) to perform this upgrade. DBUA is also a recommended way to perform the upgrade as it would automate almost everything for you. You should be able to use the same method to upgrade
Make sure the database is started and run the database upgrade assistant with 19c home.
[oracle@oracle19c ~]$ export ORACLE_HOME=/u01/app/oracle/product/19.0.0/dbhome_1 [oracle@oracle19c ~]$ export PATH=$ORACLE_HOME/bin:$PATH [oracle@oracle19c ~]$ dbua
Initiate DBUA, click Next Initiate DBUA
Select 11g database “DB19UPG” is already selected,
Enter SYS username :SYS
Password: ***
click Next
During Prerequisite Checks, there are some warning as shown below
to get rid of from the warnings. Steps are below
Below is the information for Post Upgrade Recommendations. We can make it a note on that and click Next
Check the operation performs the upgrade and click Next.
If upgrade failure happened then we must have Rman backup or Flashback Point and click Next
Select the running Listener or If you want to create new listener configuration and click next.
To setup OEM in 19c, in my case, I am not using OEM cloud
Click Finish to start the upgrade process
Now we can monitor the progress.
Once done, you can click on “Show Results” to see a detailed output of the upgrade process.
Now we are going to perform Post Upgrade Steps.
[oracle@oracle19c DB19UPG]$ sqlplus / as sysdba SQL*Plus: Release 19.0.0.0.0 - Production on Tue Feb 19 12:54:36 2019 Version 19.2.0.0.0 Copyright (c) 1982, 2018, Oracle. All rights reserved. Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.2.0.0.0 SQL> @/u01/app/oracle/cfgtoollogs/dbua/upgrade2019-02-19_10-50-02AM/DB19UPG/postupgrade_fixups.sql Session altered. PL/SQL procedure successfully completed. PL/SQL procedure successfully completed. PL/SQL procedure successfully completed. Package created. No errors.
Now connect to upgrade database through sqlplus
[oracle@oracle19c DB19UPG]$ sqlplus / as sysdba SQL*Plus: Release 19.0.0.0.0 - Production on Tue Feb 19 12:53:21 2019 Version 19.2.0.0.0 Copyright (c) 1982, 2018, Oracle. All rights reserved. Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.2.0.0.0 SQL> select name,open_mode,version from v$database,v$instance; NAME OPEN_MODE VERSION --------- -------------------- ----------------- DB19UPG READ WRITE 19.0.0.0.0 SQL>
Cheers!! Database has been successfully upgraded to 19c.
Stay tuned for more articles on Oracle 19c
Thank you for giving your valuable time to read the above information.
If you want to be updated with all our articles send us the Invitation or Follow us:
Skant Gupta’s LinkedIn: www.linkedin.com/in/skantali/
Joel Perez’s LinkedIn: Joel Perez’s Profile
Anuradha’s LinkedIn: Anuradha’s Profile
LinkedIn Group: Oracle Cloud DBAAS
Facebook Page: OracleHelp
