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.
