5 pts.
 Errors Registering Recovery Catalog in 10g Grid
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.

Software/Hardware used:
ASKED: June 10, 2009  6:33 PM
UPDATED: June 10, 2009  7:12 PM

Answer Wiki:
Last Wiki Answer Submitted:  Be the first to answer this question.
All Answer Wiki Contributors:  Be the first to answer this question.
To see all answers submitted to the Answer Wiki: View Answer History.


Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _