Oracle Application Express 18.1 Installation
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