Upgrade Database from Oracle 11gR2 to Oracle 18c

Here I would be discussing how to upgrade Oracle 11gR2 (11.2.0.4) database to Oracle 18c(18.0.0.0.0) 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 11.2.0.4 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.

[oracle@localhost ~]$ export ORACLE_HOME=/u01/app/oracle/product/18.0.0.0/db_1
[oracle@localhost ~]$ export PATH=$ORACLE_HOME/bin:$ORACLE_HOME/OPatch:$PATH:.
[oracle@localhost ~]$ dbua

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

• Remove EM
• Remove OLAP
• Upgrade APEX
• Gather Stats for fixed objects

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.

[oracle@localhost ~]$ sqlplus / as sysdba

SQL*Plus: Release 18.0.0.0.0 Production on Mon Feb 26 13:11:10 2018
Version 18.1.0.0.0

Copyright (c) 1982, 2017, Oracle. All rights reserved.

SQL> @/u01/app/oracle/cfgtoollogs/dbua/upgrade2018-02-26_01-40-53AM/UPG18C/postupgrade_fixups.sql

Session altered.

PL/SQL procedure successfully completed.

PL/SQL procedure successfully completed.

Package created.

Session altered.

SQL>

Now connect to upgrade database through sqlplus

[oracle@localhost ~]$ export ORACLE_HOME=/u01/app/oracle/product/18.0.0.0/db_1
[oracle@localhost ~]$ export PATH=$ORACLE_HOME/bin:$ORACLE_HOME/OPatch:$PATH:.
[oracle@localhost ~]$ sqlplus / as sysdba

SQL*Plus: Release 18.0.0.0.0 Production on Mon Feb 26 13:11:10 2018
Version 18.1.0.0.0

Copyright (c) 1982, 2017, Oracle. All rights reserved.

Connected to:
Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production
Version 18.1.0.0.0

SQL> select name,open_mode,version from v$database,v$instance;

NAME       OPEN_MODE           VERSION
--------- -------------------- --------------
UPG18C    READ WRITE           18.1.0.0.0

SQL>

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: 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