Oracle
Application Express 23.2 Installation Steps
Before installing
Oracle Application Express, you must verify your configuration meets the
minimum installation requirements.
•
Oracle Database Requirements
Oracle
Application Express release 23.2 requires an Oracle Database release 19c or
later, including Enterprise Edition and Standard Edition (SE) and Database 23c Free.
Oracle Application Express can be installed in single-instance database and in
Oracle Real Application Clusters (Oracle RAC) database.
· Browser
Requirements
Oracle APEX requires a JavaScript-enabled browser and supports the current
and prior major release of Google Chrome, Mozilla Firefox, Apple Safari, and
Microsoft Edge.
· Web
Server Requirements
Oracle APEX requires Oracle REST Data Services (ORDS) 20.x or
later. The use of Quick SQL requires Oracle REST Data Services (ORDS)
23.3 or later.
• MEMORY_TARGET of the Target Database
Oracle
Application Express requires the system global area (SGA) and program global
area (PGA) to be at least 300 MB.
•
Checking the WORKAREA_SIZE_POLICY of the
Target Database
For the Oracle APEX installation or upgrade process, the WORKAREA_SIZE_POLICY session parameter must be set to AUTO.
SQL> alter system set WORKAREA_SIZE_POLICY=auto
scope=both;
• Oracle XML DB Requirement
Oracle XML DB
must be installed in the Oracle database that you want to use if you are
installing a full development environment. Oracle XML DB is not required for
runtime only installations. If you are using a preconfigured database created
either during an installation or by Database Configuration Assistant (DBCA),
Oracle XML DB is already installed and configured.
Download Link: -
Oracle Application Express can be downloaded from HERE
Environment details: -
OS | RHEL 7.9 |
IP | 192.168.0.106 |
HOSTNAME | Server3.soumya.com |
APEX VERSION | 23.2 |
DB VERSION | 19.3.0 |
Once downloaded, unzip the software to begin the
installation.
Create a directory where the apex software will be
installed.
[oracle@server3 u01]$ mkdir -p /u01/apex
[oracle@server3 apex]$ unzip apex_23.2.zip -d /u01/apex
Create a new tablespace
for APEX.
|
[oracle@server3 apex]$ sqlplus / as
sysdba
SQL> create tablespace APEX
datafile '/u01/app/oradata/ORCL/apexd01.dbf' size 2G autoextend on;
|
Apex
Installation: -
|
[oracle@server3
apex]$ cd /u01/apex/apex
[oracle@ocisoumya
apex]$sqlplus / as sysdba
SQL>@apexins.sql APEX APEX TEMP /i/ -- i refers image location in application.
APEX refers the tablespace name , TEMP refers the temporary tablespace name.
|
Once the installation is complete, confirm it by running
following query
|
SYS> SELECT comp_name, version,
status FROM dba_registry WHERE comp_id='APEX';
COMP_NAME
VERSION
STATUS
------------------------------
------------------------------ -----------
Oracle APEX 23.2.0
VALID
|
To change the admin password using “apxchpwd.sql” script as
sys user.
|
SQL>
@apxchpwd.sql
...set_appun.sql
================================================================================
This
script can be used to change the password of an Oracle APEX
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.
|
For configuring static files, we must run apex_rest_config.sql after a
new installation of Oracle APEX.
|
SQL> @apex_rest_config.sql
Enter a password for the APEX_LISTENER user []
Enter a password for the APEX_REST_PUBLIC_USER user []
...set_appun.sql
...setting session environment
...create APEX_LISTENER and APEX_REST_PUBLIC_USER users
...grants for APEX_LISTENER and ORDS_METADATA user
|
Configure APEX
Now
there are two ways which we can use to access APEX.
1. Oracle REST Data Services(ORDS)
2. Embeded PL/SQL Gateway(EPG) Configuration
However Oracle recommendation is
ORDS.
create a custom
profile and assign the profile to
standard users to avoid user lock issues.
|
CREATE PROFILE app_user1 LIMIT
FAILED_LOGIN_ATTEMPTS unlimited
PASSWORD_LIFE_TIME unlimited
PASSWORD_REUSE_TIME unlimited
PASSWORD_REUSE_MAX unlimited
PASSWORD_VERIFY_FUNCTION NULL
PASSWORD_LOCK_TIME unlimited
PASSWORD_GRACE_TIME unlimited;
|
Alter all apex related users to assign custom profile.
|
select
username,account_status from dba_users where username like ('%APEX%');
ALTER
USER APEX_230200 PROFILE app_user1;
ALTER
USER APEX_LISTENER PROFILE app_user1;
ALTER
USER APEX_REST_PUBLIC_USER PROFILE app_user1;
ALTER
USER APEX_PUBLIC_USER PROFILE
app_user1;
|
Unlock the users:-
|
ALTER
USER APEX_LISTENER identified by Concept_ora1 account unlock;
ALTER
USER APEX_REST_PUBLIC_USER identified by Concept_ora1 account unlock;
ALTER
USER APEX_PUBLIC_USER identified by
Concept_ora1 account unlock;
|
Execute following to grant connect privileges to any host for the APEX_230200 database user. This
example assumes you connected to the database where Oracle Application Express
is installed as SYS specifying the SYSDBA role.
|
BEGIN
DBMS_NETWORK_ACL_ADMIN.append_host_ace (
host => '*',
ace => xs$ace_type(privilege_list
=> xs$name_list('connect','resolve'),
principal_name
=> 'APEX_230200',
principal_type
=> xs_acl.ptype_db));
END;
/
|
