Duplicate Invalid Types with 2 states VALID and INVALID after Upgrade (Doc ID 2900276.1)

Last updated on JULY 20, 2024

Applies to:

Symptoms

Multiple rows found in dba_objects for some types after an upgrade. i.e., Duplicate Invalid Types with 2 states VALID and INVALID.

Per the following, Development has stated to ignore the duplicate INVALID types per statement in the following note:

Duplicate Invalid Types That Won't Compile (Doc ID 748109.1)

This is not acceptable as  Exa-DB patching tool works only if SYS schema has no invalids.

For example:

 OBJECT_ID OWNER OBJECT_NAME OBJECT_TYP STATUS
---------- ---------- ------------------------------ ---------- ----------
  14194 SYS ALERT_TYPE TYPE VALID
  14192 SYS ALERT_TYPE TYPE INVALID
  13221 SYS AQ$_AGENT TYPE VALID
  8428 SYS AQ$_AGENT TYPE INVALID
  13242 SYS AQ$_DEQUEUE_HISTORY TYPE VALID
  8429 SYS AQ$_DEQUEUE_HISTORY TYPE INVALID
  8433 SYS AQ$_DEQUEUE_HISTORY_T TYPE INVALID
  13244 SYS AQ$_DEQUEUE_HISTORY_T TYPE VALID
  13247 SYS AQ$_DESCRIPTOR TYPE VALID
  8547 SYS AQ$_DESCRIPTOR TYPE INVALID
  13227 SYS AQ$_DESCRIPTOR TYPE INVALID
  13246 SYS AQ$_DESCRIPTOR TYPE INVALID
  8552 SYS AQ$_EVENT_MESSAGE TYPE INVALID
  13228 SYS AQ$_EVENT_MESSAGE TYPE VALID
  13220 SYS AQ$_EVENT_MESSAGE TYPE INVALID
  8432 SYS AQ$_HISTORY TYPE INVALID
  13243 SYS AQ$_HISTORY TYPE VALID
  18956 SYS AQ$_JMS_BYTES_MESSAGE TYPE BODY VALID
  13204 SYS AQ$_JMS_BYTES_MESSAGE TYPE INVALID
  13231 SYS AQ$_JMS_BYTES_MESSAGE TYPE VALID
  13210 SYS AQ$_JMS_BYTES_MESSAGES TYPE INVALID
  13238 SYS AQ$_JMS_BYTES_MESSAGES TYPE VALID
  18953 SYS AQ$_JMS_HEADER TYPE BODY VALID
  13201 SYS AQ$_JMS_HEADER TYPE INVALID
  13225 SYS AQ$_JMS_HEADER TYPE VALID
  13206 SYS AQ$_JMS_MAP_MESSAGE TYPE INVALID
  13233 SYS AQ$_JMS_MAP_MESSAGE TYPE VALID
  18958 SYS AQ$_JMS_MAP_MESSAGE TYPE BODY VALID
  13240 SYS AQ$_JMS_MAP_MESSAGES TYPE VALID
  13211 SYS AQ$_JMS_MAP_MESSAGES TYPE INVALID
  13236 SYS AQ$_JMS_MESSAGE TYPE VALID
  18954 SYS AQ$_JMS_MESSAGE TYPE BODY VALID
  13207 SYS AQ$_JMS_MESSAGE TYPE INVALID
  13208 SYS AQ$_JMS_MESSAGES TYPE INVALID
  13241 SYS AQ$_JMS_MESSAGES TYPE VALID
  13215 SYS AQ$_JMS_MESSAGE_PROPERTIES TYPE INVALID
  13235 SYS AQ$_JMS_MESSAGE_PROPERTIES TYPE VALID
  13214 SYS AQ$_JMS_MESSAGE_PROPERTY TYPE INVALID
  13229 SYS AQ$_JMS_MESSAGE_PROPERTY TYPE VALID
  13202 SYS AQ$_JMS_OBJECT_MESSAGE TYPE INVALID
  13226 SYS AQ$_JMS_OBJECT_MESSAGE TYPE VALID
  13234 SYS AQ$_JMS_OBJECT_MESSAGES TYPE VALID
  13213 SYS AQ$_JMS_OBJECT_MESSAGES TYPE INVALID
  13205 SYS AQ$_JMS_STREAM_MESSAGE TYPE INVALID
  13232 SYS AQ$_JMS_STREAM_MESSAGE TYPE VALID
  18957 SYS AQ$_JMS_STREAM_MESSAGE TYPE BODY VALID
  13239 SYS AQ$_JMS_STREAM_MESSAGES TYPE VALID
  13212 SYS AQ$_JMS_STREAM_MESSAGES TYPE INVALID
  18955 SYS AQ$_JMS_TEXT_MESSAGE TYPE BODY VALID
  13230 SYS AQ$_JMS_TEXT_MESSAGE TYPE VALID
  13203 SYS AQ$_JMS_TEXT_MESSAGE TYPE INVALID
  13209 SYS AQ$_JMS_TEXT_MESSAGES TYPE INVALID
  13237 SYS AQ$_JMS_TEXT_MESSAGES TYPE VALID
  8549 SYS AQ$_POST_INFO TYPE INVALID
  13250 SYS AQ$_POST_INFO TYPE VALID
  8551 SYS AQ$_POST_INFO_LIST TYPE INVALID
  13251 SYS AQ$_POST_INFO_LIST TYPE VALID
  8431 SYS AQ$_RECIPIENTS TYPE INVALID
  13223 SYS AQ$_RECIPIENTS TYPE VALID
  13248 SYS AQ$_REG_INFO TYPE VALID
  18930 SYS AQ$_REG_INFO TYPE BODY VALID
  8548 SYS AQ$_REG_INFO TYPE INVALID
  8550 SYS AQ$_REG_INFO_LIST TYPE INVALID
  13249 SYS AQ$_REG_INFO_LIST TYPE VALID
  8553 SYS AQ$_SRVNTFN_MESSAGE TYPE INVALID
  13252 SYS AQ$_SRVNTFN_MESSAGE TYPE VALID
  13253 SYS AQ$_SUBSCRIBER TYPE VALID
  8554 SYS AQ$_SUBSCRIBER TYPE INVALID
  13222 SYS AQ$_SUBSCRIBERS TYPE VALID
  8430 SYS AQ$_SUBSCRIBERS TYPE INVALID
  8555 SYS AQ$_SUBSCRIBER_T TYPE INVALID
  13254 SYS AQ$_SUBSCRIBER_T TYPE VALID
  8246 SYS CHNF$_DESC TYPE VALID
  8240 SYS CHNF$_DESC TYPE INVALID
  8236 SYS CHNF$_QDESC TYPE INVALID
  8244 SYS CHNF$_QDESC TYPE VALID
  8245 SYS CHNF$_QDESC_ARRAY TYPE VALID
  8238 SYS CHNF$_QDESC_ARRAY TYPE INVALID
  8225 SYS CHNF$_REG_INFO TYPE INVALID
  8226 SYS CHNF$_REG_INFO TYPE VALID
  19125 SYS CHNF$_REG_INFO TYPE BODY VALID
  8232 SYS CHNF$_TDESC TYPE INVALID
  8242 SYS CHNF$_TDESC TYPE VALID
  8234 SYS CHNF$_TDESC_ARRAY TYPE INVALID
  8243 SYS CHNF$_TDESC_ARRAY TYPE VALID
  8273 SYS DM_MODEL_SETTING TYPE INVALID
  8390 SYS DM_MODEL_SETTING TYPE VALID
  8275 SYS DM_MODEL_SETTINGS TYPE INVALID
  8391 SYS DM_MODEL_SETTINGS TYPE VALID
  8389 SYS DM_MODEL_SIGNATURE TYPE VALID
  8271 SYS DM_MODEL_SIGNATURE TYPE INVALID
  8388 SYS DM_MODEL_SIGNATURE_ATTRIBUTE TYPE VALID
  8269 SYS DM_MODEL_SIGNATURE_ATTRIBUTE TYPE INVALID
  8394 SYS DM_MODEL_TEXT_DF TYPE VALID
  8381 SYS DM_MODEL_TEXT_DF TYPE INVALID
  8383 SYS DM_MODEL_TEXT_DFS TYPE INVALID
  8395 SYS DM_MODEL_TEXT_DFS TYPE VALID
  8392 SYS DM_NB_DETAIL TYPE VALID
  8313 SYS DM_NB_DETAIL TYPE INVALID
  8315 SYS DM_NB_DETAILS TYPE INVALID
  8393 SYS DM_NB_DETAILS TYPE VALID
  20320 SYS HSBLKNAMLST TYPE INVALID
  20322 SYS HSBLKNAMLST TYPE VALID
  20323 SYS HS_PART_OBJ TYPE VALID
  20321 SYS HS_PART_OBJ TYPE INVALID
  8544 SYS MSG_PROP_T TYPE INVALID
  13245 SYS MSG_PROP_T TYPE VALID
  13224 SYS MSG_PROP_T TYPE INVALID
  8267 SYS ORA_MINING_TABLES_NT TYPE INVALID
  8387 SYS ORA_MINING_TABLES_NT TYPE VALID
  8386 SYS ORA_MINING_TABLE_TYPE TYPE VALID
  8265 SYS ORA_MINING_TABLE_TYPE TYPE INVALID
  13276 SYS RE$ATTRIBUTE_VALUE TYPE VALID
  7985 SYS RE$ATTRIBUTE_VALUE TYPE INVALID
  7986 SYS RE$ATTRIBUTE_VALUE_LIST TYPE INVALID
  13277 SYS RE$ATTRIBUTE_VALUE_LIST TYPE VALID
  7981 SYS RE$COLUMN_VALUE TYPE INVALID
  13272 SYS RE$COLUMN_VALUE TYPE VALID
  7982 SYS RE$COLUMN_VALUE_LIST TYPE INVALID
  13273 SYS RE$COLUMN_VALUE_LIST TYPE VALID
  13262 SYS RE$NAME_ARRAY TYPE VALID
  7921 SYS RE$NAME_ARRAY TYPE INVALID
  7920 SYS RE$NV_ARRAY TYPE INVALID
  13258 SYS RE$NV_ARRAY TYPE VALID
  13263 SYS RE$NV_LIST TYPE VALID
  13259 SYS RE$NV_LIST TYPE INVALID
  7923 SYS RE$NV_LIST TYPE INVALID
  18807 SYS RE$NV_LIST TYPE BODY VALID
  7919 SYS RE$NV_NODE TYPE INVALID
  13257 SYS RE$NV_NODE TYPE VALID
  7987 SYS RE$RULE_HIT TYPE INVALID
  13260 SYS RE$RULE_HIT TYPE INVALID
  13255 SYS RE$RULE_HIT TYPE INVALID
  13264 SYS RE$RULE_HIT TYPE VALID
  7988 SYS RE$RULE_HIT_LIST TYPE INVALID
  13256 SYS RE$RULE_HIT_LIST TYPE INVALID
  13261 SYS RE$RULE_HIT_LIST TYPE INVALID
  13265 SYS RE$RULE_HIT_LIST TYPE VALID
  13278 SYS RE$RULE_LIST TYPE VALID
  7989 SYS RE$RULE_LIST TYPE INVALID
  13266 SYS RE$TABLE_ALIAS TYPE VALID
  7975 SYS RE$TABLE_ALIAS TYPE INVALID
  7976 SYS RE$TABLE_ALIAS_LIST TYPE INVALID
  13267 SYS RE$TABLE_ALIAS_LIST TYPE VALID
  13270 SYS RE$TABLE_VALUE TYPE VALID
  7979 SYS RE$TABLE_VALUE TYPE INVALID
  13271 SYS RE$TABLE_VALUE_LIST TYPE VALID
  7980 SYS RE$TABLE_VALUE_LIST TYPE INVALID
  7977 SYS RE$VARIABLE_TYPE TYPE INVALID
  13268 SYS RE$VARIABLE_TYPE TYPE VALID
  7978 SYS RE$VARIABLE_TYPE_LIST TYPE INVALID
  13269 SYS RE$VARIABLE_TYPE_LIST TYPE VALID
  13274 SYS RE$VARIABLE_VALUE TYPE VALID
  7983 SYS RE$VARIABLE_VALUE TYPE INVALID
  13275 SYS RE$VARIABLE_VALUE_LIST TYPE VALID
  7984 SYS RE$VARIABLE_VALUE_LIST TYPE INVALID
  8933 SYS SCHEDULER$_REMOTE_DB_JOB_INFO TYPE VALID
  8932 SYS SCHEDULER$_REMOTE_DB_JOB_INFO TYPE INVALID
  7536 SYS SQL_PLAN_ALLSTAT_ROW_TYPE TYPE INVALID
  7540 SYS SQL_PLAN_ALLSTAT_ROW_TYPE TYPE VALID
  19183 SYS SQL_PLAN_ALLSTAT_ROW_TYPE TYPE BODY VALID
  7537 SYS SQL_PLAN_ROW_TYPE TYPE VALID
  7525 SYS SQL_PLAN_ROW_TYPE TYPE INVALID
  7534 SYS SQL_PLAN_STAT_ROW_TYPE TYPE INVALID
  7539 SYS SQL_PLAN_STAT_ROW_TYPE TYPE VALID
  7527 SYS SQL_PLAN_TABLE_TYPE TYPE INVALID
  7538 SYS SQL_PLAN_TABLE_TYPE TYPE VALID

182 rows selected.

Changes

 DB upgrade.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.