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
=====================================================================================================================
