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.
zantac levitra interaction alimenti tipo viagra cialis union dale here sample high school scholarship essays product development coordinator cover letter masters dissertation funding how to write a kickass thesis follow link watch sister of the bride wedding speech https://www.aestheticscienceinstitute.edu/medical/blue-viagra-drink-prank/100/ https://behavior.org/typer/charles-darwin-primary-homework-help/31/ should your thesis statement be the last sentence go to site https://home.freshwater.uwm.edu/termpaper/a-level-chemistry-coursework-ideas/7/ wedding minister speech qual sao os efeitos do viagra research paper quotes citations enter aborto incompleto cytotec viagra india cheap http://calliope.ualr.edu/essay.php?app=empire-movie-reviews https://earthwiseradio.org/editing/love-our-environment-essay/8/ what is your philosophy of life essay https://dsaj.org/buyingmg/contact-lily-about-cialis/200/ source escrow resume samples https://campuschildcare-old.wm.edu/thinking/dissertation-kannada-meaning/10/ cialis super active bestellen click here https://pacoimabeautiful.org/erectionrx/sildenafil-for-the-treatment-of-pulmonary-hypertension/33/ 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.