Today I installed Oracle 11g (11.1.0.6) on my machine. I did not realize that Oracle APEX is a part of the standard database components.
So after the 11g installation, I just follow simple steps (shown later below) for the post-installation. In order to access the APEX application, either the embedded PL/SQL gateway or Oracle HTTP server with mod_plsql is needed. For simplicity, I’ve decided to go with the former. By using the embedded PL/SQL gateway, it will run using the Oracle XML DB HTTP server which is already in Oracle database, so there is no need to install a separate HTTP server. The Oracle’s document here explains about this as well as provides the detailed information on the post-installation.
To configure the embedded PL/SQL gateway:
1. Go to the $ORACLE_HOME/apex directory.
2. Use SQL/Plus to connect as SYS to 11g database where APEX is installed.
SYS AS SYSDBA@db11r1> @apxconf
PORT
----------8080
Enter values below for the XDB HTTP listener port and the password for the Application Express ADMIN user.
Default values are in brackets [ ].
Press Enter to accept the default value.
Enter a password for the ADMIN user []admin_password
Enter a port for the XDB HTTP listener [ 8080]
...changing HTTP Port
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
Session altered.
...changing password for ADMIN
PL/SQL procedure successfully completed.
Commit complete.
3. Unlock the ANONYMOUS account.
SYS AS SYSDBA@db11r1> ALTER USER ANONYMOUS ACCOUNT UNLOCK; User altered.
4. Enable Oracle XML DB HTTP server
SYS AS SYSDBA@db11r1> EXEC DBMS_XDB.SETHTTPPORT(8080); PL/SQL procedure successfully completed. SYS AS SYSDBA@db11r1> COMMIT; Commit complete.
5. We’re now ready to access APEX.
http://host:port/apex
http://host:port/apex/apex_admin — for admin page
Port in this case is 8080 which is the default.
Note that the format of URL is a little bit different from when using HTTP server with mod_plsql -
http://host:port/pls/apex
http://host:port/pls/apex/apex_admin — for admin page
Also the SQL Developer 1.1.3 is included under “sqldeveloper” directory of ORACLE HOME. So just double-click at sqldeveloper.exe to launch application.
April 9th, 2008 10:04 pm
Hi My friend Oracle lover …
I’m trying to make this work on the 11g and didnt find either mod-plsql or http server on this version.
Do you know how can I get those ?
April 10th, 2008 12:54 am
Have you tried to enable XML DB HTTP?
To enable Oracle XML DB HTTP server:
1. Start SQL*Plus and connect to the database as SYS.
SQL> CONNECT SYS as SYSDBA
Enter password: SYS_password
2. Run the following statements:
EXEC DBMS_XDB.SETHTTPPORT(8080);
COMMIT;
Then proceed with running apxconf script.
Let me know how it goes.
-IC
July 30th, 2009 4:16 pm
Hi, I configured a 11G APEX using the enbedded PL/SQL gateway like you described here. Then I tried to log in ADMIN, www::8080/apex/apex_admin, I got a pop-up says:
The server at XDB requires a username and password, I enetered: ADMIN and password, it failed. What can I do to fix it? Thanks.
July 30th, 2009 6:45 pm
Jeff,
I assume you did “Unlock anonymous account” already. Have you tried to verify and enable the XDB HTTP server port?
Is the workspace-access URL (http://localhost:8080/apex) working?
You may try to bounce database to see whether or not it helps.
July 31st, 2009 9:36 am
Thanks,Ittichai.I checked most postings thru Google search. I ran apex_epg_config many times. Running of epgstat (in $ORACLE_HOME/rdbms/admin) produced: Allow repository anonymous access? => false (Anonymous access to XDB) Is this the issue? How to fix it?
August 1st, 2009 12:50 am
Have you tried to restart instance?
Can you post the result of your epgstat? The anonymous access = false is okay. Setting to TRUE just allows public access to XDB repository without authentication. It is security risk.
This is my epgstat’s output: (you can try to compare if anything may differ).
01:32:38 SYS AS SYSDBA@ora11win> @D:\oracle\product\11.1.0\db_1\rdbms\admin\epgstat
+————————————–+
| XDB protocol ports: |
| XDB is listening for the protocol |
| when the protocol port is non-zero. |
+————————————–+
HTTP Port FTP Port
——— ——–
8080 0
1 row selected.
Elapsed: 00:00:00.15
+—————————+
| DAD virtual-path mappings |
+—————————+
Virtual Path DAD Name
——————————– ——————————–
/apex/* APEX
1 row selected.
Elapsed: 00:00:00.17
+—————-+
| DAD attributes |
+—————-+
DAD Name DAD Param DAD Value
———— ———————— —————————————-
APEX database-username ANONYMOUS
default-page apex
document-table-name wwv_flow_file_objects$
request-validation-funct wwv_flow_epg_include_modules.authorize
ion
document-procedure wwv_flow_file_mgr.process_download
nls-language american_america.al32utf8
document-path docs
7 rows selected.
Elapsed: 00:00:00.92
+—————————————————+
| DAD authorization: |
| To use static authentication of a user in a DAD, |
| the DAD must be authorized for the user. |
+—————————————————+
no rows selected
Elapsed: 00:00:00.10
+—————————-+
| DAD authentication schemes |
+—————————-+
DAD Name User Name Auth Scheme
——————– ——————————– ——————
APEX ANONYMOUS Anonymous
1 row selected.
Elapsed: 00:00:00.03
+——————————————————–+
| ANONYMOUS user status: |
| To use static or anonymous authentication in any DAD, |
| the ANONYMOUS account must be unlocked. |
+——————————————————–+
Database User Status
————— ——————–
ANONYMOUS OPEN
1 row selected.
Elapsed: 00:00:00.59
+——————————————————————-+
| ANONYMOUS access to XDB repository: |
| To allow public access to XDB repository without authentication, |
| ANONYMOUS access to the repository must be allowed. |
+——————————————————————-+
Allow repository anonymous access?
———————————-
false
1 row selected.
Elapsed: 00:00:00.01
You can just simply check access to XDB by assigning password to anonymous account (e.g., alter user anonymous identified by anonymous). Then go to http://host:8080, when prompting for username and password, enter anonymous and its password. Assuming that this anonymous account is already unlocked, it should let you in and display list of files/folders on browser.
Ittichai
August 3rd, 2009 10:57 am
Thanks Itti,you are still on this. My epgstat output is pretty much like yours. When I give anonymous a password and do the APEX admin login again, I got an ORA-600 [wpemInit_3] on the Oracle alert log. The ORA-600 subcode is not even in MetaLink yes. This 11G is just downloaded without any patch(es). My old APEX is still working on 10g with a HTTP server. So I will wait for 11.2 in the future or after we apply more patch/patchset to it before I try APEX again.
Regards, Jeff
August 3rd, 2009 6:55 pm
Jeff,
Either you could to apply the 11.1.07 patch set (and then try to configure it again) or configure the existing HTTP to this database. At least to see whether or not it may work.
Ittichai
August 26th, 2009 6:45 am
Hi,
I am having problems getting the Oracle Apex home page to appear. I have apex installed on 11g on Enterprise Linux.
I have configured Oracle Apex to work over the PL/SQL gateway. I have ran the apexconf.sql script, set the port, unlocked the anonymous account and ran the apex_congfig sql script.
The port number I have set is 8080 from default of 7779. I have done this multiple times and bounced the database too.
The URL I am using to access APEX is http://localhost:8080/pls/apex and http://localhost:8080/pls/apex_admin
I am at a loss as I have followed the documentation post installation tasks and used your instructions many times with no success.
Your help will be greatly apprecited.
Thanks
August 28th, 2009 1:38 pm
Have you tried to run the epgstat? Please post the result. See the previous comment for detail.
For EPG configuration, you will have to use http://localhost:port/apex (no pls), and the default port is 8080. The URLs you mentioned is for when using HTTP server with mod_plsql.
October 10th, 2009 7:35 pm
August 9, 2009 by Mad We have a winner! ,
October 23rd, 2009 2:30 am
Just completed a fresh standard install of 11g on Windows Server 2008 Std x64. Not a hint of HTTP server but did see APEX was present.
I followed your directions above and worked perfectly! I would have prefered using the Apache server but this will work.
Thanks!
October 23rd, 2009 4:56 am
Glad to hear that it works for you. The Apache with mod_plsql is definitely the way to go for if you plan to use APEX for production at a larger scale. The instructions are there with the download files. The final note – Oracle just released a new way to connect to APEX called APEX listener. This likely will be the default option for the next release of APEX. I wrote about it here.
December 10th, 2009 10:07 am
Ittichai
I have followed the above forum, but still getting problem connecting. Do you thing I should reinstall?
December 10th, 2009 8:02 pm
Albert,
Can you please specify what error you got?
January 3rd, 2010 12:58 pm
Well, I followed the above recommendations and it didn’t succeeded (actually, with upgrading Oracle 11gr1 to APEX 3.2.1).
It say user ANONYMOUS with password “anonymous” is expired.
I don’t know if it is related to whether the packages are modified need recompilations.
January 3rd, 2010 3:14 pm
If you password of ANONYMOUS account has expired, you can try to set its password using
ALTER USER ANONYMOUS IDENTIFIED by [password];
and to be certain, please unlock this account if needed.
ALTER USER ANONYMOUS ACCOUNT UNLOCK;
January 4th, 2010 2:47 pm
Hi there,
Thanks so much for maintaining this page. It’s nice to know others are stumbling over the same things.
I have done as most others have here: installed 11g, ran apxconf.sql, unlocked the ANONYMOUS account. However, as another poster mentioned, I do not see any indication that the HTTP server is running. If I try to hit: http://localhost:6666/apex or the admin page I get no response at all (not a 404, not an error….nothing)
If I run a netstat command I don’t seem to see that the machine is listening on the correct port – should I see it? Do I need to execute anything to tell it to start listening?
One thing that I notice from the epgstat output below is that anon access seems to be “false”. I haven’t changed any defaults….should this be “true”?
Any help much appreciated.
SQL> @?/rdbms/admin/epgstat
+————————————–+
| XDB protocol ports: |
| XDB is listening for the protocol |
| when the protocol port is non-zero. |
+————————————–+
HTTP Port FTP Port
——— ——–
6666 0
1 row selected.
+—————————+
| DAD virtual-path mappings |
+—————————+
Virtual Path DAD Name
——————————– ——————————–
/apex/* APEX
1 row selected.
+—————-+
| DAD attributes |
+—————-+
DAD Name DAD Param DAD Value
———— ———————— —————————————-
APEX database-username ANONYMOUS
default-page apex
document-table-name wwv_flow_file_objects$
request-validation-funct wwv_flow_epg_include_modules.authorize
ion
document-procedure wwv_flow_file_mgr.process_download
nls-language american_america.al32utf8
document-path docs
7 rows selected.
+—————————————————+
| DAD authorization: |
| To use static authentication of a user in a DAD, |
| the DAD must be authorized for the user. |
+—————————————————+
no rows selected
+—————————-+
| DAD authentication schemes |
+—————————-+
DAD Name User Name Auth Scheme
——————– ——————————– ——————
APEX ANONYMOUS Anonymous
1 row selected.
+——————————————————–+
| ANONYMOUS user status: |
| To use static or anonymous authentication in any DAD, |
| the ANONYMOUS account must be unlocked. |
+——————————————————–+
Database User Status
————— ——————–
ANONYMOUS OPEN
1 row selected.
+——————————————————————-+
| ANONYMOUS access to XDB repository: |
| To allow public access to XDB repository without authentication, |
| ANONYMOUS access to the repository must be allowed. |
+——————————————————————-+
Allow repository anonymous access?
———————————-
false
1 row selected.
SQL>
January 4th, 2010 4:31 pm
Dwayne,
I have my listening port displayed when checking with NETSTAT.
C:\>netstat -an |find /i “listening” | find “8080″
TCP 0.0.0.0:8080 0.0.0.0:0 LISTENING
If you don’t have it, it is likely that issue is with XDB. I assume there is no error when doing “apxconf”? Could you make sure that it is enabled using “EXEC DBMS_XDB.SETHTTPPORT(8080);”?
The way to check is to go to http://localhost:8080/ (without apex). You will be prompted to logon using anonymous account and its password. Successful logon will display the XDB folders on browser.
Another thing, just in case, is to check whether or not APEX is installed properly. The status should show VALID.
@ora11win> select comp_name, version, status
from dba_registry
where comp_name=’Oracle Application Express’;
COMP_NAME VERSION STATUS
———————————– ————— —————
Oracle Application Express 3.2.0.00.27 VALID
January 4th, 2010 4:50 pm
OK – I guess I just completely missed it….
1) the port in question *is* shown by netstat, exactly as you point out.
2) the port *does* seem to be registered when I do a “lsnrctl status”, and it shows HTTP as expected
However, hitting the URL as you describe above (without apex) gives me nothing. No response at all. Does this help at all?
Thanks for your reply.
January 4th, 2010 5:56 pm
If you see nothing from http://localhost:8080, it seems like you may have issue with XDB rather. Did you have XDB correctly installed? The “Oracle XML Database” must be shown from dba_registry. You may need to google on how to check XDB or even reinstall it.
BTW, does you browser use proxy?
January 5th, 2010 9:00 am
No browser proxy here. XML DB does indeed show up (and is VALID) in DBA_REGISTRY.
Currently looking for a way to debug XDB not responding, since netstat says it *should* be listening
January 29th, 2011 11:09 am
With this error check your listener on the Oracle Host. I found that if running the Embedded Gateway, the XDB service needs to be running and registered with the Listener.
For example, for my 11g DB called “dev1a” – I went into the netmgr utility and added the dev1a DB. It then automatically added the XDB service, and I could see it via:
[oracle@oraclerac001 trace]$ lsnrctl services
LSNRCTL for Linux: Version 11.2.0.1.0 – Production on 29-JAN-2011 10:05:32
Copyright (c) 1991, 2009, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=oraclerac001.localdomain)(PORT=1521)))
Services Summary…
Service “dev1a” has 2 instance(s).
Instance “dev1a”, status UNKNOWN, has 1 handler(s) for this service…
Handler(s):
“DEDICATED” established:0 refused:0
LOCAL SERVER
Instance “dev1a”, status READY, has 1 handler(s) for this service…
Handler(s):
“DEDICATED” established:0 refused:0 state:ready
LOCAL SERVER
Service “dev1aXDB” has 1 instance(s).
Instance “dev1a”, status READY, has 1 handler(s) for this service…
Handler(s):
“D000″ established:0 refused:0 current:0 max:1022 state:ready
DISPATCHER
(ADDRESS=(PROTOCOL=tcp)(HOST=oraclerac001.localdomain)(PORT=56994))
The command completed successfully
Note the : Service “dev1aXDB” has 1 instance(s).
This is required for the embedded gateway.
April 3rd, 2011 6:43 pm
hi
i have made an upgrade of oracle 10g to 11g in order to use apex3.x to upgrade to apex 4.x,
but i cant access to the admin account and the workspace
http://host:port/apex/apex_admin
port :8080
i fellow the procedure you give every thing was good but i have this error HTTP 404
April 3rd, 2011 9:12 pm
I assume you unlock and set port already. Can you post the output of
SQL> @$ORACLE_HOME/rdbms/admin/epgstat.sql
April 7th, 2011 7:17 am
I have been facing the same problem.
Most solutions point at the anonimous user is locked.
In my situation also the xdb user was locked.
So after: SQL>alter user xdb account unlock
My problem was solved!
April 15th, 2011 12:15 pm
Hello all,
I have installed one 11gR2 database on a test environment and am currently trying to configure the embedded pl/sql gateway for APEX 3.2. Would you happen to know if there is a possibility to configure both the embedded pl/sql gateway AND http server with mod_plsql (of course on a separate AS) for the same DB hosting APEX ?
Thank you.
April 15th, 2011 12:49 pm
I would assume that there shouldn’t be any issues as long as there is no host and port conflict. However, I see no point to having both configured at the same time.
April 15th, 2011 12:54 pm
There was actually a note saying that the embedded pl/sql gateway is not recommended for applications using Internet (and with good reason! the DB would be quite exposed…). Although, I have many developpers who are building a log of internal applications using APEX… so I was just checking how our next architecture would be with 11g…
Thank you for your post; this will give me some ideas!
April 15th, 2011 1:02 pm
If you’re interested in the enhancing your APEX architecture, look for the APEX listener (http://www.oracle.com/technetwork/developer-tools/apex-listener/overview/index.html). It’s an alternative to OHS with mod_plsql and much more.
April 27th, 2011 11:37 am
Hi,
We tried to set up the oracle http server first time (newbie) and followed all the installation steps above. unlocked accounts and set pwd for anonymous, xdb…
Verified all objects (apex x db) and are valid.
Ran the netstat -na and found that
TCP 0.0.0.0:8080 0.0.0.0:0 LISTENING
ran epgstat.sql and it is showing exactly similar to you (except response times).
We want to have Oracle HTTP server with APEX 3.1.2 (client requirement).
When I went to http://localhost:8080/apex... I got following error. Any clue or direction greatly appreciated.
[exception]
badcommand
Report Server Exception
Unsupported command: Host: localhost:8080
[bye]
[exception]
badcommand
Report Server Exception
Unsupported command: User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:2.0) Gecko/20100101 Firefox/4.0
[bye]
[exception]
badcommand
Report Server Exception
Unsupported command: Accept: text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
[bye]
[exception]
badcommand
Report Server Exception
Unsupported command: Accept-Language: en-us,en;q=0.5
[bye]
[exception]
badcommand
Report Server Exception
Unsupported command: Accept-Encoding: gzip, deflate
[bye]
[exception]
badcommand
Report Server Exception
Unsupported command: Accept-Charset: ISO-8859-1,utf-8;q=0.7,*;q=0.7
[bye]
[exception]
badcommand
Report Server Exception
Unsupported command: Keep-Alive: 115
[bye]
[exception]
badcommand
Report Server Exception
Unsupported command: Connection: keep-alive
[bye]
[exception]
badcommand
Report Server Exception
Unsupported command: Cookie: oracle.uix=0^^GMT-4:00^p
[bye]
[exception]
badcommand
Report Server Exception
Unsupported command:
[bye]
April 27th, 2011 6:34 pm
If you plan to use Oracle HTTP Server (OHS), there is no need to run the epgstat as that is for EPG only. Have you set up the OHS already? Generally by default OHS is using 7777. So the default URL (if no alteration during configurations) when using OHS is http://webserver:7777/pls/apex.
May 27th, 2011 5:35 pm
I had the same problem when epgstat showed XDB running on 8080 and ANONYMOUS user account is enabled but connecting to http://hostname:8080/apex returned nothing. I even checked lsof to make sure the port 8080 was available.
After checking around found that my Oracle Enterprise Linux had the firewall enabled. (Use iptables to find this and see if it has any rules against INPUT). Removing the INPUT rules, fixed the issue.
May 27th, 2011 5:58 pm
Somu
Thanks for sharing.
December 31st, 2011 1:24 pm
Thank’s man it’s working for me
January 26th, 2012 11:42 am
Does anybody knows how to configure Apex in a multi Tier environment? I’d like to install the Apex inside my main Oracle Database, but instead of create another http service, I would like to call the Apex through an OAS (Oracle Application Server) that today is being used to publish Oracle Forms and Reports.
January 26th, 2012 1:28 pm
Actually it is recommended to have the multi-tier environment for production deployment. On OAS, you can use either use OHS (Oracle HTTP server) in OAS or APEX listener. See details at http://docs.oracle.com/cd/E23903_01/doc/doc.41/e21673/overview.htm#autoId10
January 27th, 2012 12:57 pm
Do you know how to create a new Tier in the OAS with Apache v.1 (before Weblogic)? This is the version that I have in the company where I work. I didn’t find any document that explains how to configure this old version of Oracle Server. Today I already have two tiers. One to INFRA, and another to FORM (Oracle Forms and Reports). I would like to create one more tier called APEX and use it to call the Apex that was installed inside my production database.
January 27th, 2012 1:13 pm
Actually the document on how to configure APEX with Oracle HTTP server or OAS is in referred in the link previously mentioned. Here is the direct link http://docs.oracle.com/cd/E23903_01/doc/doc.41/e21673/otn_install.htm#BHAGICFJ
Basically in addition to copying the image files to web server, you will have to add new content of /pls/apex into the dads.conf. The URL used will be http://oashost:port/pls/apex.
January 30th, 2012 4:54 am
Thank you. I have already followed those steps, but I believe that I have to configure something else that I don’t know exactly what. The main problem is that my server already have two tiers. One to Infra and another to Form. I did exactly what the document explains inside Form tier but nothing happens. I will try to configure Infra tier this time. An Oracle consulter said me that I had to create another tier, for example, Apex. This third tier would be responsible for the controle of the Apex software. But as I’m not an Apache administrator, I don’t know how to create this new Tier.
Thank you.
January 30th, 2012 9:13 am
If you followed the steps (especially adding new content to the dads.conf), that is to create a new application tier (noted host:port/pls/apex). The pls maps to the mod_plsql. What comes after is the application name, i.e., apex.
I think you have to clearer on what you’ve done.