Recovery Catalog update gives Error - java.sql.SQLException: ORA-00942: table or view does not exist

Error - java.sql.SQLException: ORA-00942: table or view does not exist

##########################
## Error
##########################

Error - java.sql.SQLException: ORA-00942: table or view does not exist

### Full Error

##########################
#  Error Occurred
##########################

Error occured while trying to update the recovery catalog information for the database in 11.2.0.3.0 version

##########################
## Command Executed
##########################

Update Catalog information in Recovery Catalog Settings.

**************************************** Step By Step Analysis ******************************************************

#########################################
# 1) Reproduce the Error
#########################################

Go To Database home --> Availability --> Recovery Catalog Settings ( In Backup / Recovery Section )

Once Recovery Catalog Settings page comes, click Recovery Catalog ( in Related Links Section ) and Edit the Recovery Catalog information

When we try to update recovery catalog database credentials we are getting the error mentioned in "Full Error"

=====================================================================================================================

#########################################
# 2) Reason for Failure
#########################################

When the screen shows like below to specify the credentials of Recovery catalog database, by Default we provide Recovery Catalog owner credentials.

That's where the problem lies, We should Provide a User with DBA privileges

=====================================================================================================================

#########################################
#  Solution
#########################################

So We have to provide the user credentials who has DBA Privileges like below,

Once We click Next, we will be taken to " Edit Recovery Catalog : User " page, where we will have to give Recovery catalog user credentials.

When we click next, a page will show like below.

Bug 16203642 also raised for this Error.

Seems like captions used in the Editing Recovery Catalog is little confusing. :)

=====================================================================================================================
 Comments Are Always welcome
=====================================================================================================================