I have a requirement to execute a job against each database in OEM, and return the latest patch that is in each databases' registry; dba_registry_history for 11g and dba_registry_sqlpatch for 12c. I have a job that uses a dynamic group to retrieve all targets of target_type 'rac_database'. I have RAC databases, single instance RAC databases (RAC 1 node) and NON-RAC single instance databases.
Does target_type 'rac_database' include all oracle databases registered in OEM? Is there a target type that includes all Oracle Databases registered in OEM.
I need to retrieve the information from each database, NOT EACH INSTANCE, as that created redundant entries I do not want, and it unnecessarily increases the number of jobs run against all the targets in OEM. So before responding, please consider that 'oracle_database' is only an option if I can filter on all the targets and get 1 entry for every target including RAC databases.