Install Apex 5.1

Install Apex 5.1

1 Download and Unzip the APEX 5.1.4 software

unzip apex_5.1.4.zip -d /u01/app/

2 Create a new tablespace for APEX

CREATE TABLESPACE APEX DATAFILE '/u01/app/12c/database/oradata/prim/apex01.dbf' SIZE 500M;

3 Check if APEX already installed there:

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

no rows selected

4 Instal  APEX 5.1.4

cd /u01/app/apex

SQL> @apexins APEX APEX TEMP /i/


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

USERNAME
--------------------------------------------------------------------------------
CREATED
---------
APEX_PUBLIC_USER
29-OCT-15

APEX_050100
29-OCT-15

APEX_INSTANCE_ADMIN_USER
29-OCT-15


5 Check Installed product information

SQL> SELECT comp_name, version, status FROM dba_registry WHERE comp_id='APEX';

COMP_NAME
--------------------------------------------------------------------------------
VERSION                        STATUS
------------------------------ --------------------------------------------
Oracle Application Express
5.1.4.00.08                    VALID


SQL> select * from apex_release;

VERSION_NO
--------------------------------------------------------------------------------
API_COMPATIBILITY
--------------------------------------------------------------------------------
PATCH_APPLIED
--------------------------------------------------------------------------------
5.1.4.00.08
2016.08.24
APPLIED


Configure APEX:


SQL> @apex_epg_config.sql /u01/app

PL/SQL procedure successfully completed.


6 Unlock below APEX related user account

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

7 Increase shared server and job_queue_processes

SQL> SHOW PARAMETER job_queue_processes

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
job_queue_processes                  integer     1000
SQL> SHOW PARAMETER shared_servers

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
max_shared_servers                   integer
shared_servers                       integer     5

8 Execute apxconf.sql to complete final configuration

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 []
Created instance administrator ADMIN.

Enter a port for the XDB HTTP listener [      8080]
...changing HTTP Port
SQL>  select dbms_xdb.gethttpport from dual;

GETHTTPPORT
-----------
       8080


9 Check if APEX services registered with listener or not

[oracle@stand apex]$  lsnrctl status

LSNRCTL for Linux: Version 12.1.0.2.0 - Production on 29-OCT-2019 12:59:35

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

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias                     LISTENER_TEST
Version                   TNSLSNR for Linux: Version 12.1.0.2.0 - Production
Start Date                29-OCT-2019 10:53:33
Uptime                    0 days 2 hr. 6 min. 2 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/app/12c/database/dbhome_2/network/admin/listener.ora
Listener Log File         /u01/app/12c/database/diag/tnslsnr/stand/listener_test/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521))(QUEUESIZE=50))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=stand.som.com)(PORT=1521))(QUEUESIZE=50))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=stand.som.com)(PORT=8080))(Presentation=HTTP)(Session=RAW))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=stand.som.com)(PORT=5500))(Security=(my_wallet_directory=/u01/app/12c/database/dbhome_2/admin/prim/xdb_wallet))(Presentation=HTTP)(Session=RAW))
Services Summary...
Service "prim.som.com" has 1 instance(s).
  Instance "test", status READY, has 1 handler(s) for this service...
Service "primXDB.som.com" has 1 instance(s).
  Instance "test", status READY, has 1 handler(s) for this service...
The command completed successfully


Login to below  Apex url :

http://stand.som.com:8080/apex/apex_admin

Make sure you have hosts entry and firewall off to access above url


Thanks,