-
新建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-00423错误
May172013在部署OGG的时候目标端REPLICAT进程异常终止。 GGSCI (ycods1) 4> info all Program Status Group Lag Time Since Chkpt MANAGER RUNNING REPLICAT ABENDED TREPLVA 00:00:00 04:25:45 经过分析发现遇到OGG-00423错误。 MAP resolved (entry STDPM.T_SXM_WORKS ...
阅读全文
-
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-00446错误解决
May172013部署OGG的时候，REPLICAT进程启动失败。 GGSCI (tsycodsdb) 16> info all Program Status Group Lag Time Since Chkpt MANAGER RUNNING REPLICAT RUNNING REPJJ 00:00:00 00:00:09 REPLICAT RUNNING REPYY 00:00:00 00:00:04 REPLICAT ...
阅读全文
-
ORACLE 10.2.0.4外部表并行卸载数据测试
May172013最近一直在给客户部署OGG，客户的一个应用数据库使用了VPD加密数据，而且源端和目标端的表结构不一致，这样传统的EXP/EXPDP无法满足数据初始化，于是我使用了外部表来初始化数据，在默认模式下，经过测试，外部表每秒可以卸载1G的数据，本文主要对比并行模式下，外部表的卸载效率。 以下是测试表实验表，大小约2G。 SQL ...
阅读全文
-
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 ...
阅读全文