Miladin Modrakovic's Blog: Oraclue

My pain developer http://www.oraclenerd.com/  keep buging me for some time to install APEX…   We had it installed and it worked fine and sudenly APEX images did not work…

In the past I have installed APEX  using Oracle Application server and configuring dads.conf file etc..

Well with 11g database installing APEX is much easier.In Oracle Database 11g, Oracle Application Express is installed when the database is installed.

Only thing you have to do is to run script  apxconf located under $ORACLE_HOME/apex directory.This script will confugure PL/SQL gateway.

-sh-3.2$ sqlplus / as sysdba

SQL*Plus: Release 11.1.0.6.0 – Production on Tue Feb 17 14:46:42 2009

Copyright (c) 1982, 2007, Oracle.  All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 – 64bit Production
With the Partitioning, Real Application Clusters, Oracle Label Security, OLAP,
Data Mining and Real Application Testing options

SQL> @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_123
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.

SQL> alter user anonymous account unlock;

User altered.

SQL> exit

You can find Oracle tutorial 

http://www.oracle.com/technology/obe/11gr1_db/install/apexinst/apexinst.htm

No more messing with app server and encrypting password for apex user…