This discussion is archived
3 Replies Latest reply: Apr 5, 2013 9:55 AM by clcarter RSS

DOES EXPRESS EDITION SUPPORT APEX ?

1001045 Newbie
Currently Being Moderated
Hi

I need to learn how APEX works

as I don't havve a license for an oracle DB
does the express edition support APEX ?

Thanks
Regards
  • 1. Re: DOES EXPRESS EDITION SUPPORT APEX ?
    clcarter Expert
    Currently Being Moderated
    Yes, 11g Express includes an Apex installation.

    The caveat, the host must have the network client setup configured correctly for Apex to work, which is the pinch point for most folks. For Windows, the user running the installer must be in the local Administrators group as well. As mentioned in the install prerequisites at http://docs.oracle.com/cd/E17781_01/install.112/e18803/toc.htm

    A successful XE installation, with a running database and listener, as well as the proper services setup (windows) and all appears happy. Except the apex service does not start due to maybe an invalid %HOSTNAME% setting or something similar.

    But there is in easy fix or workaround to that problem. Stop the listener and rename the ...network/admin/listener.ora file, or make the correct HOST= adjustment in listener.ora and start the listener. Done. ;)
  • 2. Re: DOES EXPRESS EDITION SUPPORT APEX ?
    1001045 Newbie
    Currently Being Moderated
    Thank you

    well, let's summarize and go ahead by steps

    I have installed the Express Database 11 and I can connect it with sql developper... it wors fine

    NOW
    installing the Express Database 11, Apex is already installed inside. Right ?

    well
    Now how can I connect my browser to the application express
    do I need to install a connector ?!? right ? a web listener ? what else ..

    please help to get it started

    Thanks
  • 3. Re: DOES EXPRESS EDITION SUPPORT APEX ?
    clcarter Expert
    Currently Being Moderated
    how can I connect my browser
    Type http://127.0.0.1:8080/apex/f?p=4950 into your browser address bar. That's it, if the apex service is running.

    Installer also creates a shortcut to the Apex page. Sometimes it doesn't get created exactly right, so I find making a few keystrokes much easier than digging around in a GUI for what ever I'm looking for. But then, maybe that's just me ... ;)

    If you get a page error the installer may not have set the listener configuration exactly correct. There are numerous posts here on that particular problem.

    Verify the database is running. Verify the listener is running. Verify that a `lsnrctl status` command has an endpoint with the ...presentation http ... port=8080 line. If you don't have all three apex web pages will not work.

Legend

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