This content has been marked as final. Show 8 replies
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.
if this returns a port APEX should be accessible via this port on the server.
select DBMS_XDB.getHTTPPort from dual;
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.
You enable the EPG by running the following statement as user sys :
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.
exec DBMS_XDB.setHTTPPort(8080); <- This enables apex on port 8080 ALTER SYSTEM REGISTER;
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.
After launch following two sql statements:
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.
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.