Fully freeware APEX environment III: The APEX listener

This is post 3 in my series about a fully freeware CentOS Apex environment

Configure the APEX Listener

Your listener is deployed, but not yet configured. Go to http://localhost:8080/apex/listenerConfigure

We must set parameters in three tabs:

  1. Connection
    • Username: apex_public_user
    • Password: the password as set earlier for this user
    • Connection Type: Basic
    • Hostname: localhost
    • Port: 1521
    • SID: XE
  2. Security
    • Database Validation Function: wwv_flow_epg_include_modules.authorize
  3. Caching
    • Procedure Names: wwv_flow_file*
    • Maximum entries: 500

Click the “Apply” button after you made all changes. The page remembers the settings when you switch between tabs.

As you see I’m configuring from my Windows host towards the Linux guest (running VirtualBox).

Apex is now ready. Have a look at these links:

Creating a workspace:

You can create a workspace by going to : http://localhost:8080/apex

The ADMIN@INTERNAL password is the same as what you used for the SYS and SYSTEM “users” when installing Oracle XE.

That’s it.

11 comments for “Fully freeware APEX environment III: The APEX listener

  1. 24 November 2012 at 09:25

    Hi guys! I’ll do appreciate You if You explain, why links below results to 404, while apex 4.2 itself http://localhost:8080/apex/ works correctly?

    http://localhost:8080/apex/listenerAdmin
    http://localhost:8080/apex/listenerStatus
    http://localhost:8080/apex/listenerConfigure

    And guys, would You explain about /i/. I’ve read in Apex 4.2 documentaion http://docs.oracle.com/cd/E37099_01/doc/doc.20/e25066/install.htm about creating i.war. It seems that i.war after deploying must be analogue of an alias /i/… It doesn’t work for TomCat also. But the only approach that works is copyng /images into /webapps/ROOT/i

    How i can change that place?

    • Richard Martens
      29 November 2012 at 17:50

      I believe you’re talking about the apex listener?

      • 30 November 2012 at 03:14

        Oh, thank You for Your attention! Sure, a’m about Listener installed as TomCat servlet apex.war and accessing APEX by means of that. As i understand it’s a topic of Your article. I’m not experienced with TomCat and servlets…. and java…. well and in English also… ;) , sorry for any misunderstanding.

        • Richard Martens
          30 November 2012 at 13:43

          This manual covers the Listener 1.0 config

          • 30 November 2012 at 17:04

            Thank You very much anyway. It seems version 2 stays far from 1.

  2. Richard Martens
    6 March 2012 at 15:14

    You’re welcome,

    please return.. :-)

  3. Piotr
    6 March 2012 at 15:06

    Hi,

    Thank you very much for help.
    The problem was that I did not executed step “3.4.5.2 Updating the Images Directory When Upgrading from a Previous Release” @apxldimg.sql

    Regards
    Piotr

  4. Richard Martens
    28 February 2012 at 10:47

    because you’re not seeing images I suspect the /i mapping.

    Then you should check the mapping of your “/I” mapping.

  5. Piotr
    28 February 2012 at 10:41

    Yes, but it did not help.

    I can manage APEX listener
    http://localhost:8080/apex/listenerAdmin
    http://localhost:8080/apex/listenerStatus

    but I cannot log to any application including
    http://localhost:8080/apex/f?p=4950
    http://localhost:8080/apex/f?p=4550

    I do not have the images at login.

    I am not sure if it is a problem with Tomcat.

  6. Piotr
    23 February 2012 at 22:31

    I have upgraded APEX to 4.1.1 and it stopped to work. Any idea why?

Leave a Reply