How to fix the Oracle error RMAN-06802: too many eligible base catalogs found?

In this post, you’ll learn more about the Oracle ErrorRMAN-06802: too many eligible base catalogs found with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

RMAN-06802: too many eligible base catalogs found

Reason for the Error RMAN-06802: too many eligible base catalogs found

When trying to create a virtual catalog, more than one base catalog was found that is eligible to be the base catalog for this virtual catalog.

How to fix the Error RMAN-06802: too many eligible base catalogs found ?

You can fix this error in Oracle by following the below steps

Revoke privileges so that the current catalog user has privileges on only one base catalog, then re-issue the CREATE VIRTUAL CATALOG command.