Step by step to install Oracle Application Express (APEX) 4.1.1

April 2nd, 2012 by admin Leave a reply »

I’m now showing you a step by step instructions how to install Oracle Application Express (APEX) 4.1.1 on Windows 7. With help from Cygwin environment.

  • Download Oracle Application Express (APEX) version 4.1.1 and Listener from OTN website: http://www.oracle.com/technetwork/developer-tools/apex/downloads/index.html and http://www.oracle.com/technetwork/developer-tools/apex-listener/downloads/index.html

  • Run sqlplus and log on database as user SYS:

    sqlplus SYS/Welcome1@localhost:1521/OracleDB as sysdba

  • Create tablespace “APEX”:

    DROP TABLESPACE APEX INCLUDING CONTENTS AND DATAFILES;

    CREATE TABLESPACE APEX DATAFILE 'C:\APP\ORADATA\ORACLEDB\APEX01.DBF' SIZE 256M AUTOEXTEND ON NEXT 16M MAXSIZE UNLIMITED
    LOGGING
    ONLINE
    PERMANENT
    EXTENT MANAGEMENT LOCAL AUTOALLOCATE
    BLOCKSIZE 8K
    SEGMENT SPACE MANAGEMENT AUTO
    FLASHBACK ON;

  • Assume you are under APEX package directory, then run the APEX installation sql script:

    SQL> @apexins APEX APEX01 TEMP /i/

    The installation will take a while. Time for a cup of tea till you see these on the screen:

    ...
    ...Compiled 701 out of 2896 objects considered, 0 failed compilation 14:01:03
    ...253 packages
    ...245 package bodies
    ...447 tables
    ...12 functions
    ...19 procedures
    ...3 sequences
    ...445 triggers
    ...1266 indexes
    ...196 views
    ...0 libraries
    ...6 types
    ...0 type bodies
    ...0 operators
    ...0 index types
    ...Begin key object existence check 14:01:03
    ...Completed key object existence check 14:01:03
    ...Setting DBMS Registry 14:01:03
    ...Setting DBMS Registry Complete 14:01:03
    ...Exiting validate 14:01:03
    timing for: Validate Installation
    Elapsed: 00:02:10.40
    timing for: Development Installation
    Elapsed: 00:15:59.51
    Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
    With the Partitioning, OLAP, Data Mining and Real Application Testing options

  • Unpack APEX Listener to e.g. C:\app\apex directory

    To start APEX (running under Windows 7 with Cygwin). First time when you start APEX you will be redirected to URL, e.g.:http://localhost:8585/apex/listenerConfigure to set up DB connection.

    C:\app\apex\bin>java -Dapex.home=C:\app\apex\tmp -Dapex.images=C:\app\apex\images -Dapex.port=8585 -jar apex.war

    INFO: Starting: C:\app\apex\bin\apex.war
     See: 'java -jar apex.war --help' for full range of configuration options
    INFO: Extracting to: C:\app/apex/tmp\apex                                       INFO: Using classpath: file:/C:/app/apex/tmp/apex/apex/____embedded/start.jar:file:/C:/app/apex/tmp/apex/apex/WEB-INF/lib/apex.jar:file:/C:/app/apex/tmp/apex/apex/WEB-INF/lib/commons-fileupload-1.2.1.jar:file:/C:/app/apex/tmp/apex/apex/WEB-INF/lib/je-4.0.103.jar:file:/C:/app/apex/tmp/apex/apex/WEB-INF/lib/ojdbc6.jar:file:/C:/app/apex/tmp/apex/apex/WEB-INF/lib/ojmisc.jar:file:/C:/app/apex/tmp/apex/apex/WEB-INF/lib/poi-3.6-20091214.jar:file:/C:/app/apex/tmp/apex/apex/WEB-INF/lib/ucp.jar:file:/C:/app/apex/tmp/apex/apex/WEB-INF/lib/xdb-11.2.0.jar:file:/C:/app/apex/tmp/apex/apex/WEB-INF/lib/xmlparserv2-11.2.0.jar:
    INFO: Starting Embedded Web Container in: C:\app\apex\tmp\apex
    Enter a username for the APEX Listener Administrator [adminlistener]:
    Enter a password for adminlistener:
    Confirm password for adminlistener:
    Enter a username for the APEX Listener Manager [managerlistener]:
    Enter a password for managerlistener:
    Confirm password for managerlistener:
    03/04/2012 12:32:49 PM ____bootstrap.Deployer deploy
    INFO: Will deploy application path=C:\app\apex\tmp\apex\apex\WEB-INF\web.xml
    03/04/2012 12:32:49 PM ____bootstrap.Deployer deploy
    INFO: deployed application path=C:\app\apex\tmp\apex\apex\WEB-INF\web.xml
    Using config file: C:\app\apex\tmp\apex\apex-config.xml
    APEX Listener version : 1.1.3.243.11.40
    APEX Listener server info: Grizzly/1.9.18-o
    03/04/2012 12:32:50 PM com.sun.grizzly.Controller logVersion
    INFO: Starting Grizzly Framework 1.9.18-o - Tue Apr 03 12:32:50 EST 2012
    INFO: Please complete configuration at: http://localhost:8585/apex/listenerConfigure
    Database connection not yet configured
    


    The following is screen output is the second time run after setup:

    INFO: Starting: C:\app\apex\bin\apex.war
     See: 'java -jar apex.war --help' for full range of configuration options
    INFO: Extracting to: C:\app\apex\tmp
    INFO: Using classpath: file:/C:/app/apex/tmp/apex/____embedded/start.jar:file:/C:/app/apex/tmp/apex/WEB-INF/lib/apex.jar:file:/C:/app/apex/tmp/apex/WEB-INF/lib/commons-fileupload-1.2.1.jar:file:/C:/app/apex/tmp/apex/WEB-INF/lib/je-4.0.103.jar:file:/C:/app/apex/tmp/apex/WEB-INF/lib/ojdbc6.jar:file:/C:/app/apex/tmp/apex/WEB-INF/lib/ojmisc.jar:file:/C:/app/apex/tmp/apex/WEB-INF/lib/poi-3.6-20091214.jar:file:/C:/app/apex/tmp/apex/WEB-INF/lib/ucp.jar:file:/C:/app/apex/tmp/apex/WEB-INF/lib/xdb-11.2.0.jar:file:/C:/app/apex/tmp/apex/WEB-INF/lib/xmlparserv2-11.2.0.jar:
    INFO: Starting Embedded Web Container in: C:\app\apex\tmp
    02/04/2012 4:23:14 PM ____bootstrap.Deployer deploy
    INFO: Will deploy application path=C:\app\apex\tmp\apex\WEB-INF\web.xml
    02/04/2012 4:23:14 PM ____bootstrap.Deployer deploy
    INFO: deployed application path=C:\app\apex\tmp\apex\WEB-INF\web.xml
    Using config file: C:\app\apex\tmp\apex-config.xml
    -- listing properties --
    PropertyCheckInterval=60
    ValidateConnection=true
    MinLimit=1
    MaxLimit=10
    InitialLimit=3
    AbandonedConnectionTimeout=900
    MaxStatementsLimit=10
    InactivityTimeout=1800
    MaxConnectionReuseCount=1000
    APEX Listener version : 1.1.3.243.11.40
    APEX Listener server info: Grizzly/1.9.18-o
    02/04/2012 4:23:23 PM com.sun.grizzly.Controller logVersion
    INFO: Starting Grizzly Framework 1.9.18-o - Mon Apr 02 16:23:23 EST 2012
    INFO: http://localhost:8585/apex started.
    Using JDBC driver: Oracle JDBC driver version: 11.2.0.2.0
    

  • APEX Developer Login interface:

  • APEX Admin Login interface:

Related Content:

Leave a Reply