Upgrade Database from Oracle 11gR2 to Oracle 18c

    Mar 1, 2018 7:38:45 AM by Skant Gupta

    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

    1-1

    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: 

    Joel Perez’s LinkedIn: Joel Perez’s Profile

    Anuradha’s LinkedIn: Anuradha’s Profile

    LinkedIn Group: Oracle Cloud DBAAS

    Facebook Page: OracleHelp

    Tags: Oracle

    Skant Gupta

    Written by Skant Gupta

    Skant Gupta is an Oracle Certified Cloud Professional in Oracle Database 12c, an Oracle Certified Expert in Oracle Real Application Clusters (Oracle RAC) in Oracle Database 11g and 12c, and an Oracle Exadata Certified and an Oracle Certified Professional in Oracle Database 10g, 11g, and 12c. He works at Vodafone Technology in the UK and formerly worked as a senior DBA at Etisalat in Dubai. He has six years of experience with various Oracle technologies, focusing mainly on Cloud, database, and high availability solutions, Oracle WebLogic Suite, Oracle Exadata and Oracle GoldenGate. He has presented at several Oracle user groups worldwide, most recently in the US, the United Arab Emirates, and the India. He is also Technical Writer on http://www.oracle.com/technetwork/es/articles/index.html and http://www.oracle.com/technetwork/pt/articles/index.html with more than 30 article published in Oracle Technical Network.