Friday, December 29, 2017

Apply APEX 5.1.4 to 5.1.3 in PDB

1. download p25341386_511_Generic.zip

- I was wrong to use the full set copy for upgrade.

2. 

SQL> alter session set container=pdb1 ;

Session altered.

SQL> select VERSION from dba_registry where comp_id='APEX';

VERSION
------------------------------
5.1.3.00.05

3. SQL> @apxpatch.sql

PL/SQL procedure successfully completed.

...Validating Application Express
...(22:36:14) Starting validate_apex for APEX_050100
...(22:36:17) Checking missing sys privileges
...(22:36:18) Key object existence check
...(22:36:18) Setting DBMS Registry for APEX to valid
...(22:36:18) Exiting validate_apex

PL/SQL procedure successfully completed.


PL/SQL procedure successfully completed.

timing for: Complete Patch
Elapsed: 00:05:41.47


4. load images


SQL> !pwd
/home/oracle/Downloads/APEX/p26795231_514_Generic/patch

SQL> !ls -ld images
drwxr-xr-x. 35 oracle oracle 32768 Dec 14 18:59 images

SQL> @apxldimg.sql /home/oracle/Downloads/APEX/p26795231_514_Generic/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/APEX/p26795231_514_Generic/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:06:19.75



SQL> select VERSION from dba_registry where comp_id='APEX';

VERSION
------------------------------
5.1.4.00.08

1 row selected.

No more below error any more !




References:

http://www.oracle.com/technetwork/developer-tools/apex/application-express/apex-514-patch-set-notes-4124555.html#GUID-68F6035F-90E8-4059-8902-AC6ADE3DAB3E