-
OGG 12C图形化安装
Jun01201512C版本开始,开始支持图形化安装。安装文件解压后和之前的版本不在一样,不在是解压后直接运行ggsci即可了。本文以12.1.2.1.0版本为例,解压后的文件如下: [oracle@oracle-test1 Disk1]$ ls install response runInstaller stage [oracle@oracle-test1 Disk1]$ pwd /home/oracle/ogg/fbo_ggs_Linux_x64_shiphom ...
阅读全文抢沙发
-
OGG-02064 OGG-01755 Cannot register or unregister EXTRACT错误
Nov012013今天来测试OGG 11.2的新特性Integrated Extract模式,在注册extract进程的时候遇到OGG-02064和OGG-01755错误。 实验环境: 源端:OEL 5.7 for 32bit,oracle 10.2.0.4.0 for linux 32bit mining端:OEL 5.7 for 32bit,oracle 11.2.0.4.0 for linux 32bit GGSCI (mining) 1> DBLOGIN USERID ggadm1@source PASSWORD ...
阅读全文作者:dbdream | 分类:GoldenGate, Oracle | 标签:goldengate, Integrated Extract, OCI Error 26947, OGG, OGG-01755, ora-26947, REGISTER
-
新建OGG用户没有授权导致OGG-00664和OGG-00665错误
May172013在部署OGG的时候新建OGG用户忘记授权,目标端REPLICAT进程启动不了。 GGSCI (ycods1) 1> start treplva aftercsn 12354995266226 Sending START request to MANAGER ... REPLICAT TREPLVA starting GGSCI (ycods1) 2> info all Program Status Group Lag Time Since Chkpt ...
阅读全文
-
OGG启动REPLICAT进程又遇到OGG-00212错误
May172013今天在给客户安装OGG的时候,REPLICAT进程无法启动。 GGSCI (ycods1) 24> start REPCIMXB Sending START request to MANAGER ... REPLICAT REPCIMXB starting GGSCI (ycods1) 25> info all Program Status Group Lag Time Since Chkpt MANAGER RUNNING REPLICAT ABE ...
阅读全文
-
OGG-01296错误
May172013今天在部署OGG的时候目标端遇到OGG-01296错误。 2013-04-26 21:49:24 ERROR OGG-01296 Oracle GoldenGate Delivery for Oracle, treplva.prm: Error mapping from LPROMIS.T_JJ_AQYBZDFX to ODS_YYJC_BUF.T_JJ_AQYBZDFX. 2013-04-26 21:49:24 ERROR OGG-01668 Oracle GoldenGate Delivery for Oracle, trep ...
阅读全文
-
OGG启动PUMP进程遇到OGG-01044错误
May172013今天在给客户安装OGG的时候,PUMP进程无法启动。 GGSCI (ycods1) 21> start PUMPBAM Sending START request to MANAGER ... EXTRACT PUMPBAM starting GGSCI (ycods1) 22> info all Program Status Group Lag Time Since Chkpt MANAGER RUNNING EXTRACT RUNNING EX ...
阅读全文
-
OGG启动EXTRACT 进程遇到OGG-00664错误
May172013今天在给客户安装OGG的时候,EXTRACT进程无法启动。 GGSCI (ycods1) 4> start EXTBAM Sending START request to MANAGER ... EXTRACT EXTBAM starting GGSCI (ycods1) 5> info all Program Status Group Lag Time Since Chkpt MANAGER RUNNING EXTRACT STOPPED EXTBAM 00:00:00 02:59:08 EXTRACT STOP ...
阅读全文
-
OGG启动REPLICAT进程遇到OGG-00212错误
May172013今天在给客户安装OGG的时候,EXTRACT进程无法启动。 GGSCI (ycods1) 4> start EXTBAM Sending START request to MANAGER ... EXTRACT EXTBAM starting GGSCI (ycods1) 5> info all Program Status Group Lag Time Since Chkpt MANAGER RUNNING EXTRACT STOPPED ...
阅读全文
-
goldengate112101版本p14764589_112104补丁安装
Nov262012之前介绍了如何简单安装部署OGG,详见OGGoracle-golden-date简单部署本文主要介绍如何升级OGG的版本。 为了模拟在线系统OGG的升级,首先创建一个JOB,不停的修改EMP_OGG表的EMPNO字段。 SQL> conn scott/tiger SQL> declare 2 job_ogg number; 3 begin 4 dbms_job.submit(job_ogg, 5 'UPDATE EMP_OGG ...
阅读全文
-
OGG(oracle goldengate)简单部署ORACLE 11g-ORACLE 11g
Nov262012摘要:本文档为本人学习goldengate时的相关实验过程,仅供参考。 1.环境介绍 本文主要分介绍OGG的安装部署,下面是实验环境介绍。 实验规划: 项目 源环境 目标环境 操作系统 OEL 5.7 X86_64 OEL 5.7 X86_64 主机名 dbdream stream IP地址 1 ...
阅读全文