4 Replies Latest reply on Jan 23, 2018 7:20 PM by user7259503

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

    TimHall
    TimHall Jan 17, 2018 12:08 PM

      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...