ORA-04063: package body "SYS.DBMS_RCVMAN" has errors

 

ISSUE DESCRIPTION

rman target /

Recovery Manager: Release 12.2.0.1.0 - Production on Fri Feb 9 19:26:23 2024

Copyright (c) 1982, 2017, Oracle and/or its affiliates.  All rights reserved.

ORACLE error from target database:
ORA-04063: package body "SYS.DBMS_RCVMAN" has errors
ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_RCVMAN"

error executing package DBMS_RCVMAN in TARGET database
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00554: initialization of internal recovery manager package failed
RMAN-06429: TARGET database is not compatible with this version of RMAN

COMPILE the objects

rman target /

Recovery Manager: Release 12.2.0.1.0 - Production on Fri Feb 9 19:26:23 2024

STATUS of the OBJECTS 

select owner,object_name,object_type,status from dba_objects where status='INVALID'
OWNER OBJECT_NAME OBJECT_TYPE STATUS
-------------------- ------------------------------ ----------------------- -------
SYS DBMS_RCVMAN PACKAGE BODY INVALID

SOLUTION

SQL> alter PACKAGE SYS.DBMS_RCVMAN compile BODY;

Warning: Package Body altered with compilation errors.

SQL>
SQL>
SQL>
SQL> sho error
Errors for PACKAGE BODY SYS.DBMS_RCVMAN:

LINE/COL ERROR
-------- -----------------------------------------------------------------
462/1    PL/SQL: Item ignored
463/8    PLS-00400: different number of columns between cursor SELECT
         statement and return value

8247/1   PL/SQL: Item ignored
8248/8   PLS-00400: different number of columns between cursor SELECT
         statement and return value

SQL>

SQL> @?/rdbms/admin/prvtrmns.plb

Session altered.

Package body created.

Session altered.

SQL>

SQL>

SQL> !

rman target /

Recovery Manager: Release 12.2.0.1.0 - Production on Fri Feb 9 21:07:36 2024

Copyright (c) 1982, 2017, Oracle and/or its affiliates.  All rights reserved.

connected to target database: DBNAME (DBID=123456789)

RMAN> exit

Recovery Manager complete.