This content has been marked as final. Show 9 replies
Perhaps there is a permission issue with the directory that's housing the images.
Another thing, on the blank screen in your browser, right click and select "view page source". You'll see in there what APEX thinks the images directory should be by looking at some of the paths. If it's not /i/, you can either add another alias in dads.conf or I think you need to run the apxldimg.sql script to change it (should be somewhere on the file system with the rest of the apex installation scripts).
I checked and permissions are not the problem. I also looked at the source and its looking for the images in /i/.
The alias for /i/ in my dads.conf is:
Alias /i/ "/opt/oracle11/product/ofm/Oracle_WT1/ohs/images"
The errors in the ohs1.log file are all similar to this:
File does not exist: /opt/oracle11/apexlsnr/apex/imagesapex, referer: http://sand:7777/pls/apex/f?p=4550:10:12093999421665
The path in the above ohs1.log error is the issue. For starters, its missing a / after directory images. If it was looking in /opt/oracle11/apexlsnr/apex/images/ I don't think I'd have this problem because this is the image location configured for my Apex Listener running in standalone mode. Secondly, the path in the ohs error log is not the path referenced in my dads.conf.
I've tried changing my alias in dads.conf file to look in /opt/oracle11/apexlsnr/apex/images/ but because OHS is looking in /opt/oracle11/apexlsnr/apex/images (no backslash) its not working.
I think the solution is to find and remove the invalid /i/ reference that points to the incorrect path /opt/oracle11/apexlsnr/apex/images
I noticed that I messed up the path in my dads.conf file by not including a / after images.
I've corrected the path so it now reads
Alias /i/ "/opt/oracle11/product/ofm/Oracle_WT1/ohs/images/"
I restarted OHS and retested unsuccessfully.
The ohs1.log still shows OHS looking for images in "/opt/oracle11/apexlsnr/apex/images".
Just of few thoughts:
-- Perhaps there is an alias line in http.conf that conflicts
-- After changing the dads.conf did you restart the HTTP server?
-- In the alias line make sure to include the forward slash at the end of the location specified.
I checked the httpd.conf file and there is no reference to /i/ location.
I updated dads.conf and restarted OHS and the DB. I still can't see any images and the image path in the ohs1.log file is still pointing to the incorrect location.
Any other thoughts?
I know you mentioned that you ran the apex listener standalone but maybe at some point it was installed with the weblogic server and there is an deployment causing the conflict. I'm not very familiar with the listener and the weblogic server so I'm just throwing it out there.
I'm sure you've probably already confirmed this stuff, but just to mention it, when you are restarting the oracle http server, double check that ORACLE_HOME is actually set to your OHS path before using opmnctl to restart it. If you are only restarting the HTTP_Server component, perhaps try opmnctl stopall followed by a opmnctl startall.
If you still have no luck, and this is a linux server try grep -r "/i/" * in the directory or perhaps you have to escape those slashes. Try this command from the following directories:
* $ORACLE_HOME/Apache/Apache/conf or $ORACLE_HOME/ohs/conf (depending on the OHS version)
* $ORACLE_HOME/Apache/modplsql/conf or $ORACLE_HOME/ohs/modplsql/conf
Those paths are for OHS 10.1.3.1 and 10.1.3.3, I just noticed you are using a newer version I've not had any experience with.
Edited by: Capt. Egg on 30/04/2013 16:42
I grep'd for pattern /opt/oracle11/apexlsnr/apex/images in all files in the OFM directory and found that there are multiple dads.conf & httpd.conf files.
When stumbling through oracles documentation I configured more than one dads.conf files. While troubleshooting my issue I focused on the wrong dads.conf file.
The path to the correct dads.conf file is
Note: After fixing the correct dads.conf file and restarting OHS I started receiving the following error in the OHS console log.
mod_plsql: DAD /pls/apex disabled => Duplicate DAD
While researching how to set this up I found reference that said to add the following lines to my httpd.conf file
LoadModule plsql_module "/opt/oracle11/product/ofm/Oracle_WT1/ohs/modules/mod_plsql.so"
To fix the Duplicate DAD error I commented out the "include......../*.conf" from my httpd.conf file and restarted OHS.
I don't see any errors in the OHS console log anymore and now I can access my ApEX installation.
Thanks for everyones help.