APEX INSTALLATION 18
Download the software
[oracle@localhost
~]$ wget -O apex_18.1.zip
https://download.oracle.com/otn/java/appexpress/apex_18.1.zip?AuthParam=1616946282_d2dd2313684dbf4274c4b77f5ad0434c
--2021-03-28
11:43:03--
https://download.oracle.com/otn/java/appexpress/apex_18.1.zip?AuthParam=1616946282_d2dd2313684dbf4274c4b77f5ad0434c
Resolving
download.oracle.com (download.oracle.com)... 2.22.72.113
Connecting
to download.oracle.com (download.oracle.com)|2.22.72.113|:443... connected.
HTTP
request sent, awaiting response... 200 OK
Length:
149875516 (143M) [application/zip]
Saving
to: ‘apex_18.1.zip’
100%[====================================================================================================>]
149,875,516 3.81MB/s in 40s
2021-03-28
11:43:45 (3.56 MB/s) - ‘apex_18.1.zip’ saved [149875516/149875516]
Unzip the software
[oracle@localhost
~]$ unzip apex_18.1.zip -d /u01/oracle/apex/
[oracle@localhost apex]$ ls
apex_epg_config_cdb.sql apex_rest_config_cdb.sql apxdvins_cdb.sql apxpatch.sql apxrtins_cdb_upg.sql coreins3.sql
apex_epg_config_core.sql
apex_rest_config_core.sql apxdvins_nocdb.sql apxrelod.sql apxrtins_nocdb.sql coreins4.sql
apex_epg_config_nocdb.sql apex_rest_config_nocdb.sql apxdvins.sql apxremov1.sql apxrtins.sql coreins5.sql
apex_epg_config.sql apex_rest_config.sql apxe101.sql apxremov2.sql apxsdoins.sql coreins.sql
Create the Tablespace
SQL>
CREATE TABLESPACE APEX DATAFILE '/u01/app/oracle/oradata/ranesh/apex01.dbf'
SIZE 2G;
Tablespace
created.
Check the APEX is installed or
not
SQL> SELECT comp_name, version, status FROM
dba_registry WHERE comp_id='APEX';
[oracle@localhost
~]$ chmod -R 775 apex
[oracle@localhost
~]$ chmod -R 775 apex_18.1.zip
[oracle@localhost
apex]$ sqlplus / as sysdba
SQL*Plus:
Release 19.0.0.0.0 - Production on Sun Mar 28 12:07:19 2021
Version
19.3.0.0.0
Copyright
(c) 1982, 2019, Oracle. All rights
reserved.
Connected
to:
Oracle
Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version
19.3.0.0.0
Installation
of APEX 18.1:-
SQL>
@apexins APEX APEX TEMP /i/
...set_appun.sql
PL/SQL
procedure successfully completed.
Thank
you for installing Oracle Application Express 18.1.0.00.45
Oracle
Application Express is installed in the APEX_180100 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)
timing
for: Phase 3 (Switch)
Elapsed:
00:02:13.35
timing
for: Complete Installation
Elapsed:
00:12:39.66
PL/SQL
procedure successfully completed.
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 28-MAR-21
APEX_180100 28-MAR-21
APEX_INSTANCE_ADMIN_
28-MAR-21
USER
Check the VERSION and STATUS is installed,
SQL>
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
Check APEX RELEASE VERSION:
SQL>
select * from apex_release;
VERSION_NO API_COMPATIBILITY PATCH_APPLIED
18.1.0.00.45 2018.04.04 APPLIED
Configuring APEX
This script will load the Application Express images into XDB
SQL>
@apex_epg_config.sql /u01/oracle/apex
Loading images directory:
/home/oracle/apex/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:07:43.20
Make sure that the following accounts are unlocked:
SQL>
ALTER USER anonymous ACCOUNT UNLOCK;
User
altered.
SQL>
ALTER USER xdb ACCOUNT UNLOCK;
User
altered.
SQL>
ALTER USER apex_public_user ACCOUNT UNLOCK;
User
altered.
SQL>
ALTER USER flows_files ACCOUNT UNLOCK;
User
altered.
Configure database parameters for APEX
SQL>
SHOW PARAMETER job_queue_processes
NAME TYPE VALUE
------------------------------------
----------- ------------------------------
job_queue_processes integer 80
SQL>
SHOW PARAMETER shared_servers
NAME TYPE VALUE
------------------------------------
----------- ------------------------------
max_shared_servers integer
shared_servers integer 1
Change the shared_servers parameter:
SQL> ALTER system SET
shared_servers=5 scope=both;
System altered.
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> @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 [] Hadev$123
Created instance administrator ADMIN.
Enter a port for the XDB HTTP listener
[ 8080]
...changing HTTP Port
Check
the HTTP port:
SQL> select dbms_xdb.gethttpport from
dual;
GETHTTPPORT
-----------
8080
Lsnrctl status
[oracle@localhost apex]$ lsnrctl status
LSNRCTL for Linux: Version 19.0.0.0.0 -
Production on 28-MAR-2021 12:59:54
Copyright (c) 1991, 2019, Oracle. All rights reserved.
Connecting to
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.76)(PORT=1529)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version
19.0.0.0.0 - Production
Start Date 28-MAR-2021 11:02:00
Uptime 0 days 1 hr. 57 min. 54 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /home/app/oracle/product/19.0.0/db_home/network/admin/listener.ora
Listener Log File
/home/app/oracle/diag/tnslsnr/localhost/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.1.76)(PORT=1529)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1529)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=8080))(Presentation=HTTP)(Session=RAW))
Services Summary...
Service "hadev" has 2
instance(s).
Instance "hadev", status UNKNOWN, has 1 handler(s) for this
service...
Instance "hadev", status READY, has 1 handler(s) for this
service...
Service "hadevXDB" has 1
instance(s).
Instance "hadev", 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://localhost.com:8080/apex/apex_admin