Errors Registering Recovery Catalog in 10g Grid

5 pts.
Tags:
Oracle
Oracle 10g
Oracle 10g Database
Oracle Database
Oracle Enterprise Manager
Oracle Recovery Manager
RMAN
I have a 2 node RAC environment that I am trying to catalog in a database that is not part of the RAC instances, but is a tablespace in the Oracle Grid control database. This is a testing environment so my configuration may not be the most secure, but the production environment will have a separate ASM instance for the recovery catalog dedicated database. The problem I am getting is that when I try to add the recovery catalog in grid, I get an ORA-00942 error stating that the table or view does not exist. In grid, my steps are as follows: Databases -> <custer instance> -> Maintenance -> Recovery Catalog Settings (prompt for credentials, supplied sys database user credentials) Use Recovery Catalog -> Add Recovery Catalog Select a database target -> <Oracle Grid control database> (next) Host credentials (prompt for credentials, supplied local administrator credentials) Database credentials (prompt for credentials, supplied rman database user credentials) Here are the specifics of our system: ------------------------------- Grid Control components ------------------------------- Oracle Enterprise Manager 10.2.0.4 Oracle Database 10g 10.1.0.5 ------------------------------- RAC components ------------------------------- Oracle Clusterware 11.1.0.6 Oracle Database 11g 11.1.0.6 This seems like its a permission issue to see the catalog I have already created in the Grid database. What I find confusing is that I was able to register the RAC database from the command line in the Grid rman catalog. Update: I have used different credentials and received a new error. Here are the two scenarios I am getting: #1. Host Credentials = local admin credentials on OGC, Database Credentials = rman credentials, error = ORA-00942. Table or view does not exist The second scenario I tried was based on suggestions from "Oracle Enterprise Manager 10g Grid Control Implementation Guide": #2. Host Credentials = local admin credentials on OGC, Database Credentials = sys credentials as dba, error = ORA-01017. Invalid username/password, logon denied. The connector string was ... Also, please note that while I created the catalog, I have not yet registered any databases. Also note that the local admin account I am using for the Host Credentials has a strong password (i.e. special characters used). The other users have either mixed case passwords or weak passwords.

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following