13.2 EM: While Monitoring Physical Standby Database in MOUNT Mode, Navigating to Performance Page Generates Huge OS Audit Logs

(Doc ID 2390155.1)

Last updated on JUNE 05, 2018

Applies to:

Oracle Database - Enterprise Edition - Version 12.2.0.1 and later
Enterprise Manager for Oracle Database - Version 13.2.0.0.0 and later
Information in this document applies to any platform.

Symptoms

Using Oracle Enterprise Manager 13.2 to monitor a Data Guard physical standby database in MOUNT mode:

When an OEM user navigates to the Database Performance page, many large OS audit logs are generated on the filesystem, such as:

-rw-------. 1 oracle oinstall 9.8M Dec 14 14:21 WEBCDB_ora_96564_20171214142049479788143795.aud
-rw-------. 1 oracle oinstall 9.8M Dec 14 14:21 WEBCDB_ora_23876_20171214142103496349143795.aud
-rw-------. 1 oracle oinstall 9.8M Dec 14 14:21 WEBCDB_ora_96564_20171214142120963747143795.aud
-rw-------. 1 oracle oinstall 9.8M Dec 14 14:22 WEBCDB_ora_23876_20171214142134599743143795.aud
-rw-------. 1 oracle oinstall 9.8M Dec 14 14:22 WEBCDB_ora_96564_20171214142152184426143795.aud
-rw-------. 1 oracle oinstall 23K Dec 14 14:22 WEBCDB_ora_109818_20171214141924831902143795.aud
-rw-------. 1 oracle oinstall 9.8M Dec 14 14:22 WEBCDB_ora_23876_20171214142205332416143795.aud
-rw-------. 1 oracle oinstall 6.5K Dec 14 14:22 WEBCDB_ora_109975_20171214142020802282143795.aud
-rw-------. 1 oracle oinstall 9.7M Dec 14 14:22 WEBCDB_ora_96564_20171214142222893609143795.aud
-rw-------. 1 oracle oinstall 5.6M Dec 14 14:22 WEBCDB_ora_23876_20171214142235971196143795.aud



These files keep being created and this takes up disk space, which can fill up the filesystem unless care is taken to remove the files.

Examining the *.aud files reveals that many SYSDBA connections are coming into the database from the OMS repository, and these connections are querying the CDB_USERS view. 
For example:

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms