Oracle DB 18.104.22.168.0
Oracle HTTP 22.214.171.124.0
I'm trying to move away from the Apex Listener to the Oracle HTTP server with mod_plsql and I'm having an image problem after installing Oracle HTTP, copying the images and configuring the dads.conf.
When I navigate to the new APEX URL (http://apexdev:7777/pls/apex/apex_admin) I get a blank screen. I've verified the images are in the path specified in the dads.conf. I also verified Oracle HTTP server was working by navigating to the Oracle Fusion Middleware frontend page successfully (http://apexdev:7777)
The logs for Oracle HTTP (ohs1.log) clearly show that the problem is its looking in the wrong location for the images.
Since the dads.conf file is pointing to the correct location how do I go about fixing this?
Is there reference to this incorrect /i/ path in the db? How would I find it and remove it?
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
-- 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 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.