GGSCI (s11g) 50> add schematrandata scott
2021-03-25 10:14:53 ERROR OGG-01790 Failed to ADD SCHEMATRANDATA on schema scott because of the following SQL error: ORA-26947: Oracle GoldenGate replication is not enabled.
ORA-06512: at "SYS.DBMS_CAPTURE_ADM_INTERNAL", line 1565
ORA-06512: at "SYS.DBMS_CAPTURE_ADM_INTERNAL", line 1074
ORA-06512: at "SYS.DBMS_CAPTURE_ADM", line 722
ORA-06512: at line 1 SQL BEGIN sys.dbms_capture_adm.PREPARE_SCHEMA_INSTANTIATION('scott','ALLKEYS_ON'); END;.
GGSCI (s11g) 51> info schematrandata scott
2021-03-25 10:17:53 INFO OGG-01786 Schema level supplemental logging is disabled on schema SCOTT.
二、问题排查
oracle@s11g:/home/oracle$ oerr ora 26947
26947, 00000, "Oracle GoldenGate replication is not enabled."
// *Cause: The 'enable_goldengate_replication' parameter was not set to 'true'.
// *Action: Set the 'enable_goldengate_replication' parameter to 'true'
// and retry the operation.
// Oracle GoldenGate license is needed to use this parameter.
摘自：ENABLE_GOLDENGATE_REPLICATION database parameter (Doc ID 1568417.1)
For Oracle DB versions 11.2.0.4 and 12.1.0.2 there will be a new init.ora parameter called ENABLE_GOLDENGATE_REPLICATION. In order for some of the Oracle GoldenGate functionality to work, this parameter must be set to true. It will enable access to the TDE/TSE integration with classic extract, Integrated Capture, Integrated Apply, DBLOGREADER functionality, replicat functionality like suppression of triggers and deferring referential constrains, and other integration points.
So, in order to use OGG, on Oracle 11.2.0.4, or Oracle 12.1.0.2+, you will need to issue the following command through SQL*Plus.
ALTER SYSTEM SET ENABLE_GOLDENGATE_REPLICATION = TRUE SCOPE=BOTH;
This only needs to be done once, and in a RAC environment,will take effect on all instances. It can be done without bouncing the database instance, and you’ll want to use SCOPE=BOTH or update the init.ora file to ensure that when the database is bounced, the setting remains in effect.
If this parameter is not set and/or missing privileges (exec DBMS_GOLDENGATE_AUTH.GRANT_ADMIN_PRIVILEGE ( '<appropriate user>' ); ) you may get an Oracle error, ORA-26947 or ORA-26945 when attempting to use any of the GoldenGate functionality.
三、解决方案
Tips：在源端和目标端数据库同时开启ENABLE_GOLDENGATE_REPLICATION
SYS@orcl>ALTER SYSTEM SET ENABLE_GOLDENGATE_REPLICATION = TRUE SCOPE=BOTH;
System altered.
GGSCI (s11g) 52> add schematrandata scott
2021-03-25 10:30:49 INFO OGG-01788 SCHEMATRANDATA has been added on schema scott.
GGSCI (s11g) 53> info schematrandata scott
2021-03-25 10:53:04 INFO OGG-01785 Schema level supplemental logging is enabled on schema SCOTT.
java去所有空格 java去除空格的函数
JAVA中去掉空格 string apiString.trim() " code ".trim();trim()是去掉首尾空格 正则表达式正则表达式2.str.replace(" ", ""); 去掉所有空格，包括首尾、中间3、正则表达式是以" *"或者" +"形式。String str = "vincent he ll o ";
String str2 = st
k8s docker重启 k8s docker swarm
1.K8S 是容器编排引擎。（docker-compose 是docker 自带的容器编排工具，docker swarm是docker 自带的 docker 集群工具）。
2.K8S的功能=docker-compose的功能+docker-swarm的功能。
Java集合循环set字段的值 javaset集合存取
#class Testimport java.util.HashSet;
import java.util.Iterator;
import java.util.Set;
Set集合：
无序(元素的存取顺序不一致，如：存（123），打印（213或312等）)、不重复
Set<T> set = new HashSet<
java跳到下一次循环 java中跳出循环的方法
java中break和continue跳出指定循环 java中break和continue可以跳出指定循环，break和continue之后不加任何循环名则默认跳出其所在的循环，在其后加指定循环名，则可以跳出该指定循环（指定循环一般为循环嵌套的外循环）。break跳出指定循环示例代码： 1 loop1:for(int x = 0; x < 4; x++)
代码实例 import java.io.BufferedInputStream;
import java.io.BufferedOutputStream;
import java.io.File;
import java.io.FileOutputStream;
import java.io.IOException;
import java.io.InputStream;
import j
