4 Replies Latest reply: Nov 29, 2012 12:02 PM by jariola RSS

    Oracle XE R11.2  DB Mgmt App not accessable after APEX 4.2 upgrade

    Dreeves-Oracle
      I recently installed Oracle Database Express Edition 11g Release 2 (with APEX installed). Then went through the documented processes to upgrade APEX to R4.2. When I did that, I lost access to the APEX based GUI for managing the R11g XE database.

      The "lost" application was reached by the URL http://127.0.0.1:8080/apex/f?p=4950
      which now returns: Error Error processing request.
      ORA-01403: no data found
      OK

      Does anyone know if it is possible to recover or re-install the original Oracle Database Express Edition 11g Release 2 "Getting Started" APEX application in this new APEX 4.2 environment? This would greatly speedup my DB management tasks so I don't have to find SQL statements for all DB operations.

      regards,

      David Reeves
      Oracle Consulting

      Edited by: dreeves on Nov 28, 2012 2:01 PM
        • 1. Re: Oracle XE R11.2  DB Mgmt App not accessable after APEX 4.2 upgrade
          jariola
          Hi,

          When you upgrade APEX to XE you lose db management app.
          You can not get management application officially anywhere.

          I did found this. But I'm not recommend try it.
          http://www.eberapp.com/pls/apex/f?p=BLOG:READ:0::::ARTICLE:96100346993651

          Better handle db management tool like SQL Developer
          http://www.oracle.com/technetwork/developer-tools/sql-developer/overview/index.html

          This document might help also
          http://www.oracle.com/technetwork/developer-tools/apex/application-express/upgrade-apex-for-xe-154969.html
          It is valid mostly also for 11G XE

          Regards,
          Jari
          -----
          My Blog: http://dbswh.webhop.net/htmldb/f?p=BLOG:HOME:0
          Twitter: http://www.twitter.com/jariolai
          • 2. Re: Oracle XE R11.2  DB Mgmt App not accessable after APEX 4.2 upgrade
            orafad
            It's not part of Apex, it's a specific/separate application with XE.

            You are not the first. You might want to search the forums for previous discussions/ideas on the topic.
            E.g. https://forums.oracle.com/forums/search.jspa?threadID=&q=%2B4950+%2Bxe&objID=f137&dateRange=lastyear&userID=&numResults=15&rankBy=10001

            But as suggested, use SQL Developer. The current versions has added a couple DBA tools, and you could also use its sql script capabilities to save and have a set of scripts ready.
            Having your own set of queries/statements for "db operations" should be part of the survival kit anyway.
            • 3. Re: Oracle XE R11.2  DB Mgmt App not accessable after APEX 4.2 upgrade
              Dreeves-Oracle
              One approach to this problem would be to export the XE DB Admin app from a R11 XE instance BEFORE applying an APEX 4.2 upgrade, then import the app into the APEX 4.2 environment.

              To do this one needs to know the WORKSPACE name, admin username, and password to access the identification details of the XE DB Admin app.

              I tried using the URL http:localhost:8080/apex/apex_admin and got to the Application Express Site admin account and used the 'admin' account name and password but recieved a message:

              "Access denied by application security check" "Application access restricted to internal workspace users"

              Is there an "Internal" workspace admin user name and password in the standard R11.2 XE installation?
              • 4. Re: Oracle XE R11.2  DB Mgmt App not accessable after APEX 4.2 upgrade
                jariola
                Hi,

                You can download ready export from
                http://www.eberapp.com/pls/apex/f?p=BLOG:READ:0::::ARTICLE:96100346993651

                Regards,
                Jari
                -----
                My Blog: http://dbswh.webhop.net/htmldb/f?p=BLOG:HOME:0
                Twitter: http://www.twitter.com/jariolai