This discussion is archived
4 Replies Latest reply: Feb 22, 2013 11:52 AM by TimSt.H. RSS

Apex Listener Setup Issues

987765 Newbie
Currently Being Moderated
Hi,
I'm hoping someone can help with setting up the listener for my APEX installation.

I have APEX 4.2 running on an 11g database, and can access the application directly, no problems.

I've set up the listener running standalone on my windows machine, I get the following results.

Go to http://localhost:8085/apex/
Browser goes to http://localhost:8085/apex/f?p=4550:1:5614682097186 and displays a blank page

Go to http://localhost:8085/apex/f?p=100
Browser goes to http://localhost:8085/apex/f?p=100:LOGIN:14764949035472 which is our application's login page.
The page is displayed, but it looks like the theme is not applied, white background etc, but it does contain the logo images which are defined on the page.
The login button/link does nothing, and I can't get any further.
Firebug reports the following error when attempting to login
ReferenceError: apex is not defined
The HTML for the button is as follows:
<span>OK</span>


So, what I need to understand is:
1: Why is the default URL going to somewhere that doesn't load a page?
2: Why, when I manually go to an actual page does it load without a theme?
3: Why can't I log in? I'm suspecting a missing javascript file, probably related to question 2 here.

Is there any way I can enable some more logging on the listener to help try and figure this out.

Many Thanks
Jas
  • 1. Re: Apex Listener Setup Issues
    Udo Guru
    Currently Being Moderated
    Hello, and welcome to the OTN forums,
    Browser goes to http://localhost:8085/apex/f?p=4550:1:5614682097186 and displays a blank page
    That's usually the case when you didn't configure your APEX "images" (static contents) properly...
    Did you setup your APEX Listener to use the images that where provided by the APEX installation package for your APEX 4.2?
    1: Why is the default URL going to somewhere that doesn't load a page?
    The page is usually loaded, but you don't get usable content because your static contents can't be served as needed, so you miss all css, js, images and stuff needed to render your page. Take a look at the page source (contents) - you'll probably see more than you have on your screen.
    2: Why, when I manually go to an actual page does it load without a theme?
    3: Why can't I log in? I'm suspecting a missing javascript file, probably related to question 2 here.
    It is related: It's because the static contents for the theme is not there. (see above)
    Is there any way I can enable some more logging on the listener to help try and figure this out.
    I guess you won't need to.

    -Udo
  • 2. Re: Apex Listener Setup Issues
    987765 Newbie
    Currently Being Moderated
    Hi,
    Thanks for the detailed reply.

    Can you tell me how I can get the static content from the database server?

    We have some custom themes used in our application, so I'm assuming the best way to get these is to get the current set of files from the server.

    I've tried getting the directory $ORACLE_HOME/apex/images and passing the path to a local copy of this directory to the standalone listener, but I get the same result.

    Many Thanks
    Jas
  • 3. Re: Apex Listener Setup Issues
    BillC Newbie
    Currently Being Moderated
    Are you missing this step?
         
    .) Move the images:
              Still connected as SYS/SYSDBA at /tmp
              Run apex_epg_config.sql ( SYS as SYSDBA )

              SQL> @apex_epg_config.sql /tmp
  • 4. Re: Apex Listener Setup Issues
    TimSt.H. Explorer
    Currently Being Moderated
    >
    Can you tell me how I can get the static content from the database server?

    We have some custom themes used in our application, so I'm assuming the best way to get these is to get the current set of files from the server.

    I've tried getting the directory $ORACLE_HOME/apex/images and passing the path to a local copy of this directory to the standalone listener, but I get the same result.
    Your question can be answered easier if you knew where your current web "static files" are located.

    If you are currently using EPG (embedded PLSQL gateway) - the apex files can be loaded into the DB with the script BillC.
    If your "CUSTOM THEMES" had static files you (or your team) personally uploaded, to the EPG (XMLDB) static files, you can get them back, but may also have them off line.

    More likely - you just need the IMAGES directory from the APEX installation (not the apex listener).

    Assumption - you are trying to run the listener in STAND ALONE  (test mode).
    If you try to use the $ORACLE_HOME/apex/images syntax, my guess would be that it won't understand the $ORACLE_HOME substitution at runtime. Use the whole path.


    Regards
    -- Tim St.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points