Patch Reviews - DB (MOSC)

MOSC Banner

applying 19c Apr PSU - oracle express (APEX_200100) becomes invalid

in Patch Reviews - DB (MOSC) 1 commentAnswered

this is a 19c oracle database running on redhat linux

SQL> select VERSION,VERSION_FULL from v$instance;

19.0.0.0.0    19.19.0.0.0


I was just wondering if anyone has ever encountered something similar. Have been applying PSUs regularly for last couple years and hasn't happened prior. I don't know if this is an issue or any concern something else underneath may be getting changed - but when I apply the most recent Apr PSU patch - the patching is successful - but I noticed application express component (apex_200100) becomes in valid. We do not use and I can recompile successfully.

it appears one of the grants gets removed? and I have to add back - which works - but then running oltp it always calls out this component although nothing appears invalid. While it doesn't appear impacting, is a bit concerning that it did initially break a component and I don't notice anything else affected, at least that I have been able to tell.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center