Oracle Application Express (APEX) Upgradation from 23.2 to 24.1

Prerequisites:
1. Please refer to APEX 23.2 installation and complete the installation.
2. Kindly stop the previous running Apex by killing ords pid.
3. Also take full DB backup for rollback purpose.

Upgrading Apex from 23.2 to 24.1

1. Create directory and place the Apex 24.1 software:

[oracle@apex oracle]$ mkdir apex24_1
[oracle@apex oracle]$
[oracle@apex oracle]$ cd apex24_1
[oracle@apex apex24_1]$ pwd
/u02/app/oracle/apex24_1
[oracle@apex apex24_1]$ ls
apex_24.1.zip
[oracle@apex apex24_1]$ cd apex
[oracle@apex apex]$ pwd
/u02/app/oracle/apex24_1/apex

2. Create a tablespace:

SQL> show pdbs
CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       READ ONLY  NO
         3 APEXPDB                        READ WRITE NO

SQL> alter session set container=APEXPDB;
Session altered.

SQL> create tablespace APEX241 datafile '/u02/app/oracle/oradata/APEXDB/apexpdb/apex241_01.dbf' size 500m autoextend on;
Tablespace created.

3. Run the installation script:

SQL> @apexins.sql APEX241 APEX241 TEMP /i/
...set_appun.sql
PL/SQL procedure successfully completed.
...set_ufrom_and_upgrade.sql
PL/SQL procedure successfully completed.
Session altered.
FOO3
------------------------------
install2024-09-25_04-11-58.log
. ORACLE
. Oracle APEX Installation.
..
Thank you for installing Oracle APEX 24.1.0
Oracle APEX is installed in the APEX_240100 schema.
The structure of the link to the Oracle APEX administration services is as follows:
http://host:port/ords/apex_admin
The structure of the link to the Oracle APEX development interface is as follows:
http://host:port/ords
timing for: Phase 3 (Switch)
Elapsed:    1.68
timing for: Complete Installation
Elapsed:   15.73

4. Check the user, APEX version, and image prefix:

SQL> set lines 333 pages 333
col username for a30
col account_status for a30
select username, account_status from dba_users where username like '%APEX%';

USERNAME                       ACCOUNT_STATUS
------------------------------ ------------------------------
APEX_LISTENER                  OPEN
APEX_PUBLIC_USER               OPEN
APEX_REST_PUBLIC_USER          OPEN
APEX_PUBLIC_ROUTER             OPEN
APEX_230200                    OPEN
APEX_240100                    LOCKED

6 rows selected.

SQL> alter user APEX_240100 identified by Apex#123 account unlock;
User altered.

SQL> select username, account_status from dba_users where username like '%APEX%';

USERNAME                       ACCOUNT_STATUS
------------------------------ ------------------------------
APEX_LISTENER                  OPEN
APEX_PUBLIC_USER               OPEN
APEX_REST_PUBLIC_USER          OPEN
APEX_PUBLIC_ROUTER             OPEN
APEX_230200                    OPEN
APEX_240100                    OPEN

6 rows selected.

SQL> select username, account_status from dba_users where username like '%ORDS%';

USERNAME                       ACCOUNT_STATUS
------------------------------ ------------------------------
ORDS_PUBLIC_USER               OPEN
ORDS_METADATA                  OPEN
ORDSYS                         LOCKED

SQL> col VERSION_NO for a20
col API_COMPATIBILITY for a20
col PATCH_APPLIED for a20
select * from apex_release;

VERSION_NO           API_COMPATIBILITY    PATCH_APPLIED
-------------------- -------------------- --------------------
24.1.0               2024.05.31           APPLIED

SQL> select * from apex_instance_parameters where name='IMAGE_PREFIX';

NAME                          VALUE                                                           CREATED_O  LAST_UPDA
--------------------- ------------------------------------------------------------ -----------         --------
IMAGE_PREFIX      https://static.oracle.com/cdn/apex/24.1.0/     25-SEP-24 25-SEP-24

5. Update the ORDS images directory:

[oracle@apex ords]$ pwd
/u02/app/oracle/ords
[oracle@apex ords]$ ls
bin     docs      icons   lib          linux-support  nohup.out   ords-latest.zip  scripts
config  examples  images  LICENSE.txt  logs           NOTICE.txt  ords.war         THIRD-PARTY-LICENSES.txt

[oracle@apex ords]$ mv images images_23_2

[oracle@apex apex]$ pwd
/u02/app/oracle/apex24_1/apex

[oracle@apex apex]$ cp -r images/ /u02/app/oracle/ords/

6. Start the ORDS service:

nohup ords --config /u02/app/oracle/ords/config serve &
  

7. Access the Apex via browser:
http://192.168.101.7:8080/ords/
http://192.168.101.7:8080/ords/apex_admin


Apex Home

Workspace Login

Apex Admin Login

Admin Home

Manage Workspace

Thanks for visiting!!