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:
- 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;
- Perform upgrade again using Autoupgrade.
Thanks for Reading.