EM13c : Non-System Data Segments in System Tablespaces CS Rule reporting violation
(Doc ID 2828756.1)
Last updated on DECEMBER 16, 2021
Applies to:Enterprise Manager for Oracle Database - Version 126.96.36.199.0 and later
Information in this document applies to any platform.
In Enterprise Manager (EM) Cloud Control, The "Non-System Data Segments in System Tablespaces" Compliance Standard Rules in OEM 13c is reporting a violation because of segments belonging to "DBSFWUSER", which is a system user.
Here is how that rule is enforced.
1) The agent running on the database node uses the OEM Database plugin to collect the information.
It uses the "$AGENT_HOME/plugins/oracle.sysman.db.agent.plugin_188.8.131.52.0/metadata/database.xmlp" script to do that.
2) The information collected by the agent is pushed to the OEM repository.
3) The compliance rule uses the view MGMT$CS_DB_REC_SEG_COUNT to decide if there is a violation.
So here is why the rule reports a false violation related to segments belonging to user "DBSFWUSER".
The query used to collect the information is located in the script
"$AGENT_HOME/plugins/oracle.sysman.db.agent.plugin_184.108.40.206.0/metadata/database.xmlp" and it excludes the following users :
... AND u.name NOT IN
You will notice that this exclusion list does not include "DBSFWUSER".
So even if the user "DBSFWUSER" is a "SYSTEM" users that uses the "SYSAUX" tablespace, it should not raise a violation of compliance and it does.
And we can confirm that The "DBSFWUSER" is identified as system user because the column ORACLE_MAINTAINED is set to "Y" in DBA_USERS.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document