Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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 on Feb 20 2018
Added on Jan 17 2018
4 comments
1,488 views