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.
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!
Discuss This Question: