EM13c : Non-System Data Segments in System Tablespaces CS Rule reporting violation (Doc ID 2828756.1)

Last updated on DECEMBER 16, 2021

Applies to:

Symptoms

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_13.5.0.0.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_13.5.0.0.0/metadata/database.xmlp" and it excludes the following users :

... AND u.name NOT IN

('MGMT_VIEW','OUTLN','ANONYMOUS','DMSYS','LBACSYS','WKPROXY','TRACESVR','SCOTT','ADAMS','BLAKE','CLARK','JONES','HR','PM','OE','SH','IX','CTXSYS','DMSYS','M

DSYS','OLAPSYS','ORDPLUGINS','ORDSYS','PERFSTAT','SI_INFORMTN_SCHEMA','SYS','SYSMAN','SYSTEM','WKSYS','WMSYS','XDB','WK_TEST','TSMSYS','EXFSYS','DBSNMP','OR

DDATA','DVSYS','OJVMSYS','APPQOSSYS','GSMADMIN_INTERNAL','AUDSYS','OCM_DATA','XDBPM','SCHEDULER_REMOTE_AGENT')

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.

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.