Database Install/Upgrade/Opatch (MOSC)

MOSC Banner

2 issues after Oracle 19C Upgrade on Windows Standard Edtion 2

edited Jul 3, 2020 1:41AM in Database Install/Upgrade/Opatch (MOSC) 4 commentsAnswered

I upgraded some DBs and i always have the same two issues

first: the alert log shows following message each day

2020-07-01T01:02:37.155354+02:00 Some indexes or index [sub]partitions of table SYS.WRH$_SYSMETRIC_HISTORY have been marked unusable

i found the following:

https://nenadnoveljic.com/blog/wrh_sysmetric_history_index/

but i'm not able to build a local index in SE2 because it's not possible without partitioning - but i think this should not bother me because i`m not allowed to use AWR anyway, true?

second there are plenty of trace files produced every minute:

*** 2020-06-30T09:27:20.263411+02:00

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