Skip to Main Content

APEX 5.1.4 Patch Issue on non-CDB database (p26795231_514_Generic.zip)

TimHallJan 17 2018 — edited Jan 23 2018

Hi.

I've just applied the APEX 5.1.4 patch (p26795231_514_Generic.zip) to two databases:

1) APEX 5.1.3 to APEX 5.1.4 upgrade inside a PDB (DB 12.2.0.1). Worked fine.

2) APEX 5.1.3 to APEX 5.1.4 in a non-CDB (DB 12.1.0.2). Failed with the following errors.

...Validating Application Express

...(11:11:50) Starting validate_apex for APEX_050100

...(11:11:52) Checking missing sys privileges

...(11:11:52) Recompiling APEX_050100

...(11:11:55) Checking for objects that are still invalid

ORA-20001: COMPILE FAILURE: PACKAGE BODY APEX_050100.WWV_FLOW_AUTHORIZATION

...361/9    PL/SQL: SQL Statement ignored

...361/21   PL/SQL: ORA-00600: internal error code, arguments: [qctbyt : bfc],

[65532], [18446744073709551612], [1], [873], [1], [1], [0], [], [], [], []

ORA-20001: COMPILE FAILURE: PACKAGE BODY APEX_050100.WWV_FLOW_WIZARD_API

...1052/7   PL/SQL: SQL Statement ignored

...1089/14  PL/SQL: ORA-00600: internal error code, arguments: [qctbyt : bfc],

[65532], [18446744073709551612], [1], [873], [1], [1], [0], [], [], [], []

...(11:11:56) Key object existence check

...(11:11:56) Setting DBMS registry for APEX to INVALID

...(11:11:56) Exiting validate_apex

A quick scan on MOS links through to people trying to install APEX into a PDB when there is a CDB installation is already present, which is not the case here. It's a non-CDB instance.

Now I know the underlying DB versions are different as the architectures, but both versions are supported, as are both architectures. Anyone else seen this type of thing with the 5.1.4 patch?

Note. All instances were previously patched from 5.1.2 to 5.1.3 with no problems.

BTW: Just uninstalled APEX and reinstalled a clean 5.1.3 so people can continue while I investigate, so I don't have a problem with anything real at the moment.

Cheers

Tim...

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked due to inactivity on Feb 20 2018
Added on Jan 17 2018
4 comments
1,283 views