working on applications and technology

Oracle Application Express - Apex seems to become a standard component for Oracle database now! Cause when I install Oracle database 11g and create database using the DBCA, Apex is installed and configured into the database by default.

Before the release of Database 11g, We have to mannually run a few scripts to install Apex into Oracle database, and now the common Apex script is executed automatically while using DBCA for 11g (unless you deselect apex in the below step).

But Still We have a few steps to configure before we could use Apex in Database 11g . and here 's the step:

1. Choose whether to use Oracle HTTP server or the embedded light weight PL/SQL gateway to run Apex. I recommend the use of the embeded PL/SQL gateway because It is more easier to configure and It is enough for your own Apex development. Of course you could always choose the Oracle HTTP server(Apache) for production enviroment serving many customers.
2. Suppose that we use the embedded PL/SQL gateway and the first step is to login into sqlplus as SYSDBA to run the apxconf script under the directory of $ORACLE_HOME/apex, you could run the script using the '@' operator as

   SQL>@apexconf

3. Unlock the 'ANONYMOUS' database user account :

   SQL> Alter user ANONYMOU account unlock;

4. Configure the embedded HTTP server using sqlplus with SYSDBA privilege:

   SQL>EXEC DBMS_XDB.sethttpport(8000);
   SQL>commit;

Now you could login into Apex with the url http://localhost:8000/apex  !