Common errors can occur when upgrading to a different Oracle APEX version. Problems can range from JavaScript errors to images not loading properly. There are guides from various sources to address these, but I thought it would be helpful to create a checklist to have everything in one place.
For this blog, we will start with the easiest fixes first and then work our way to the more time-consuming ones. This is a guide for the recommended install configuration of APEX.
Clear the cache on your web browser and then restart your web browser
Restart the Webserver
Verify the images were copied from the images directory to the application server
- 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
Run reset_images_prefix.sql
- Navigate to /home/oracle/apex/utilities
- Log into sqlplus as sysdba
- Run the command @reset_image_prefix.sql
Run apxldimg.sql
- Navigate to where APEX is installed
- Log into sqlplus as sysdba
- Run the command @apxldimg.sql
Run apex_epg_config.sql
- Change your working directory to the apex directory where you unzipped the Oracle Application Express software.
- Start SQL*Plus and connect to the database where Oracle Application Express is installed as SYS specifying the SYSDBA role:
On Windows
- SYSTEM_DRIVE:\ sqlplus /nolog
- SQL> CONNECT SYS as SYSDBA
- Enter password: SYS_password
On UNIX and Linux
- $ sqlplus /nolog
- SQL> CONNECT SYS as SYSDBA
- Enter password: SYS_password
- Run apex_epg_config.sql passing the file system path to the base directory where the Oracle Application Express software was unzipped:
On Windows
- @apex_epg_config.sql SYSTEM_DRIVE:\TEMP
On UNIX and Linux
- @apex_epg_config.sql /tmp
Run java -jar E:\ords\ords.war validate
Perform a clean install of APEX
Requirements:
- APEX 5x or higher
References:
- https://community.oracle.com/thread/4204556
- https://community.oracle.com/thread/3701540
- https://docs.oracle.com/en/database/oracle/application-express/19.2/htmrn/index.html#HTMRN-GUID-5E3BE2CB-71E8-4B01-AD72-9E8BB4927785
- https://docs.oracle.com/en/database/oracle/application-express/19.2/htmrn/index.html#HTMRN-GUID-E4353E38-3250-4304-8982-F6D4A7887227
- https://docs.oracle.com/en/database/oracle/application-express/19.2/htmrn/index.html#HTMRN-GUID-6265BFAE-380D-4246-BDFC-01D877D6721A
- https://www.oracle.com/tools/downloads/apex-downloads.html
Disclaimer:
We do not take responsibility for any unintended or unwanted consequences in your instance of Oracle, Oracle APEX, or related products as a result of reading our blogs or following our guides. Though the information is fully tested and generally safe to use, our lawyers really have a thing against admitting potential wrongdoing. If it makes you feel any better, one time they made me go out to buy more office equipment. Even though they asked for college ruled notebooks, I bought wide ruled ones on purpose to spite them. When the building was empty, I restocked the notebooks, but then I burned the receipt, took PTO for the next 2 weeks, and turned my phone off. The company stock just happened to dip $0.02 shortly thereafter and didn’t rebound for 10 days. I’m so lucky I wasn’t fired for taking that prank too far.
