- 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
