Application Express 3.1 Upgrade Missing Image And Javascript Error Solution
The cause for missing image and JavaScript error as written before regarding Oracle Application Express Missing Images And JavaScript Error was the wrong image prefix.
http://127.0.0.1:8080/apex/TEMPjavascript/apex_ns_3_1.js
http://127.0.0.1:8080/apex/TEMPjavascript/apex_get_3_1.js
http://127.0.0.1:8080/apex/TEMPjavascript/apex_get_3_1.js
http://127.0.0.1:8080/apex/TEMPjavascript/apex_builder.js
http://127.0.0.1:8080/apex/TEMPcss/apex_3_1.css
http://127.0.0.1:8080/apex/TEMPcss/apex_builder_3_1.css
http://127.0.0.1:8080/apex/TEMPhtmldb/apex_logo.gif
The correct installation should have “/i/” instead of “/apex/TEMP”.
http://127.0.0.1:8080/i/javascript/apex_ns_3_1.js
http://127.0.0.1:8080/i/javascript/apex_get_3_1.js
http://127.0.0.1:8080/i/javascript/apex_get_3_1.js
http://127.0.0.1:8080/i/javascript/apex_builder.js
http://127.0.0.1:8080/i/css/apex_3_1.css
http://127.0.0.1:8080/i/css/apex_builder_3_1.css
http://127.0.0.1:8080/i/htmldb/apex_logo.gif
Thus to correct this problem the prefix image should be corrected. It’s good that Oracle Application Express comes with Useful Oracle APEX tools just to do that.
C:\\oraclexe\\apex\\utilities>sqlplus /nolog
SQL*Plus: Release 10.2.0.1.0 - Production on Wed Mar 12 15:32:09 2008
Copyright (c) 1982, 2005, Oracle. All rights reserved.
SQL> connect sys/ as sysdba
Enter password:
Connected.
SQL> @reset_image_prefix.sql
Enter the Application Express image prefix [/i/]
...Changing Application Express image prefix
NEW
---
/i/
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
Session altered.
...Recreate APEX global
PL/SQL procedure successfully completed.
...Update image prefix for all internal Application Express applications
PL/SQL procedure successfully completed.
...Recompiling the Application Express schema
PL/SQL procedure successfully completed.
Image Prefix update complete
Disconnected from Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production
C:\\oraclexe\\apex\\utilities>
After using reset_image_prefix.sql to update the image prefix the images that are missing now shows. Trying to login the administrator or developer page also now works. If you still experience some problem maybe the cause is different one. Kindly drop a message if you have any issues with this.






Posted
on
Tuesday, March 11th, 2008 at 11:14 pm under

I have installed new installation of Oracle Apex 3.1, the Oracle version is 10g with Release 2 and the installation steps worked ok.
However when trying to login to the Apex Administration Services(http://hostname:port/pls/apex/apex_admin) the login page doesn’t appears.
I got “Error on Page”
When I see the log file(Apache\logs) I got this file name : error_log.1210550400.
logs I get the following errors:-
apache/htdocs/i/javascript/apex_ns_3_1.js
apache/htdocs/i/javascript/apex_3_1.js
apache/htdocs/i/javascript/apex_get_3_1.js
apache/htdocs/i/javascript/apex_builder.js
apache/htdocs/i/css/apex_3_1.css
apache/htdocs/i/css/apex_builder_3_1.css
apache/htdocs/i/css/apex_ie_3_1.css
apache/htdocs/i/css/apex_builder_ie_3_1.css
apache/htdocs/i/htmldb/apex_logo.gif
Kindly help me to sort out this problem.
Thanks in Advance.
May 12th, 2008 at 7:56 pmThank you! Your solution worked perfectly! What, does Oracle expect people will have issues so they build a script to fix their install problem?
Thanks again…
Drew
June 9th, 2008 at 8:46 amThank you 1000 times over! After spending 1/2 a day chasing my tail, this worked like a charm.
August 10th, 2008 at 11:52 pmI wasted a whole night on this crap. Thanks a million for publishing this info!!!!
Now I can go to sleep
September 18th, 2008 at 7:15 pmthanks a lot
October 20th, 2008 at 12:31 amI did same but still unable to login . although images are appeared now. There is some java script missing.
Please help me how to resolve . I have Oracle 10g XE.
November 3rd, 2008 at 4:32 pmand Apex3.1
@Vineet,
You can use apxxepwd.sql script to set the ADMIN password of APEX. Visit my post on this one: http://www.techxplore.net/2007/12/16/resetting-application-express-301-admin-password/
Apex 3.1 should have a similar script.
November 7th, 2008 at 5:49 pm