Enterprise Manager Generic (MOSC)

MOSC Banner

19c patch time group missing from repository view

When run the below query

SELECT distinct b.property_value

FROM mgmt$target a JOIN mgmt$target_properties b

ON a.target_name = b.target_name

AND a.type_qualifier3 = 'DB'

AND b.property_name = 'DBVersion'


I receive a return of values as such:


12.1.0.2.190416

12.2.0.1.191015

19.8.0.0.0

12.2.0.1.200714

12.2.0.1.190716

12.2.0.1.200414

19.7.0.0.0

11.2.0.4.180717

12.1.0.2.190716

12.1.0.2.200714

19.9.0.0.0

18.10.0.0.0

11.2.0.4.191015

12.1.0.2.180717


Almost all 11g and 12c versions have a six digit date time group in the last decimal place. However, this does not appear for 19c versions. I am trying to create a view that converts the time group into a more readable date view and then count the number of databases by respective patch release date. I cannot do this for the 19c databases because it does not follow the same format. Is this a configuration issue on our end our with Oracle. I observed in this Oracle document linked

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

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center