Introduction:

During 11.2.0.4 database upgrade to 19c, Autoupgrade fails with error –

NVL(bundle_series,’0′)||’#’||
*
ERROR at line 3:
ORA-00904: “BUNDLE_SERIES”: invalid identifier
] [ORCL] – ExecuteSql$SQLClient.run
NVL(TO_CHAR(action_time, ‘DD-MM-YYYY HH24:MI:SS’),’0′) ||’#’||
NVL(action,’0′)||’#’||
NVL(bundle_series,’0′)||’#’||
NVL(comments,’0′)||’#’||
NVL(id,0)
FROM sys.dba_registry_history h1
WHERE action = ‘APPLY’ AND
1=1 AND
comments like ‘%11.2.0.4%’ AND
not exists(SELECT 1 FROM SYS.DBA_REGISTRY_HISTORY h2
WHERE h1.id = h2.id AND
h1.action_time < h2.action_time AND
1=1 AND
h2.action = ‘ROLLBACK’)
order by action_time, comments;

 

Cause of the issue:

In 11.2.0.4 DB, DBA_REGISTRY_HISTORY is missing column BUNDLE_SERIES.

 

How do we solve:

  1. Recreate view DBA_REGISTRY_HISTORY to include missing column BUNDLE_SERIES –

CREATE OR REPLACE FORCE VIEW “SYS”.”DBA_REGISTRY_HISTORY” (“ACTION_TIME”, “ACTION”, “NAMESPACE”, “VERSION”, “ID”, “BUNDLE_SERIES”, “COMMENTS”) AS

SELECT action_time, action, namespace, version, id, bundle_series, comments FROM registry$history;

  1. Perform upgrade again using Autoupgrade.

 

Thanks for Reading.

Recent Posts

Start typing and press Enter to search