How to Configure Oracle Apex in Oracle 11g Database - Enterprise Edition

1. Need connect to the database using sqlplus from the database machine as sysdba
connect sys as sysdba

2. run below command in SQL:
@/u01/app/oracle/product/11.2.0/dbhome_1/apex/apxconf.sql

3. here showing
3.1 PORT 8080
3.2 Enter a password for the ADMIN user: <give your apex ADMIN user password>
3.3 showing below message if success:
…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.


4. Unlock anonymous user:
SQL> alter user anonymous account unlock;
User altered.

5. Enable Oracle XML DB HTTP server:
SQL> exec dbms_xdb.sethttpport(8080);
PL/SQL procedure successfully completed.

6. Commit command
SQL> commit;
Commit complete.

7. now we can access oracle apex by using following link.
http://host:port/apex
(e.g http://192.168.0224:8080/apex

8. Enter login credentials:
workspace  : internal (default - first)
User  : admin
password  : you entered when you configured apex.

 (it's tested from oracle 11g database)
 Thanks