Skip to main content

Oracle Application Express (APEX) Upgradation from 23.2 to 24.1


  • Introduction: In this article, we will see the upgradation of Oracle APEX from 23.2 to 24.1 step-by-step.

  • Prerequisites:
    • Please refer to APEX 23.2 installation and complete the installation.
    • Kindly stop the previous running APEX by killing ORDS PID.
    • Also take full DB backup for rollback purpose.

  • Let's start the 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
SQL> col username for a30
SQL> col account_status for a30
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                    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
SQL> col API_COMPATIBILITY for a20
SQL> col PATCH_APPLIED for a20
SQL> 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


Thank you for reading!

I hope this content has been helpful to you. Your feedback and suggestions are always welcome — feel free to leave a comment or reach out with any queries.

Abhishek Shrivastava

📧 Email: oraeasyy@gmail.com
🌐 Website: www.oraeasy.com

Follow Us

Comments

Post a Comment

↑