Here I would be discussing how to upgrade Oracle 11gR2 ( database to Oracle 18c( on the same server. This upgrade process was done on Linux 7 (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 database on other OS platforms.

To know more about direct upgrades to 18c: Flow Chart and Upgrade Paths for Oracle Database 18c

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

Initiate DBUA, click Next Initiate DBUA

My 11g database “UPG18c” 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 18c, in my ca, e 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 18c.

Stay tuned for more articles on Oracle 18c 

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:

Joel Perez’s LinkedIn: Joel Perez’s Profile

Anuradha’s LinkedIn: Anuradha’s Profile

LinkedIn Group: Oracle Cloud DBAAS

Facebook Page: OracleHelp


  1. Pingback: Upgrade Database from Oracle 11gR2 to Oracle 18c - Oracle Blog - Oracle - Toad World

Leave a Reply