This discussion is archived
4 Replies Latest reply: Nov 29, 2012 10:02 AM by jariola RSS

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

187479 Newbie
Currently Being Moderated
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 Guru
    Currently Being Moderated
    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 Oracle ACE
    Currently Being Moderated
    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
    187479 Newbie
    Currently Being Moderated
    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 Guru
    Currently Being Moderated
    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

Legend

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