RMAN-06426: RECOVERY_CATALOG_OWNER role must be granted to user

Error Description
Whenever you try to create recovery catalog in rman with a user other than RECOVERY_CATALOG_OWNER role owner it fails with RMAN-06426: RECOVERY_CATALOG_OWNER role must be granted to user ARJU.

-bash-3.00$ rman target sys/@jupiter:/ARJU.JUPITER.ARJU.NET catalog arju/a

Recovery Manager: Release 10.2.0.1.0 - Production on Mon Aug 4 05:15:32 2008

Copyright (c) 1982, 2005, Oracle. All rights reserved.

target database Password:
connected to target database: ARJU (DBID=2855033675)
connected to recovery catalog database

RMAN> create catalog;

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-06426: RECOVERY_CATALOG_OWNER role must be granted to user ARJU

Cause of The Problem
The userid that was supplied in the CATALOG connect string does not have the RECOVERY_CATALOG_OWNER role granted as a DEFAULT role.

Solution of The Problem
Grant the RECOVERY_CATALOG_OWNER role to the user ARJU in the recovery catalog database. Here from the rman connection string we see the recovery catalog database is the local database. So in the local database issue as a sys user,

SQL> grant RECOVERY_CATALOG_OWNER to arju;
Grant succeeded.

Now create catalog by,

RMAN> create catalog;
recovery catalog created

Related Documents
Interact with RMAN Client.
How to create recovery catalog and use it