Oracle Application Express 18.1 Installation

                                              Oracle Application Express 18.1 Installation

Installation Requires:-

Oracle Application Express release 18.1 requires an Oracle Database release 11.2.0.4 or later, including Enterprise Edition and Express Edition (Oracle Database XE).

Download APEX 18.1 software Here 

Click Accept button and download the Oracle APEX 18.1.0 software.

Step 1:-Unzip the APEX 18.1.0.00.45 software:

unzip apex_18.1.zip -d /oradb/

Step 2:-Create a new APEX tablespace,

CREATE TABLESPACE APEX DATAFILE ‘/oradb/app/oracle/oradata/clone/apex01.dbf’ SIZE 1G;

Step 3:-Check the Oracle Application Express  is installed:

SELECT comp_name, version, status FROM dba_registry WHERE comp_id=’APEX’;

no rows selected

Step 4:-Installation of APEX 18.1:-

SQL> @apexins APEX APEX TEMP /i/

Where:
apex_tbs – name of the tablespace for the APEX user.
apex_files_tbs – name of the tablespace for APEX files user.
temp_tbs – name of the temporary tablespace.
images – virtual directory for APEX images. Define the virtual image directory as /i/ for future updates. */

The above script create some SCHEMA on Database, you can test by querying view ALL_USERS.

SQL> select username,created from all_users where USERNAME like ‘%APEX%’;

USERNAME                                                         CREATED
—————————————-
APEX_PUBLIC_USER                                    29-MAY-18
APEX_180100                                                    29-MAY-18
APEX_INSTANCE_ADMIN_USER          29-MAY-18

Step 5:-Check the VERSION and STATUS is installed,

SELECT comp_name, version, status FROM dba_registry WHERE comp_id=’APEX’;

COMP_NAME                                   VERSION           STATUS
——————————————-
Oracle Application Express      18.1.0.00.45             VALID

Step 6:-Check APEX RELEASE VERSION:

select * from apex_release;

VERSION_NO             API_COMPAT        PATCH_APPL
———- ———- ———————
18.1.0.00.45                 2018.04.04                     APPLIED

Configuring APEX:
Step 7:-Run the Embedded PL/SQL Gateway configuration (EPG)

This script will load the Application Express images into XDB,
@apex_epg_config.sql <parent of apex directory>

SQL> @apex_epg_config.sql /oradb

Step 8:-Make sure that the following accounts are unlocked:

ALTER USER anonymous ACCOUNT UNLOCK;
ALTER USER xdb ACCOUNT UNLOCK;
ALTER USER apex_public_user ACCOUNT UNLOCK;
ALTER USER flows_files ACCOUNT UNLOCK;

Step 9:-Configure database parameters for APEX:

SHOW PARAMETER job_queue_processes

NAME                                    TYPE                 VALUE
———————————–
job_queue_processes integer                4000

SHOW PARAMETER shared_servers

NAME                                 TYPE                  VALUE
———————————–
max_shared_servers integer
shared_servers              integer                      1

Change the shared_servers parameter:

ALTER system SET shared_servers=5 scope=both;

Step 10:-Used to perform the final configuration steps for Oracle Application Express, including setting the XDB HTTP listener port and Application Express ADMIN password.

To user, you can use ADMIN by default, and email can be skipped.

Also you can change the HTTP port.But default port is 8080.

SQL>@/oradb/apex/apxconf.sql

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.

=========================================================
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” does not yet exist and will be created.
Enter ADMIN’s email [ADMIN]
Enter ADMIN’s password []
Created instance administrator ADMIN.

Enter a port for the XDB HTTP listener [ 8080]
…changing HTTP Port

APEX configuration has been completed.

Step 11:-Check the HTTP port:

SQL> select dbms_xdb.gethttpport from dual;

GETHTTPPORT
———–
8080

Step 12:-Check the listener status and HTTP port is enabled,

[oracle@clone:apex clone] lsnrctl status

LSNRCTL for Linux: Version 12.2.0.1.0 – Production on 29-MAY-2018 19:20:08

Copyright (c) 1991, 2016, Oracle. All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=clone.localdomain.com)(PORT=1521)))
STATUS of the LISTENER
————————
Alias LISTENER
Version TNSLSNR for Linux: Version 12.2.0.1.0 – Production
Start Date 25-MAY-2018 21:52:41
Uptime 3 days 21 hr. 27 min. 26 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /oradb/app/oracle/product/12.2.0.1/db_1/network/admin/listener.ora
Listener Log File /oradb/app/oracle/diag/tnslsnr/clone/listener/alert/log.xml
Listening Endpoints Summary…
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=clone.localdomain.com)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=clone.localdomain.com)(PORT=5500))(Security=(my_wallet_directory=/oradb/app/oracle/admin/CLONE/xdb_wallet))(Presentation=HTTP)(Session=RAW))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=clone.localdomain.com)(PORT=8080))(Presentation=HTTP)(Session=RAW))
Services Summary…
Service “CLONE.localdomain.com” has 1 instance(s).
Instance “clone”, status READY, has 1 handler(s) for this service…
Service “cloneXDB.localdomain.com” has 1 instance(s).
Instance “clone”, status READY, has 1 handler(s) for this service…
The command completed successfully

Administration Services login page:

Step 13:-In Browser,Login as a ADMIN user:-

http://clone.localdomain.com:8080/apex/apex_admin

You have successfully logged into the Oracle APEX 18.1

 

Catch Me On:- Hariprasath Rajaram

LinkedIn:                  https://www.linkedin.com/in/hari-prasath-aa65bb19/
Facebook:                 https://www.facebook.com/HariPrasathdba
Facebook Group:   https://www.facebook.com/groups/894402327369506/
Facebook Page:      https://www.facebook.com/dbahariprasath/?
Twitter:                     https://twitter.com/hariprasathdba

 

 

 

 

 

4 thoughts on “Oracle Application Express 18.1 Installation”

Leave a Reply

Your email address will not be published. Required fields are marked *