Prerequisites for Adding Data Collectors (Oracle Recovery Manager - RMAN)
Identify a server where the Data Collector software will be installed. Server requirements include:
• 64-bit OS. See the APTARE IT Analytics Certified Configurations Guide for supported operating systems.
• Support Java Runtime Environment (JRE) 10.0.2.
• For performance reasons, do not install Data Collectors on the same server as the APTARE IT Analytics Portal. However, if you must have both on the same server, verify that the Portal and Data Collector software do not reside in the same directory.
• Install only one Data Collector on a server (or OS instance).
• Database Host and Port: Identify the hostname of the server where the database in which the RMAN data resides as well as the port this database is listening on. The default port is 1521.
• The configured user must exist in all configured instances with the same password. The user should the CREATE SESSION privilege and have the following permissions in the schemas to be collected from:
• User must have the SELECT_CATALOG_ROLE to retrieve RMAN data from the Dynamic Performance (V$) views:
GRANT SELECT_CATALOG_ROLE TO <user>;
• User requires the RECOVERY_CATALOG_OWNER (or RECOVERY_CATALOG_USER role in Oracle 12c or later) for example:
GRANT RECOVERY_CATALOG_OWNER TO <user>;
or
GRANT RECOVERY_CATALOG_USER TO <user>;
or have a virtual private catalog set up for the user (see Oracle documentation).
• User must have SELECT permission to V$INSTANCE and V$DATABASE (which is included in SELECT_CATALOG_ROLE).