-
1. Re: Oracle 11g R2 with APEX
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.
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.
Cheers
Bas -
2. Re: Oracle 11g R2 with APEX
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
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.
Regards
Bas -
4. Re: Oracle 11g R2 with APEX
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
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
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
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
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