Installation of Oracle APEX(Application Express ) in OEL 6

This document describes how to install Oracle Application Express(APEX) in OEL 6.

What is APEX?

Oracle Application Express (Oracle APEX), is the low code web application development tool for the Oracle database. Application Express enables you to design, develop and deploy beautiful, responsive, database-driven applications, either on-premises or in the cloud.

Using only a web browser and limited programming experience, you can rapidly develop and deploy professional applications that are both fast and secure for any device from desktop to mobile. Oracle Application Express combines the qualities of a low code tool such as productivity, ease of use, and flexibility, with the qualities of an enterprise development tool such as security, integrity, scalability, availability and built for the web.

We can install APEX in two different ways.
1. Full development environment
2. Run time environment

Full development environment: A full development environment provides complete access to the Application Builder environment to develop applications.

Run time environment: A run time environment is an appropriate choice for production implementations in which you want to run applications that cannot be modified.

Reference: https://www.oracle.com/technetwork/testcontent/what-is-apex-099128.html

Installation of Oracle APEX:

1. Assumptions
2. Download Software
3. Prerequisites
4. Installation


1. Assumptions:

We assume that already installed Oracle Database 12.1.0.2 in Oracle Enterprise Linux 6.
Please click here to know how to install 12c database if did not install it before.

2. Download Software:

Click here to download Apex 5.0.3 software.

3. Prerequisites:

1. Free space for Oracle Application Express software files on the file system: 625 MB
2. Free space in SYSTEM tablespace: 100 MB

Oracle XML DB must be installed in the Oracle database which we are using to install APEX. If your database is installed with DBCA the XMLDB installed along with database installation.

If you have done the database installation manually we need to create XML DB manually. To create the XML DB we have to run the below script.

$cd $ORACLE_HOME/rdbms/admin


SQL>@catqm.sql


4. Installation:

Step 1: 

Create one tablespace which we can make it as default tablespace while installing APEX.

SQL> create tablespace APEX_DATA datafile '/u02/oradata/SILVER/apex_data01.dbf' size 10m autoextend on maxsize unlimited;

Tablespace created.

SQL>

Step 2:

Change to the directory where downloaded the software and run below script to install APEX.

[oracle@server2 ~]$ cd /u02/softwares/apex

[oracle@server2 apex]$ pwd
/u02/softwares/apex

Connect as sysdba to install APEX.

[oracle@server2 apex]$ sqlplus / as sysdba

SQL*Plus: Release 12.1.0.2.0 Production on Thu Dec 13 18:47:00 2018

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


Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

SQL>

SQL> @apexins.sql <tablespace_Apex>  <tablespace_files>  <tablespace_temp> /i/

SQL> @apexins.sql APEX_DATA APEX_DATA TEMP /i/

Thank you for installing Oracle Application Express 5.0.3.00.03

Oracle Application Express is installed in the APEX_050000 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)

http://host:port/apex/apex_admin     (Oracle REST Data Services)

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)

http://host:port/apex     (Oracle REST Data Services)

PL/SQL procedure successfully completed.

1 row selected.

...null1.sql

SYS> 

Step 3:

Change "Admin" password using below script.

SYS> @apxchpwd.sql 

================================================================================

This script can be used to change the password of an Application Express

instance administrator. If the user does not yet exist, a user record will be

created.

================================================================================

Enter the administrator's username [ADMIN] 

User "ADMIN" exists.

Enter ADMIN's email [ADMIN] 

Enter ADMIN's password [] 

Changed password of instance administrator ADMIN.

SYS> 

Step 4:

Create APEX_LISTENER and APEX_REST_PUBLIC_USER by running below script.

SQL> @apex_rest_config.sql

         

           Synonym created.

 

           Session altered.

PL/SQL procedure successfully completed.

SQL> 

Step 5:

Embedded PL/SQL gateway (EPG) configuration. Use below script to configure PL/SQL Gateway. It loads the images to the database.

SQL> @apex_epg_config.sql <Software base location>

SQL> @apex_epg_config.sql /u02/softwares

            PL/SQL procedure successfully completed.

            Commit complete.

            Directory dropped.

            timing for: Load Images

            Elapsed: 00:01:37.58

            PL/SQL procedure successfully completed.

            Commit complete.

SQL> 

Step 6:

Unlock "ANONYMOUS" user account.

SQL> alter user anonymous account unlock;

User altered.

SQL>

Step 7:

Change XML DB protocol port to non "0" value if it is set to "0"

SYS> SELECT DBMS_XDB.gethttpport FROM DUAL;

GETHTTPPORT

-----------

          0

SYS> 

SQL> exec DBMS_XDB.sethttpport(8080);

PL/SQL procedure successfully completed.

SQL> 

Validation:

Login apex using below url

http://server2.apps.com:8080/apex

Workspace: INTERNAL

Username: admin

Password: <admin user password>

Thanks for your patience to view this post..............