Working with Oracle Application Express (APEX)

Oracle Application Express 4.1 (latest version ) installed on 28th August, 2011

Installing Oracle Application Express 4.1 requires:

1. An Oracle Database version 10.2.0.3 or higher

2. Oracle XML DB needs to be installed and configured in the database

Note : Oracle apex comes default along with the latest oracle versions

Step 1 : Install the latest version of oracle in your system :

http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html

Note : Installed 11gR2 (11.2.0.1.0)

a. Download and unzip both files (total 2GB size) to the same directory

b. Install oracle database in your desktop or laptop

c. Check whether you are able to use : Enterprise Manager Database Control URL - (orcl) :

https://localhost:1158/em

Step 2 : To enable the APEX, follow the below steps :

Microsoft Windows [Version 6.0.6002]

Copyright (c) 2006 Microsoft Corporation. All rights reserved.

C:\Users\ME>cd C:\app\ME\product\11.2.0\dbhome_1\apex

C:\app\ME\product\11.2.0\dbhome_1\apex>sqlplus sys as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Sun Aug 28 23:26:30 2011

Copyright (c) 1982, 2010, Oracle. All rights reserved.

Enter password:

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production

With the Partitioning, 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 []

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> EXEC DBMS_XDB.SETHTTPPORT(8080);

PL/SQL procedure successfully completed.

SQL> commit;

Commit complete.

SQL>

Step 3 : We are now ready to access APEX with the following URLs :

http://localhost:8080/apex

http://localhost:8080/apex/apex_admin — for admin page

Note that the format of URL is a little bit different from when using HTTP server with mod_plsql -

http://localhost:8080/pls/apex

http://localhost:8080/pls/apex/apex_admin — for admin page

Reference : http://oraexplorer.com/2007/11/oracle-apex-in-11g-installation/