B Troubleshooting

This appendix contains information on troubleshooting.

Topics:

Oracle Application Express Images Not Displaying

If your login page is missing images or has images that only partially display (for example, links display instead of images), then Oracle Application Express images have not been copied to your application server.

To correct this issue, you must copy Oracle Application Express images to your application server. To learn more see:

Issue 1: Oracle Application Express Images Copied But Still Not Displaying

You have copied the Oracle Application Express images to your application server as described in "Installing Oracle Application Express Listener". However, the images are still not displaying:

Resolution:

  1. Make sure the Oracle Application Express images that you copied to your application server are the same Oracle Application Express version that is installed in your database.

  2. If you upgraded Oracle Application Express, see "Upgrading Oracle Application Express Images".

Issue 2: Images Copied Using a Different Web Application's Context Root

You have copied Oracle Application Express images and used a different Web application's context root other than the default context root (for example, i). The images are not displaying.

Resolution:

  1. Execute reset_image_prefix.sql utility located in Oracle Application Express to change the default image prefix path (for example, /i/ ) to your Web application's context root for the images. Execute this utility using SQL*Plus and connect as SYS. See Oracle Application Express Installation Guide.

    Note:

    The default Web application's context root for the Oracle Application images is i. Oracle recommends to use the default context root, i, for the Oracle Application images unless your business practice requires to change it.

    Example: If you copied Oracle Application Express images using a different context root name (for example, apeximages) instead of using the default context root name (for example, i), then you must specify the different context root in the prefix path (for example, /apeximages/).

    If the images are located in a folder (for example, myfolder) of a context root, then you must specify the context root and the folder in the prefix path, for example:

    /apeximages/myfolder/
    

    The prefix path is case-sensitive and must begin and end with a forward slash. Consider the following example:

    SQL> @<apex directory>\utilities\reset_image_prefix.sql
    
    Enter the Application Express image prefix [/i/] /apeximages/myfolder/
    
    . . .
    Image Prefix update complete
    
    
  2. Next, update the image prefix for each application in Oracle Application Express Application Builder.

    To update the image prefix for each application in Oracle Application Express, release 4.0:

    1. Log in to Oracle Application Express.

    2. On the Workspace home page, click the Application Builder icon.

    3. Select an application.

    4. Click the Edit Application Properties button to the right of the application name.

      The Edit Application page appears.

    5. Under Name, locate Image Prefix.

      By default, this attribute is defined as /i/. Change Image Prefix to the prefix that you specified in the reset_image_prefix.sql utility as described in the previous section. For example:

      /apeximages/myfolder/
      
    6. Click Apply Changes.

    To update the image prefix for each application in Oracle Application Express, release 3.0:

    1. Log in to Oracle Application Express.

    2. On the Workspace home page, click the Application Builder icon.

    3. Select an application.

    4. Click Shared Components.

      The Shared Components page appears.

    5. Under Application, click Application Definition.

      The Edit Definition page appears.

    6. Scroll down to Image Prefix.

      By default, this attribute is defined as /i/. Change Image Prefix to the prefix that you specified in the reset_image_prefix.sql utility as described in the previous section. For example:

      /apeximages/myfolder/
      
    7. Click Apply Changes.

Cannot Log In to Oracle Application Express Listener Administration

If you cannot log in to Oracle Application Express Listener, check if the user is assigned the role Admin or Manager and if the roles are setup properly on your application server. Note that roles, Admin and Manager, are case-sensitive.

To learn more about users and roles see the following sections and review your application server documentation: