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 11.2.0.4 database on other OS platforms.

Make sure the database is started and run the database upgrade assistant with 19c home.

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.

Now connect to upgrade database through sqlplus

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

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.