Apex

How to upgrade Oracle Apex 5.1 to 18.1

Please do the following steps:

I assume you have already installed Apex 5.1 in the Apache Tomcat environment

In this up gradation steps you only need to fresh install of Oracle Apex. It does not require to Re-install/Re-configure of REST data service, Database, Apache tomcat..etc.

Steps:

  • Download Oracle Apex (Apex 18.1) from apex.oracle.com site
  • Unzip download file
  • Open a command prompt window and get into the unzipped directory
  • F:\ORACLE\apex_18.1\apex
  • In your case, the unzipped directory path may be different, please replace your own directory path.
  • Now login to the database using SYS with SYSDBA Privilege
  • Run the following commands
  • Before executing the below command you have to backup/export your existing Apex applications which you need to import after Apex installation/up gradation. You don’t need to backup database schema and its objects because it will not affect to them.

  • If you are not sure about your existing Apex Version, you can execute this command to make sure the current Apex version.

  • After executing the above command (dropping apex schema) run the apex installation script as shown below
  • In the below command, please be noted here apex_dev_ts  is my local tablespace name, replace your own tablespace name in this case.

  • The above execution may take 5 to 10 mins to complete
  • Now execute the below script to Reset Admin password of Apex

  • Enter Admin User Name – default Admin
  • Enter Email address of Admin user
  • Enter Password
  • After changing admin password, now copy the Image folder from the unziped Apex file (…\apex_18.1\apex\images) and paste into the Apache Tomcat WebApps Image directory ( C:\Apache Software Foundation\Tomcat 9.0\webapps\i)
  • In my case i is the virtual directory inside the directory C:\Apache Software Foundation\Tomcat 9.0\webapps\i, in your case the directory and folder name may be different.
  • Now Stop TomCat Service  and Start Again TomCat Service
  • Now login to TomCat Manager

  • Tomcat manger url may be different in your case, please replace your own port, host/ip…etc
  • After launching TomCat Manager locate Commands section for Oracle Application Express Listener
  • Now click the ‘stop‘ button to stop the service
  • Now click the ‘start‘ button to start the service
  • Now launch your application workspace url and enjoy new look of Apex 18.1

  • Create New Workspace and import your exported Applications

Thank You

 

 

 

3 Comments

  1. Dear kamal,
    thank you for your very well explained column, I wanted to ask you if having installed jasperreintegration I have to add some changes to make it work.
    Thank you.

    Dario

    Darioi Gnani

Comments are closed.