1 Reply Latest reply: Feb 15, 2013 9:56 PM by Udo RSS

    How to start APEX Listener on RAC One Node Cluster

    user480768
      We currently have Oracle 11g R2, RAC One Node Enterprise cluster installed on two Windows 2008 R2 servers, the APEX_030200 schema came with the Oracle Server application. When I run following sql statement:
      select DBMS_XDB.getHTTPPort from dual; to check if APEX listener is running the gethttpport return 0. How do I enable APEX on my RAC One node cluster? Thanks for your reply.

      Kevin
        • 1. Re: How to start APEX Listener on RAC One Node Cluster
          Udo
          Hello Kevin,
          When I run following sql statement:
          select DBMS_XDB.getHTTPPort from dual;
          to check if APEX listener is running the gethttpport return 0.
          This command queries the port of the database internal XDB HTTP Server. The return value 0 means it is disabled.
          If you want to use APEX Listener, you have to install it according to the corresponding documentation. See
          - [url http://docs.oracle.com/cd/E37097_01/doc/install.42/e35123/otn_install.htm#BABJJAGF]Downloading from OTN and Configuring Oracle Application Express Listener in APEX 4.2 Install Guide on how to configure your APEX properly.
          - [url http://docs.oracle.com/cd/E37099_01/doc/doc.20/e25066/install.htm#CHDIDHCD]APEX Listener 2 Installation Guide on how to install and configure APEX Listener 2.

          Note that APEX Listener support starts with APEX 4.0. It also works with previous APEX versions such as your 3.2, but is not officially supported (and not documented). I'd recommend to update to the recent APEX release anyway, as it offers several new features, includes several bug fixes, ...
          Also note that you can't configure RESTful services for APEX Listener 2 on APEX releases prior to 4.1.

          -Udo