Posted by Its always nice to get fixes to bug just in time for christmas. A while ago I posted an example of using external tables to act as mechanism to check for patches on My Oracle Support. Using this table, I run a simple query every few days to see if new APEX patches are available, and lo and behold…
So I downloaded the patch (32006852), and I’ve applied it as per the output below without any incident.
As always, check the detailed patch instructions in the README.txt, but its typically just a SQL Plus script and re-copying the updated ‘images’ directory associated with the patch
Happy Patching!
SQL> conn /@db19_pdb1 as sysdba
Connected.
SQL> @catpatch
. ORACLE
.
. Application Express (APEX) 20.2.0.00.20
. Patch Set Exception 32006852
........................................
APEX_VERSION
------------------------------
APEX_SCHEMA
--------------------------------------------------------------------------------------------------------------------------------
20.2.0.00.20
APEX_200200
PL/SQL procedure successfully completed.
Session altered.
APEX_SCHEMA
--------------------------------------------------------------------------------------------------------------------------------
APEX_200200
... Disabling Jobs
... disabling ORACLE_APEX_AUTOMATIONS
... disabling ORACLE_APEX_BACKUP
... disabling ORACLE_APEX_DAILY_MAINTENANCE
... disabling ORACLE_APEX_DICTIONARY_CACHE
... disabling ORACLE_APEX_ISSUE_EMAILS
... disabling ORACLE_APEX_MAIL_QUEUE
... disabling ORACLE_APEX_PURGE_SESSIONS
... disabling ORACLE_APEX_REST_SOURCE_SYNC
... disabling ORACLE_APEX_WS_NOTIFICATIONS
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
...wwv_dbms_sql_APEX_200200
Package body created.
No errors.
PL/SQL procedure successfully completed.
Session altered.
...patch_32063008.sql
Table altered.
Table altered.
Grant succeeded.
...wwv_flow_db_env_detection.plb
Package body created.
No errors.
... wwv_flow_db_version is up to date
PL/SQL procedure successfully completed.
...wwv_flow_asn1.sql
Package created.
No errors.
...wwv_flow_public_key_util.sql
Package created.
No errors.
...wwv_flow_asn1.plb
Package body created.
No errors.
...wwv_flow_public_key_util.plb
Package body created.
No errors.
...wwv_flow_api
Package body created.
No errors.
...wwv_flow_meta_data
Package body created.
No errors.
wwv_render_report3.plb
Package body created.
No errors.
...wwv_flow_authentication_social.plb
Package body created.
No errors.
...wwv_flow_automation.plb
Package body created.
No errors.
...wwv_flow_card_region
Package body created.
No errors.
...wwv_flow_cdn
Package body created.
No errors.
...wwv_flow_cgi.plb
Package body created.
No errors.
...wwv_flow_data_export.plb
Package body created.
No errors.
...wwv_flow_data_parser.plb
Package body created.
No errors.
...wwv_flow_dynamic_exec
Package body created.
No errors.
...wwv_flow_error
Package body created.
No errors.
...wwv_flow_escape
Package body created.
No errors.
...wwv_flow_exec_web_src_http.plb
Package body created.
No errors.
...wwv_flow_exec_web_src_ords.plb
Package body created.
No errors.
...wwv_flow_exec_web_src_adfbc.plb
Package body created.
No errors.
...wwv_flow_exec_web_src_utils.plb
Package body created.
No errors.
...wwv_flow_fnd_user_int
Package body created.
No errors.
...wwv_flow_instance_admin
Package body created.
No errors.
...wwv_flow_interactive_grid
Package body created.
No errors.
...wwv_flow_ir_render
Package body created.
No errors.
Package body created.
No errors.
...wwv_flow_maint
Package body created.
No errors.
...wwv_flow_page
Package body created.
No errors.
...wwv_flow_region
Package body created.
No errors.
...wwv_flow_security
Package body created.
No errors.
...wwv_flow_web_src_sync.plb
Package body created.
No errors.
...wwv_flow_xlsx.plb
Package body created.
No errors.
...wwv_flow_utilities
Package body created.
No errors.
...patch_32077747.sql
1 row updated.
Commit complete.
...patch_32214154.sql
PL/SQL procedure successfully completed.
0 rows updated.
PL/SQL procedure successfully completed.
Commit complete.
Set Credentials...
Creating Packaged Application Wizard Information...
Check Compatibility...
...Delete Packaged Applications and associated images
...Load Packaged Application Categories
...Load Packaged Applications and associated images
...done
Application Express Packaged and Sample Applications installation data
...Remove existing packaged application data
...Load packaged application archive
--application/set_environment
API Last Extended:20201001
Your Current Version:20201001
This import is compatible with version: 20201001
COMPATIBLE (You should be able to run this import without issues.)
ID offset during import: 8803817309518104
New ID offset for application: 0
--workspace/static/files/apps_20201125_zip
... elapsed: 10.1 sec
...done
...Expand packaged application archive
...done
...devpatch.sql
Session altered.
Grant succeeded.
Session altered.
...patch_32077573.sql
View created.
Trigger created.
No errors.
...patch_32078187.sql
1 row updated.
1 row updated.
1 row updated.
Commit complete.
...patch_32151519.sql
1 row updated.
Commit complete.
...patch_32124466.sql
1 row updated.
1 row updated.
3 rows updated.
1 row updated.
1 row updated.
3 rows updated.
1 row updated.
Commit complete.
...wwv_flow_web_src_dev.plb
Package body created.
No errors.
...wwv_flow_define_app_v3
Package body created.
No errors.
...wwv_flow_code_exec_mle_dev
Package body created.
No errors.
PL/SQL procedure successfully completed.
...patch_32001315.sql
1 row updated.
Commit complete.
PL/SQL procedure successfully completed.
Commit complete.
PL/SQL procedure successfully completed.
... Enabling Jobs
PL/SQL procedure successfully completed.
...Validating APEX
...(17:05:18) Starting validate_apex for APEX_200200
...(17:05:18) Checking missing sys privileges
...(17:05:18) Re-generating APEX_200200.wwv_flow_db_version
... wwv_flow_db_version is up to date
...(17:05:18) Checking invalid public synonyms
...(17:05:18) Key object existence check
...(17:05:19) Setting DBMS Registry for APEX to valid
...(17:05:19) Exiting validate_apex
PL/SQL procedure successfully completed.
...Recompiling invalid public synonyms
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
timing for: Complete Patch 32006852
Elapsed: 00:00:31.31
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.8.0.0.0
Then back into SQL Plus to make sure my validation script is working as expected
SQL> select installed, available
2 from
3 ( select max(patch_version) installed
4 from apex_patches
5 where patch_number = '32006852'
6 ),
7 ( select version available from apex_pse );
INSTALLED AVAILABLE
------------------------------ ----------------------------------------------------------------
2020.12.18 2020.12.18
And finally, update the images from the patch directory to your installation directory
C:\oracle\product\apex.202\32006852.4>xcopy /E /I images C:\oracle\product\apex.202\apex\images
Overwrite C:\oracle\product\apex.202\apex\images\apex_ui\css\Core.css (Yes/No/All)? A
images\apex_ui\css\Core.css
images\apex_ui\css\Core.min.css
images\apex_ui\js\widget.codeEditor.js
images\apex_ui\js\widget.pdPropertyEditor.js
images\apex_ui\js\minified\f4000_p4500_all.min.js
images\apex_ui\js\minified\widget.codeEditor.min.js
images\apex_ui\js\minified\widget.pdPropertyEditor.min.js
images\libraries\apex\util.js
images\libraries\apex\widget.tableModelViewBase.js
images\libraries\apex\minified\desktop.min.js
images\libraries\apex\minified\desktop_all.min.js
images\libraries\apex\minified\interactiveGrid.min.js
images\libraries\apex\minified\util.min.js
images\libraries\apex\minified\widget.tableModelViewBase.min.js
images\libraries\purify\2.2.2\purify.cjs.js
images\libraries\purify\2.2.2\purify.cjs.js.map
images\libraries\purify\2.2.2\purify.es.js
images\libraries\purify\2.2.2\purify.es.js.map
images\libraries\purify\2.2.2\purify.js
images\libraries\purify\2.2.2\purify.js.map
images\libraries\purify\2.2.2\purify.min.js
images\libraries\purify\2.2.2\purify.min.js.map
22 File(s) copied
Learning is not a spectator sport 