8 Replies Latest reply on Feb 17, 2013 7:36 PM by user480768

    Oracle 11g R2 with APEX

    user480768
    user480768 Feb 14, 2013 9:33 PM
      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
      • 2062 Views
      • Tags:
        • 1. Re: Oracle 11g R2 with APEX
          Bas de Klerk
          Bas de Klerk Feb 15, 2013 11:07 AM (in response to user480768)
          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
            user480768 Feb 15, 2013 1:20 PM (in response to Bas de Klerk)
            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
              Bas de Klerk Feb 15, 2013 1:42 PM (in response to user480768)
              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
                user480768 Feb 15, 2013 2:08 PM (in response to Bas de Klerk)
                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
                  Bas de Klerk Feb 15, 2013 3:42 PM (in response to user480768)
                  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
                    user480768 Feb 15, 2013 5:28 PM (in response to Bas de Klerk)
                    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
                      Bas de Klerk Feb 17, 2013 9:15 AM (in response to user480768)
                      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
                        user480768 Feb 17, 2013 7:36 PM (in response to Bas de Klerk)
                        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