techxplore blog
11 Mar

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.

7 Responses to “Application Express 3.1 Upgrade Missing Image And Javascript Error Solution”

  1. Surendra Says:

    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.

  2. Drew Poggemann Says:

    Thank 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

  3. David Sumner Says:

    Thank you 1000 times over! After spending 1/2 a day chasing my tail, this worked like a charm.

  4. Duane Says:

    I wasted a whole night on this crap. Thanks a million for publishing this info!!!!

    Now I can go to sleep :-)

  5. gogo Says:

    thanks a lot

  6. Vineet Says:

    I 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.
    and Apex3.1

  7. tony Says:

    @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.

Leave a Reply