Oracle usually releases new major software version every 2 years but for the last few years Oracle has started investing significantly on Oracle Apex and has come up with a new version each year. Not only the new versions of Apex are now coming faster but they are also now more feature packed and use some of the latest development and web principles. With the cloud focus of Oracle, the direction would be to invest significantly in the most cloud ready tool in Oracle’s bag of software and solutions.
In the past software upgrades have been a strategic yet painful process and before you make a decision to upgrade it is always desirable to understand the risks, challenges and benefits out of the upgrade. Before you take on the journey let me summarize that upgrading Oracle Apex is very straight forward and usually the feature benefits outweighs the upgrade investment.
To make a decision to upgrade it is good idea to understand the steps involved in an upgrade.
Oracle upgrade involves two steps process, the first is the technology upgrade and the second is the application upgrade or adjustments.
We will keep the upgrade process independent of version so that the same steps apply regardless of the version to or from you are upgrading.
The first step is to go through the release notes and understand if a database upgrade is necessary to upgrade to the latest version of Oracle Apex. The release notes and all other documents are usually available on Oracle Apex site http://docs.oracle.com/database/apex-5.1/
If Oracle database upgrade is needed than an Oracle DBA is required to participate and upgrade the Oracle database before Oracle Apex can be upgraded. Based on your company’s policy the DBA will either be upgrading your development environment or he might provide you a completely new Oracle database environment that is upgraded to the version your Oracle Apex requires. You can download the upgrade guide for Oracle database version 12c from Oracle’s site here https://docs.oracle.com/database/121/UPGRD/title.htm
Upgrading Oracle Apex is a straight forward process, you will need the DBA level or SYS user access to login to the database.
The overview of steps involved are
For a detailed upgrade Download the Oracle Apex Installation Guide from http://docs.oracle.com/database/apex-5.1/HTMIG/toc.htmand follow the step as suitable for your specific environment.
Oracle Apex upgrade process is designed to not change any underlying components required to run your existing applications, the changes to the existing applications are only required to make use of the new features of the version you have upgraded to.
Once the application technical upgrade is complete it is usually a good idea to run a the Integrity check advisor provided by Oracle to make sure all applications are going to work properly in the new version. You can read more about the tool here http://docs.oracle.com/database/apex-5.1/HTMDB/running-advisor-to-check-application-integrity.htm#HTMDB28537
Once the application integrity has been validated it is now a developers job to discuss the changes required to implement new features in the application with a business user. The implementation of new features might require some page, template or code level fitment or adjustment. It is better to run this as a new project and release the features after proper testing in a Test environment.
Upgrading Oracle Apex is quick and low risk as compared to other software or enterprise tools but it surely requires careful execution. Abacasys Oracle Apex team of experienced Apex DBAs, Certified Developers and UI designers can help you with the complete process in a cost effective and timely manner.
Reach us for a quote on your Oracle Apex Upgrade, we cover any combination the following upgrade services