Oracle Application Express(APEX) Installation Step by Step

Environment: Oracle Windows 32bit,, Oracle database 11.2.0.1.0 EE, APEX 4.2.2.00.11, 4GB RAM

Steps:

1) Download the software

You can download APEX 4.2 from Oracle.com/downloads.  I downloaded  the “only english” zip file. You can download the documentation separately.

2) copy and extract the software

Now copy and extract the apex_4.2.zip file to your machine. I use “unzip” to unzip the zip file. This will create a folder named “apex”. I kept this folder on my machine in a permanent location, c:\apex.

3) check the tablespace requirements –

You need about 275MB of free space in the APEX tablespace (mine is called “APEX”) and 100MB of free space in the SYSTEM tablespace.

Note: Not a problem if you haven’t created one, this will get created once your APEX installation is complete and you start creating workspaces.

SQL executions:

Now login to DOS prompt or PUTTY and execute the sql’s wherever the APEX folder was unzipped:

C:\Users\vmummadi>cd C:\apex

C:\apex>dir – this will show all the contents under this folder.

SQL> connect / as sysdba

Connected.

SQL> @apexins SYSAUX SYSAUX TEMP /i/  

- Pass tbs names as it will put its data and indexes here, it also uses the temp tbs and ‘i’ -is the virtual directory where it stores all images.

This will run for a very long time (anywhere between 30-90mins) depends on server and environment, for me it took 104mins. And it will generate a spool file under the same directory (install2013-05-02_15-24-49.log). At the end you should see success message something like this-

PL/SQL procedure successfully completed.

timing for: Install Internal Applications

Elapsed: 01:23:02.39 

Thank you for installing Oracle Application Express.

Oracle Application Express is installed in the APEX_040200 schema.

The structure of the link to the Application Express administration services is as follows:

http://host:port/pls/apex/apex_admin (Oracle HTTP Server with mod_plsql)

http://host:port/apex/apex_admin     (Oracle XML DB HTTP listener with the embedded PL/SQL gateway)

The structure of the link to the Application Express development interface is as follows:

http://host:port/pls/apex (Oracle HTTP Server with mod_plsql)

http://host:port/apex     (Oracle XML DB HTTP listener with the embedded PL/SQL gateway)

JOB_QUEUE_PROCESSES: 1000

PL/SQL procedure successfully completed. 

Session altered. 

Performing Application Express component validation - please wait...

old   6:     if '^UPGRADE' = '1' then

new   6:     if '2' = '1' then

old   7:        dbms_registry.loaded('APEX','^version');

new   7:        dbms_registry.loaded('APEX','4.2.2.00.11');

old   8:     elsif '^UPGRADE' = '2' then

new   8:     elsif '2' = '2' then

old  10:             dbms_registry.upgraded('APEX','^version');

new  10:             dbms_registry.upgraded('APEX','4.2.2.00.11');

old  12:             dbms_registry.loaded('APEX','^version');

new  12:             dbms_registry.loaded('APEX','4.2.2.00.11');

Completing registration process. 17:11:01

Validating installation.  17:11:02

...Database user "SYS", database schema "APEX_040200", user# "92" 17:11:02

...Compiled 0 out of 3004 objects considered, 0 failed compilation 17:11:02

...266 packages

...258 package bodies

...452 tables

...11 functions

...16 procedures

...3 sequences

...457 triggers

...1320 indexes

...211 views

...0 libraries

...6 types

...0 type bodies

...0 operators

...0 index types

...Begin key object existence check 17:11:02

...Completed key object existence check 17:11:03

...Setting DBMS Registry 17:11:03

...Setting DBMS Registry Complete 17:11:03

...Exiting validate 17:11:03

PL/SQL procedure successfully completed.

timing for: Validate Installation

Elapsed: 00:00:02.88

old   1: alter session set current_schema = ^APPUN

new   1: alter session set current_schema = APEX_040200

Session altered.

timing for: Complete Installation

Elapsed: 01:46:11.17

PL/SQL procedure successfully completed.

GLOBAL_NAME

------------------------------

SYS

1 row selected.

 n  If you don’t see something similar to this or any error this script will exit out before completing the execution, and we need to fix the error.

SQL> connect / as sysdba

Connected.

- to check whether or not APEX is installed properly. The status should show VALID.

SQL> select status from dba_registry where comp_id='APEX'; 

STATUS

-------------------------------------------------------

VALID

Images script:  parameterit takes is one directory up. So this one directory level up-

SQL> connect / as sysdba

Connected.

SQL> @apxldimg c:

PL/SQL procedure successfully completed.

PL/SQL procedure successfully completed.

 Loading images directory: c:\/apex/images

Directory created.

PL/SQL procedure successfully completed.

PL/SQL procedure successfully completed.

PL/SQL procedure successfully completed.

Commit complete.

Directory dropped.

timing for: Load Images

Elapsed: 00:10:31.41

C:\apex>sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Thu May 2 17:31:47 2013

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

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 value below for the password for the Application Express ADMIN user.

Enter a password for the ADMIN user     [] – <enter password here>

(remember this pwd as you will use this for login as admin)

Session altered.

...changing password for ADMIN

PL/SQL procedure successfully completed.

Enter a port for the XDB HTTP listener [      8080]

...changing HTTP Port

(leave it at 8080 if you don’t want to change the port number, if you want to change then change it to whatever you want, for LINUX there are rules to changes port numbers below 1024)

PL/SQL procedure successfully completed.

This completes the installation.

Now login to APEX admin:

localhost:8080/apex/apex_admin – this is the administrator page , local host since mine is local machine.

localhost:8080/apex/ - users access page

Now follow the instructions what it says from this page – Ex: change password, etc…

-Now you will be ablet o see lot of applications  like manage requests, manage instance, manage workspace, monitor activity.