My Oracle Support Banner

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 FEBRUARY 03, 2019

Applies to:

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


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:



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

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