Oracle版本为12c R2：搭建完成DG库有trace目录中日志增长过快，其中一类mmon 的日志中主要为如下内容
AUTO SGA: kmgs_parameter_update_timeout gen0 0 mmon alive 1
需要安装补丁(Doc ID 2298766.1)
另一类为ORA-19527和ORA-312报错，需要设置log_file_name_convert
一、补丁安装
1.解压并进入到补丁目录
[oracle@oratest u02]$ cd software/
[oracle@oratest software]$ ll
total 340
-rw-r--r-- 1 oracle oinstall 344963 Feb 12 10:31 p25415713_122010_Linux-x86-64.zip
[oracle@oratest software]$ unzip p25415713_122010_Linux-x86-64.zip
Archive: p25415713_122010_Linux-x86-64.zip
creating: 25415713/
creating: 25415713/etc/
creating: 25415713/etc/config/
inflating: 25415713/etc/config/inventory.xml
inflating: 25415713/etc/config/actions.xml
inflating: 25415713/README.txt
creating: 25415713/online/
creating: 25415713/online/etc/
creating: 25415713/online/etc/xml/
inflating: 25415713/online/etc/xml/ShiphomeDirectoryStructure.xml
inflating: 25415713/online/etc/xml/GenericActions.xml
creating: 25415713/online/etc/config/
inflating: 25415713/online/etc/config/actions.xml
inflating: 25415713/online/etc/config/deploy.xml
inflating: 25415713/online/etc/config/inventory.xml
creating: 25415713/online/files/
creating: 25415713/online/files/hpatch/
inflating: 25415713/online/files/hpatch/bug25415713.pch
creating: 25415713/files/
creating: 25415713/files/lib/
creating: 25415713/files/lib/libserver12.a/
inflating: 25415713/files/lib/libserver12.a/kmgs.o
inflating: PatchSearch.xml
[oracle@oratest software]$
[oracle@oratest software]$ ll
total 348
drwxrwxr-x 5 oracle oinstall 4096 Jul 20 2017 25415713
-rw-r--r-- 1 oracle oinstall 344963 Feb 12 10:31 p25415713_122010_Linux-x86-64.zip
-rw-rw-r-- 1 oracle oinstall 2510 Jul 20 2017 PatchSearch.xml
[oracle@oratest software]$ cd 25415713/
[oracle@oratest 25415713]$ ll
total 24
drwxrwxr-x 3 oracle oinstall 4096 Jul 20 2017 etc
drwxrwxr-x 3 oracle oinstall 4096 Jul 20 2017 files
drwxr-xr-x 4 oracle oinstall 4096 Jul 20 2017 online
-rw-rw-r-- 1 oracle oinstall 10021 Jul 20 2017 README.txt
[oracle@oratest 25415713]$ pwd
/u02/software/25415713
2，在线安装补丁
[oracle@oratest 25415713]$ ps -ef |grep smon
oracle 22391 1 0 09:46 ? 00:00:00 ora_smon_ora12c
oracle 23245 22783 0 09:53 pts/1 00:00:00 grep smon
实例名:sys:sys的密码: --注意这里有3个冒号
[oracle@oratest 25415713]$ opatch apply online -connectString ora12c:sys:oracle:
Oracle Interim Patch Installer version 12.2.0.1.6
Copyright (c) 2018, Oracle Corporation. All rights reserved.
Oracle Home : /u02/oracle/product/db12cr2
Central Inventory : /u01/oraInventory
from : /u02/oracle/product/db12cr2/oraInst.loc
OPatch version : 12.2.0.1.6
OUI version : 12.2.0.1.4
Log file location : /u02/oracle/product/db12cr2/cfgtoollogs/opatch/opatch2018-05-03_09-52-29AM_1.log
Verifying environment and performing prerequisite checks...
OPatch continues with these patches: 25415713
Do you want to proceed? [y|n]
y
User Responded with: Y
All checks passed.
Backing up files...
The patch should be applied/rolled back in '-all_nodes' mode only.
Converting the RAC mode to '-all_nodes' mode.
Applying interim patch '25415713' to OH '/u02/oracle/product/db12cr2'
Patching component oracle.rdbms, 12.2.0.1.0...
Installing and enabling the online patch 'bug25415713.pch', on database 'ora12c'.
Patch 25415713 successfully applied.
Log file location: /u02/oracle/product/db12cr2/cfgtoollogs/opatch/opatch2018-05-03_09-52-29AM_1.log
OPatch succeeded.
[oracle@oratest 25415713]$
[oracle@oratest 25415713]$ opatch lsinv
Oracle Interim Patch Installer version 12.2.0.1.6
Copyright (c) 2018, Oracle Corporation. All rights reserved.
Oracle Home : /u02/oracle/product/db12cr2
Central Inventory : /u01/oraInventory
from : /u02/oracle/product/db12cr2/oraInst.loc
OPatch version : 12.2.0.1.6
OUI version : 12.2.0.1.4
Log file location : /u02/oracle/product/db12cr2/cfgtoollogs/opatch/opatch2018-05-03_09-52-47AM_1.log
Lsinventory Output file location : /u02/oracle/product/db12cr2/cfgtoollogs/opatch/lsinv/lsinventory2018-05-03_09-52-47AM.txt