This discussion is archived
8 Replies Latest reply: Feb 17, 2013 11:36 AM by user480768 RSS

Oracle 11g R2 with APEX

user480768 Newbie
Currently Being Moderated
I have Oracle 11.2.0.3.0, RAC One Node installed on two Windows 2008 R2 64bit servers , Is there anyway to check and test if the APEX has already been installed and running well in my current Oracle cluster? If I need to installed APEX as an standalone application how can I install APEX in my current environment? Thank for your help.

Kevin
  • 1. Re: Oracle 11g R2 with APEX
    Bas de Klerk Pro
    Currently Being Moderated
    Hi,


    to check if apex is installed you could check to see if there are any schema's in the database starting with APEX ( for example APEX_040200 for APEX 4.2 ).

    If there is and you want to check if there is a listener started which you did not configure manually you can execute the query below ( as user sys ) to see if the EPG(apex listener which enables your webinterface) is up and running.
    There can also be other kind of listeners configured but the EPG is the only one which might be installed out of the box together with a database.
    select DBMS_XDB.getHTTPPort from dual;
    if this returns a port APEX should be accessible via this port on the server.
    If you have the APEX versions (via the APEX user you can check the documentation of that version to see what is available where. Check apex.oracle.com for the documentation


    You're asking for a stand alone config in your current config, not sure what you mena by that.
    The easiest way to get APEX standalone ( on your PC ) is to install Oracle XE ( Express Edition ) which includes a XE database with APEX installed and enabled by default.

    Cheers
    Bas
  • 2. Re: Oracle 11g R2 with APEX
    user480768 Newbie
    Currently Being Moderated
    Hi Bas,
    I have APEX_030200 Schema came with My Oracle 11g R2 Enterprise Server installation.

    run select DBMS_XDB.getHTTPPort from dual sql statement, it returns 0 with gethttpport. How do I enable the APEX listerner? Thanks for your reply.

    Kevin
  • 3. Re: Oracle 11g R2 with APEX
    Bas de Klerk Pro
    Currently Being Moderated
    You enable the EPG by running the following statement as user sys :
     exec DBMS_XDB.setHTTPPort(8080);            <- This enables apex on port 8080
    ALTER SYSTEM REGISTER;
    but it would probably be better to upgrade to version 4.2.1 ( or 4.2 ) before starting with APEX since version 4 is way more evolved.
    For the proces of upgrading etc check http://www.oracle.com/technetwork/developer-tools/apex/documentation/index.html
    Installtion guide gives you the scenario's for installing/upgrading etc.

    Regards
    Bas
  • 4. Re: Oracle 11g R2 with APEX
    user480768 Newbie
    Currently Being Moderated
    Do I need to install APEX Listerner java application (http://www.oracle.com/technetwork/developer-tools/apex-listener/downloads/index.html) on the server too?

    Kevin
  • 5. Re: Oracle 11g R2 with APEX
    Bas de Klerk Pro
    Currently Being Moderated
    No, not if you want to test/explore APEX. You can use the EPG instead which is quicker to configure.
    Later on if you want to expand your APEX environment and/or use it in production the apex listener might be a good choice at that time ( you can switch later ).
  • 6. Re: Oracle 11g R2 with APEX
    user480768 Newbie
    Currently Being Moderated
    After launch following two sql statements:

    exec DBMS_XDB.setHTTPPort(8080);
    ALTER SYSTEM REGISTER;

    The port 8080 is alive on one of the RAC cluster servers, in my case (dpuwomdb), so url to http://dpuwomdb:8080, I need to input account and password, I have two APEX schemas (apex_030200 & apex_040200). The apex030200 came with the Oracle Server installation which never be used before. I just installed APEX 4.2 early this morning, so in my situation which APEX schema I need to use? what is the default user account and password to allow me to log into the APEX? Thanks for your help.

    Kevin
  • 7. Re: Oracle 11g R2 with APEX
    Bas de Klerk Pro
    Currently Being Moderated
    After executing dbms_xdb.sethttpport etc APEX wil be available on the instance where you execute these statements. Not 100% sure but probably this will also work if you execute it on the second instance.
    For passwords, locations etc check the installation guide of 4.2
  • 8. Re: Oracle 11g R2 with APEX
    user480768 Newbie
    Currently Being Moderated
    I installed APEX 4.2 yesterday, the installation completed successfully, after APEX 4.2 has been installed, I drop user apex030200 cacade, so there is only apex040200 schema on Oracle 11g R2 server, then I dbms_xdb.sethttport(0) to disable EPG on Oracle Server, then I installed APEX listener 2.0 and choose database user as apex_public_user during the initial configuration of APEX Listener 2.0, then visit http://localhost:8080/apex/apex_admin from the oracle Apex listener server , it redirects to admin login page, however there is nothing showing on the local web browser. I don't know what is wrong with my APEX engine. It seems listener can communicate with oracle db instance. Any comments will be highly appreciated. Thanks.

    Kevin

Legend

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