This discussion is archived
5 Replies Latest reply: Apr 5, 2013 12:53 AM by Matze1969 RSS

How to access Oracle XE administration page after APEX installation?

Matze1969 Newbie
Currently Being Moderated
Hi all,

maybe it's a newbie question caused by a newbie mistake ;-)

I've installed Oracle XE 11g on my local Windows 7 machine. After that I've installed APEX 4.2.1 into Oracle XE database. Unfortunately now I cannot invoke the database web admin console anymore because it was replaced by the APEX admin workspace. How can I get the database administration console back in addition to the APEX admin app?

Thanks in advance
Matthias
  • 1. Re: How to access Oracle XE administration page after APEX installation?
    jariola Guru
    Currently Being Moderated
    Hi,

    When you upgrade APEX on XE you lose database management.
    You can use e.g. SQLPlus or SQL developer to perform admin tasks.

    This might help even it talks about 10G XE. Same things apply to 11G XE.
    http://www.oracle.com/technetwork/developer-tools/apex/application-express/upgrade-apex-for-xe-154969.html

    This might also help, but not recommended
    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
  • 2. Re: How to access Oracle XE administration page after APEX installation?
    fac586 Guru
    Currently Being Moderated
    >

    Please update your forum profile with a real handle instead of "user9032413".
    maybe it's a newbie question caused by a newbie mistake ;-)

    I've installed Oracle XE 11g on my local Windows 7 machine. After that I've installed APEX 4.2.1 into Oracle XE database. Unfortunately now I cannot invoke the database web admin console anymore because it was replaced by the APEX admin workspace. How can I get the database administration console back in addition to the APEX admin app?
    The XE DB management GUI tools are not standard components of APEX, but special applications developed in APEX that are included in the default XE installation. As they are not part of the standard standalone APEX installation they are lost when you upgrade using this.

    By upgrading to APEX 4.2 you have removed the database management GUI from XE. The only GUI admin tools provided by APEX are for managing the APEX instance and workspaces.

    See +{thread:id=2469800}+ for previous discussion of this, including possible ways to restore it. However the general recommendation would be to use the standard tools like SQL*Plus and SQL Developer for administration.

    Use the {forum:id=251} forum for XE database questions like this, and this forum for questions relating to application development in APEX.
  • 3. Re: How to access Oracle XE administration page after APEX installation?
    Joel_C Pro
    Currently Being Moderated
    fac586 wrote:

    The XE DB management GUI tools are not standard components of APEX, but special applications developed in APEX that are included in the default XE installation. As they are not part of the standard standalone APEX installation they are lost when you upgrade using this.

    By upgrading to APEX 4.2 you have removed the database management GUI from XE. The only GUI admin tools provided by APEX are for managing the APEX instance and workspaces.

    See +{thread:id=2469800}+ for previous discussion of this, including possible ways to restore it. However the general recommendation would be to use the standard tools like SQL*Plus and SQL Developer for administration.
    Putting aside the various shortcomings of the XE web interface and (laudable and well-intentioned) recommendations to use "proper" DBA tools such as SQL*PLus and SQL Developer instead, it does seem like a bit of an own-goal for XE/APEX to behave this way and presumably wasn't intended. It suggests that the various development teams don't perform the full impact assessment analysis (or is that analyses?) before releases; images of belligerent right and left hands spring to mind.
  • 4. Re: How to access Oracle XE administration page after APEX installation?
    jariola Guru
    Currently Being Moderated
    Joel_C wrote:
    Putting aside the various shortcomings of the XE web interface and (laudable and well-intentioned) recommendations to use "proper" DBA tools such as SQL*PLus and SQL Developer instead, it does seem like a bit of an own-goal for XE/APEX to behave this way and presumably wasn't intended. It suggests that the various development teams don't perform the full impact assessment analysis (or is that analyses?) before releases; images of belligerent right and left hands spring to mind.
    Hi,

    As I understand XE 10G and 11G ships APEX version you can not download or install other database editions.

    Regards,
    Jari
    -----
    My Blog: http://dbswh.webhop.net/htmldb/f?p=BLOG:HOME:0
    Twitter: http://www.twitter.com/jariolai
  • 5. Re: How to access Oracle XE administration page after APEX installation?
    Matze1969 Newbie
    Currently Being Moderated
    Hi all,

    thanks for your replies. I must say that I'm a little bit confused about that. Why do I lose my admin console if I install APEX on XE? Should have been tested during development...E.g. what would happen if the Enterprise Manager or the DB console on Oracle 11g EE wouldn't work any longer after installing any kind of Oracle product (e.g. APEX)? Wouldn't be good...

    But I'll be able to do my admin tasks using SQL*plus or SQL Developer ;-)

    Thanks again
    Matthias

Legend

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