Upgrade Catalog fails RMAN-01005: Error While Converting X Lock To S Lock
(Doc ID 2857994.1)
Last updated on APRIL 17, 2023
Applies to:
Oracle Database - Enterprise Edition - Version 19.14.0.0.0 to 21.5 [Release 19 to 21.0]Information in this document applies to any platform.
Symptoms
RMAN> upgrade catalog;
recovery catalog upgraded to version 19.14.00.00.00
DBMS_RCVMAN package upgraded to version 19.14.00.00
DBMS_RCVCAT package upgraded to version 19.14.00.00.
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-01005: Error while converting X lock to S lock
The rman_debug trace shows:
DBGSQL: error: ORA-06550: line 1, column 17: (krmkosqlerr)
DBGSQL: PLS-00201: identifier 'RMAN_RMCPO01.GET_LOCK_ON_CATALOG' must be declared (krmkosqlerr)
DBGSQL: ORA-06550: line 1, column 9: (krmkosqlerr)
DBGSQL: PL/SQL: Statement ignored (krmkosqlerr)
DBGSQL: ORA-06512: at line 1 (krmkosqlerr)
....
DBGSQL: RCVCAT> declare ret integer; str varchar2(120); begin str := 'begin :ret := '||dbms_catowner||'.get_lock_on_catalog(dbms_lock.S_MODE); end;'; EXECUTE IMMEDIATE str USING OUT ret; :retlock := ret; end;
DBGSQL: sqlcode = 6550
DBGSQL: B :retlock = NULL
DBGSQL: error: ORA-06550: line 1, column 50: (krmkosqlerr)
DBGSQL: PLS-00201: identifier 'DBMS_LOCK' must be declared (krmkosqlerr)
DBGSQL: ORA-06550: line 1, column 9: (krmkosqlerr)
DBGSQL: PL/SQL: Statement ignored (krmkosqlerr)
DBGSQL: ORA-06512: at line 1 (krmkosqlerr)
Changes
Target database upgraded to 19.14.
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |