1 minutes readUPGRADE ORACLE APEX FROM 5.0.X TO 18.1

Reader Mode
Current Setup :

Apex Version : Oracle Apex 5.0
Webserver : ORDS Running on Apache Tomcat 9
DB Version : Oracle 12.2 

  • Step 1: Download Apex 18.1 from Oracle Website
  • Step 2: Rename the old apex directory in ORACLE_HOME

cd $ORACLE_HOME
mv apex/ apex_old/

  • Step 3: Unzip new downloaded apex software and go to the new Apex Directory and run the Upgrade

cd apex/
SQL> @apexins.sql apex apex temp /i/

  • If you are using Embedded PL/SQL Gateway to access Apex application, perform below steps: 

Load Images Directory for Apex.

@apex_epg_config.sql ORACLE_HOME

@apex_epg_config.sql /u01/app/oracle/product/12.2.0/dbhome_1

  • If you are using ORDS to access Apex application, perform below steps: 

As tomcat user
cd /u01/app/oracle/product/12.2.0/dbhome_1/apex/images/
cp -R * $CATALINA_HOME/webapps/i
sh $CATALINA_HOME/bin/shutdown.sh
sh $CATALINA_HOME/bin/startup.sh

  • Step 4: verify Upgrade 

SQL> select VERSION_NO from apex_release;
VERSION_NO
——————————————————————————–
18.1.0.00.45

Related Articles

Responses

Your email address will not be published. Required fields are marked *

  1. Literally a very helpful article, I think every internet user should read this blog post. and make your business too much smart. if you wanna take over smart technical services then Onlive Server gives you excellent guidance to choosing the best domain name online.
    Book Domain Name Online

  2. There are I see many tips for building a brand identity. so if you want to look helpful tips and strategy then we could do help you to book domain name online from onlive server here you can get a unique domain name and secure hosting services.
    Book Domain Name Online

Password Reset
Please enter your e-mail address. You will receive a new password via e-mail.