We are setting up monitoring and noticed two problems after setting up cdm profiles in MCS:
1 Alarms getting registered with nas
2. Second probe is that no QOS data being injected in the database.
The permissions documented in the documentation must be applied directly to the user and not to a role that the user belongs to.
https://techdocs.broadcom.com/us/en/ca-enterprise-software/it-operations-management/unified-infrastructure-management/9-0-2/installing/pre-installation-planning/install-and-configure-your-database-software/oracle.html
In these statements: "dbowner" is the user and not the role:
create user db_owner IDENTIFIED BY owner_password DEFAULT TABLESPACE ts_name;
grant unlimited tablespace to db_owner;
grant administer database trigger to db_owner;
grant create table to db_owner;
grant create view to db_owner;
grant alter any table to db_owner;
grant select any table to db_owner;
grant create sequence to db_owner;
grant create procedure to db_owner;
grant create session to db_owner;
grant create trigger to db_owner;
grant create type to db_owner;
grant select on sys.v_$session to db_owner;
grant execute on sys.dbms_lob to db_owner;
grant execute on dbms_redefinition to db_owner;
grant create any table to db_owner;
grant drop any table to db_owner;
grant lock any table to db_owner;
<Please see attached file for image>
<Please see attached file for image>