How to apply patch?

[admin]

Oracle APEX 24.2 Patch 16 is a cumulative patch. This means it includes all fixes and updates from the previous patches in the 24.2 release series.

If you are currently on version 24.2.1/24.2.10 and want to upgrade to 24.2.16, you only need to apply Patch 16. There is no requirement to install each intermediate patch separately.

# (III) Patch Installation Instructions
# -------------------------------------
# To apply the patch:
#
# 1. Download the p37366599_242_GENERIC.zip patch set installation archive to a directory that is not the Oracle home directory or under the Oracle home directory.
#
# 2. Unzip and extract the installation files by double-clicking p37366599_242_GENERIC.zip in a Microsoft Windows based system, or entering the following command to unzip on a UNIX or Linux based system:
#
# $ unzip p37366599_242_GENERIC.zip
#
# 3. Preventing Access to Oracle REST Data Services
#
# It is important that no developers or end users access Oracle APEX while you are applying the patch. This section describes how to prevent access to Oracle APEX.
#
# Stopping Oracle REST Data Services:
#
# To learn more about stopping the Oracle REST Data Services server, see Oracle REST Data Services Installation and Configuration Guide:
#
# https://docs.oracle.com/en/database/ora ... index.html
#
# 4. Set your current directory to the "37366599" directory where you unzipped the p37366599_242_GENERIC.zip file.
#
# 5. Set the NLS_LANG environment variable, making sure that the character set is AL32UTF8. For example:
#
# Bourne or Korn shell:
#
# NLS_LANG=American_America.AL32UTF8
# export NLS_LANG
#
# C shell:
#
# setenv NLS_LANG American_America.AL32UTF8
#
# For Windows based systems:
#
# set NLS_LANG=American_America.AL32UTF8
#
# 6. Connect to the database where Oracle APEX is installed as the SYS user and run catpatch.sql or catpatch_con.sql as in the following examples:
#
# sql "sys/ as sysdba" @catpatch.sql -- for non-CDB and for CDB where Oracle APEX is not installed in the root, and for PDB where APEX is not installed in the root
# sql "sys/ as sysdba" @catpatch_con.sql -- for CDB where Oracle APEX is installed in the root
# sql "sys/ as sysdba" @catpatch_appcon.sql -- for installations where Oracle APEX is installed in an application container
#
# 7. Install the Patch Set Exception's changes in the images directory
#
# Copy the images directory of the patch to the /images folder of the Oracle APEX installation directory images sub directory.
#
# Assuming the p37366599_242_GENERIC.zip file was unzipped to c:\temp on Windows and /tmp on Linux
#
# On a Windows system, run a command from a command prompt similar to the following example:
#
# xcopy /E /I c:\temp\images ORACLE_APEX_HOME\apex\images
#
# On UNIX or Linux based systems, run a command similar to the following example:
#
# cp -rf /tmp/images ORACLE_APEX_HOME/apex
#
# In the preceding syntax examples, ORACLE_APEX_HOME is the existing Oracle APEX installation location. For example, c:\oracle\apex_24.2 on Windows and /oracle/apex_24.2 on Linux.
#
# 8. Starting Oracle APEX
#
# - Starting Oracle REST Data Services
#
# To learn more about starting the Oracle REST Data Services server, see Oracle REST Data Services Installation and Configuration Guide:
#
# https://docs.oracle.com/en/database/ora ... index.html
#
#
# (IV) New APEX 24.2 Content Delivery Network (CDN)
# -------------------------------------------------
# APEX 24.2 static resources are available on a CDN, https://static.oracle.com/cdn/apex/24.2.16/.
# - The CDN contains the production APEX 24.2.0 static resources and the updated static resources included in 24.2.1, 24.2.2, 24.2.3, 24.2.4, 24.2.5, 24.2.6, 24.2.7, 24.2.8, 24.2.9, 24.2.10, 24.2.11, 24.2.12, 24.2.13, 24.2.14, 24.2.15 and 24.2.16.
#
# I. Instance using the APEX CDN
#
# If your instance is currently using the APEX CDN, this patch automatically updates the CDN reference to the 24.2.16 version. No further action needed.
#
# II. Instance not yet using the APEX CDN
#
# If you wish to convert your instance to use the static resources from the 24.2.16 CDN, you will need to reset the APEX images prefix for your instance. This change can be performed on a live system.
#
# To convert an instance to use the CDN:
#
# - Set your current directory to the directory where the production APEX 24.2 zipfile was extracted. For example, c:\temp\apex_ on Windows and /tmp/apex_ on Linux.
#
# - Navigate to the apex/utilities subdirectory of the production APEX 24.2 directory. For example, /tmp/apex_/apex/utilities
#
# - Connect to the database where Oracle APEX is installed as SYS and run reset_image_prefix.sql, as in the following example:
#
# sql "sys/ as sysdba" @reset_image_prefix.sql
#
# - When prompted for the image prefix, enter the CDN path, as follows:
#
# https://static.oracle.com/cdn/apex/24.2.16/
#
# III. Use the APEX CDN in a single APEX application
#
# If you wish to use the APEX CDN in a single APEX application:
#
# - In App Builder, edit your application and click "Shared Components"
#
# - Click "User Interface Attributes"
#
# - Under Advanced, in the #APEX_FILES# Path enter as follows:
#
# https://static.oracle.com/cdn/apex/24.2.16/
#
# - Click "Apply Changes"
#
#
# (V) To confirm the patch has been applied
# -----------------------------------------
#
# I. Review the Product Build number on your instance
#
# - Log into your workspace.
#
# - Review the Product Build number displayed in the lower right corner.
#
# If your instance has been patched, the build number will be 24.2.x, where x is the PATCH_VERSION. For example, 24.2.16.
# In your instance has not been patched, the build number will be 24.2.x.
#
# II. Review the About dialog on your instance
#
# - Log into your workspace.
#
# - Click 'Help' > 'About'.
#
# - Review the Details section:
#
# 'Patch Version' will display the version of the patch installed.
# 'Last Patch Time' will display the patch installation date and time.
# These values will only be visible on a patched instance.
#
# III. Start SQLcl and connect to the database where Oracle APEX is installed as SYS. For example:
#
# - On Windows:
#
# SYSTEM_DRIVE:\> sql /nolog
# SQL> CONNECT SYS as SYSDBA
# Enter password:
#
# - On UNIX and Linux:
#
# $ sql /nolog
# SQL> CONNECT SYS as SYSDBA
# Enter password:
#
# Enter the following statement to verify the patch with patch_number 37366599 has been installed:
#
# select patch_version, installed_on
# from apex_patches
# where patch_number = 37366599
# order by installed_on;
#
# Multiple rows will be returned if earlier versions of this patch have been installed.
#
#
# EOF README.txt