Apex Listener 2 Displays Blank Page – is a bug fixed by patch # 16760897

I was attempting to implement the standalone version of Oracle Apex Listener 2 – and getting blank pages.

Prior to this I was successfully using EPG ( embedded PL/SQL gatway) to access Apex but changed to take advantage of PDF printing in APEX Listener 2.

Problem was page kept coming up blank – and all the forums, google, metalink etc. tried to tell me it was a problem with not pointing to the images.

Well I knew I was pointing to images correctly.  Here is the command to explicitly start Apex Listener 2 and point at an images directory in standalone mode:

java -jar apex.war standalone –apex-images D:\app\Apex422Setup\apex\images

After a couple days of googling, and using metalink (this fix was not in metalink …) I finally I found a forum that got to the source of the problem (http://localhost:8080/apex displaying a blank page) – an Oracle / Apex 4.2.2.0.11 specific bug.

Bug # is 16760897.  Fix is in patch # p16760897_422_Generic.zip.  The problem probably rears it’s ugly head no matter how you deploy the listener, standalone, glassfish, and Weblogic… I believe.

Also you can get Apex 4.2.2 to display the login page without the patch by using the following form of the url:

http://localhost:8080/apex/f?p=4550:1

Once you hit this URL the problem goes away until the cache is cleared – only a temporary fix. Or you apply the patch.

SQL> select * from apex_release;

VERSION_NO
——————————————————————————–
API_COMPATIBILITY
——————————————————————————–
PATCH_APPLIED
——————————————————————————–
4.2.2.00.11

Hope this helps, Mike

Advertisements

4 comments

  1. Thanks very much Mike, really good fix.
    I’ve been going around in circles for hours/days with this and thankfully this article popped from a google search and sorted my problem with the blank page.
    Dave.C – Oracle Developer.

  2. Helpful tip for many people, but i can get that patch (have no account on My Oracle Support). Is it possible to find it on some other place on web? I just cant find it.
    I’d appreciate any help to get to it. Thank you in advance!
    Cheers!

    • email me at mike@dbdude.net, you mail be able to find the patch just by signing up for an OTN account. Go to otn.oracle.com. In the mean time, I don’t want to make a regular practice of giving out Oracle patches… but email me and I’ll do what I can to help you obtain it. Thx Mike


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s