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

Answer

Well, it's easier (one click less) than the code with grant option - permissions can be defined at object level and at user level and it's obvious if you look at dialogs:

permissions_with_grant.png

Philip

Marked as Answer by FC60 · Nov 28 2019
FC60

Merde Philip!!!

Before my eyes!

Sorry, I'm very stupid.

User_84SZK

Hello Philip,
is there a possibility to pull / synchronize these rights(WITH GRANT OPTION) from the database and not set it manually?
My usecase is.
I would like to generate the data modeler from the database and then generate the scripts from the data modeler and import this into another environment.

1 - 3
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,520 views