Shulou(Shulou.com)06/01 Report--

A newly installed set of 12c main libraries and dataguard libraries found errors in the alert log:

2018-07-30T22:04:17.522506+08:00

Non critical error ORA-48913 caught while writing to trace file "/ opt/app/oracle/diag/rdbms/mingdb_dg/mingdb_dg/trace/mingdb_dg_mmo

N_12919.trc "

Error message: ORA-48913: Writing into trace file failed, file size limit [1048576] reached

Writing to the above trace file is disabled for now on...

2018-07-30T22:04:18.774521+08:00

Non critical error ORA-48913 caught while writing to trace file "/ opt/app/oracle/diag/rdbms/mingdb_dg/mingdb_dg/trace/mingdb_dg_gen

0_12867.trc "

Error message: ORA-48913: Writing into trace file failed, file size limit [1048576] reached

Writing to the above trace file is disabled for now on...

The trace file of the background process has reached the maximum capacity limit, involving two processes: the mmon process and the gen0 process.

Mmon: this process is the main process of awr and writes statistics to the sysaux tablespace.

Gen0: general task execution process, sharing blocking handling by other processes

The Trace file is as follows:

* * 2018-07-30T14:20:18.835255+08:00 (CDB$ROOT (1))

AUTO SGA: kmgs_parameter_update_timeout gen0 0 mmon alive 1

* * 2018-07-30T14:20:21.836263+08:00 (CDB$ROOT (1))

AUTO SGA: kmgs_parameter_update_timeout gen0 0 mmon alive 1

* * 2018-07-30T14:20:24.837269+08:00 (CDB$ROOT (1))

AUTO SGA: kmgs_parameter_update_timeout gen0 0 mmon alive 1

* * 2018-07-30T14:20:27.838318+08:00 (CDB$ROOT (1))

AUTO SGA: kmgs_parameter_update_timeout gen0 0 mmon alive 1

* * 2018-07-30T14:20:30.839297+08:00 (CDB$ROOT (1))

AUTO SGA: kmgs_parameter_update_timeout gen0 0 mmon alive 1

* * 2018-07-30T14:20:33.840291+08:00 (CDB$ROOT (1))

AUTO SGA: kmgs_parameter_update_timeout gen0 0 mmon alive 1

* * 2018-07-30T14:20:36.841287+08:00 (CDB$ROOT (1))

AUTO SGA: kmgs_parameter_update_timeout gen0 0 mmon alive 1

It seems to have something to do with SGA automatic management. This set of libraries sga and PGA are automatically managed respectively.

Search for unreleased bug in mos:

Unpublished Bug 25415713-MMON TRACE FILE GROWS WHEN NO TRACES ARE ENABLED

Solution:

Unix and Linux need patches, patch pack: p25415713_12201180717DBJUL2018RU_Linux-x86-64.

Before you play this RU, you need to call PSU 28163133.

Windows platform, patch 25415713 does not work.

Or, change automatic SGA management to manual management.

Alter system set sga_target=0 scope=spfile

Then set db_cache_size, shared_pool_size, java_pool_size, log_buffer, streams_pool_size according to memory size

With the second method, the same error did not appear in the subsequent log.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.