A Troubleshooting

This appendix contains information on troubleshooting.

This chapter contains these topics:

Images Displaying Incorrectly in Oracle Application Express
Online Help Not Working

A.1 Images Displaying Incorrectly in Oracle Application Express

Review this section if you configured Oracle HTTP Server with mod_plsql instead of the XDB HTTP Server with the embedded PL/SQL gateway.

In "Configuring Oracle HTTP Server with mod_plsql", you added an alias entry that points to the file system path where you copied the images directory. If images in Oracle Application Express do not display correctly, you may have more than one definition of the /i/ alias. To address this issue:

If possible, rename the first instance of /i/ to a different alias name.
Alternatively, copy the images from the ORACLE_BASE\ORACLE_HOME\apex\images directory to the directory defined by the first /i/ alias.

A.2 Online Help Not Working

If users are accessing Oracle Application Express through a Virtual Host, then online help will not work. Consider the following example in which:

The hostname of the Oracle HTTP Server where the Oracle Application Express DAD resides is internal.server.com and the port is 7777.
Users access Oracle Application Express through a Virtual Host. In their Web browsers, users see external.server.com and port 80.

In this example, Oracle Application Express online help will not work if the users cannot access internal.server.com. To resolve this issue, add the following lines to the Oracle Application Express Database Access Descriptor (DAD) to override the CGI environment variables SERVER_NAME and SERVER_PORT:

PlsqlCGIEnvironmentList SERVER_NAME=external.server.com
PlsqlCGIEnvironmentList SERVER_PORT=80