DBA Hub

📋Steps in this guide1/3

Oracle Application Express (APEX) Patches (4.2, 5.0, 5.1)

This article describes how to patch minor version numbers of APEX.

oracle miscconfigurationintermediate
by OracleDba
12 views
1

Apply Patch

Log into My Oracle Support and download the relevant patch. In this case it is the 5.1.1 patch. - 4.2.6 : Patch 19595896 - p19595896_426_Generic.zip - 5.0.1 : Patch 21364820 - p21364820_501_Generic.zip - 5.0.2 : Patch 21805060 - p21805060_502_Generic.zip - 5.0.3 : Patch 22298106 - p22298106_503_Generic.zip - 5.0.4 : Patch 23192730 - p23192730_504_Generic.zip - 5.1.1 : Patch 25341386 - p25341386_511_Generic.zip - 5.1.2 : Patch 25786300 - p25786300_512_Generic.zip - 5.1.3 : Patch 26359202 - p26359202_513_Generic.zip - 5.1.4 : Patch 26795231 - p26795231_514_Generic.zip Unzip it and switch to the "patch" directory. Log in as SYS in the non-CDB instance or in the pluggable database and run the "apxpatch.sql" script.

Code/Command (click line numbers to comment):

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
cd /tmp
#unzip p19595896_426_Generic.zip
#unzip p21364820_501_Generic.zip
#unzip p21805060_502_Generic.zip
#unzip p22298106_503_Generic.zip
#unzip p23192730_504_Generic.zip
#unzip p25341386_511_Generic.zip
#unzip p25786300_512_Generic.zip
#unzip p26359202_513_Generic.zip
unzip p26795231_514_Generic.zip
cd patch

sqlplus / as sysdba

-- For PDB only.
ALTER SESSION SET CONTAINER=pdb1;

@apxpatch.sql
2

Update Images

Update the images in the relevant location. If you are using the embedded PL/SQL gateway, you will run the following command, using the correct path to the patch directory. If you are using the Oracle HTTP server, you will need to copy the images over your existing ones. If you are running using the Oracle REST Data Services, use the relevant documentation for your release to determine how to update the images.

Code/Command (click line numbers to comment):

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
sqlplus / as sysdba

-- For PDB only.
ALTER SESSION SET CONTAINER=pdb1;

-- May be necessary for databases with NLS_LENGTH_SEMANTICS = CHAR set.
-- ALTER SESSION SET NLS_LENGTH_SEMANTICS = BYTE;

@apxldimg.sql /tmp/patch

# Switch to the appropriate directory in the HTTP server.
cd /u01/app/oracle/middleware/FR_inst/config/OHS/ohs1/htdocs/images/apex_images

# Copy files from local path.
cp -r /tmp/patch/images/* .

# Copy files from remote path.
scp -r oracle@my-server:/home/oracle/apex/patch/images/* .
3

Post Upgrade

After applying the 5.0.0 to 5.0.1 patch I started to get warnings about images not being configured correctly, even though they were. I cleared the browser cache and this went away. Provided you did the static files configuration correctly during the APEX 5.0 installation, clearing the cache should be all you need to do. For more information see: - Oracle Application Express - Patch Set Notes (4.2.6) - Oracle Application Express - Patch Set Notes (5.0.1) - Oracle Application Express - Patch Set Notes (5.0.2) - Oracle Application Express (APEX) Installation - APEX Articles Hope this helps. Regards Tim...

Comments (0)

Please to add comments

No comments yet. Be the first to comment!