Friday, September 01, 2017

apply APEX patch 5.1.2 for 5.1.1

alter session set container=pdb1;


Session altered.

SQL> @apxpatch.sql
...

PL/SQL procedure successfully completed.

...Validating Application Express
...(12:25:48) Starting validate_apex for APEX_050100
...(12:25:51) Checking missing sys privileges
...(12:25:51) Recompiling
...(12:25:53) Checking for objects that are still invalid
...(12:25:53) Key object existence check
...(12:25:53) Setting DBMS Registry for APEX to valid
...(12:25:53) Exiting validate_apex

PL/SQL procedure successfully completed.


PL/SQL procedure successfully completed.

timing for: Complete Patch
Elapsed: 00:04:48.58


SQL> !ls apxldimg.sql
apxldimg.sql

SQL> @apxldimg.sql  /home/oracle/Downloads/patch


PL/SQL procedure successfully completed.


PL/SQL procedure successfully completed.




1 row selected.



1 row selected.




1 row selected.


PL/SQL procedure successfully completed.





1 row selected.


PL/SQL procedure successfully completed.

. Loading images directory: /home/oracle/Downloads/patch/images

Directory created.


PL/SQL procedure successfully completed.


PL/SQL procedure successfully completed.


PL/SQL procedure successfully completed.


Commit complete.


Directory dropped.

timing for: Load Images
Elapsed: 00:05:12.92
SQL> select VERSION from dba_registry where comp_id='APEX';

VERSION
------------------------------
5.1.2.00.09

1 row selected.