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

Go here and read our whole article about it:

http://oracle-help.com/oracle-18c/upgrade-database-oracle-11gr2-oracle-18c/

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