The APEX PSE christmas present!

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…

Image

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

Got some thoughts? Leave a comment

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.