目标端rep进程启动 OGG-00665
环境描述system oel5.7
db：11.2.0.4 单机
ogg Version ：11.2.1.0.1
个人学习环境，source端和target端环境一样 ogg oracle->oracle
源端运行正常，pump进程能成功将trail文件推送至目标端。启动目标端R进程的时候，报错
2014-03-04 16:43:32 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (ogg): start rep1.
2014-03-04 16:43:32 INFO OGG-00963 Oracle GoldenGate Manager for Oracle, mgr.prm: Command received from GGSCI on host linusfay-target (START REPLICAT REP1 ).
2014-03-04 16:43:32 INFO OGG-00975 Oracle GoldenGate Manager for Oracle, mgr.prm: REPLICAT REP1 starting.
2014-03-04 16:43:32 INFO OGG-00995 Oracle GoldenGate Delivery for Oracle, rep1.prm: REPLICAT REP1 starting.
2014-03-04 16:43:32 INFO OGG-03035 Oracle GoldenGate Delivery for Oracle, rep1.prm: Operating system character set identified as UTF-8. Locale: en_US, LC_ALL:.
2014-03-04 16:43:32 ERROR OGG-00665 Oracle GoldenGate Delivery for Oracle, rep1.prm: OCI Error describe for query (status = 942-ORA-00942: table or view does not exist), SQL<SELECT db.name, i
.instance_name, i.version FROM v$database db, v$instance i>.
2014-03-04 16:43:32 ERROR OGG-01668 Oracle GoldenGate Delivery for Oracle, rep1.prm: PROCESS ABENDING.
现将目标端mgr和rep1进程参数文件
MGR：
PORT 7830
dynamicportlist 7831-7840
autorestart extract *,waitminutes 2, retries 5
rep1 进程
replicat rep1
SETENV(ORACLE_SID="ORCL2")
SETENV(NLS_LANG="AMERICAN_AMERICA.AL32UTF8")
userid ggs,password oracle
assumetargetdefs
reperror default,discard
discardfile /u01/repsz.dsc,append,megabytes100
gettruncates
map linusfay.test1, target linusfay.test1;
view report rep1：
GGSCI (linusfay-target) 3> view report rep1
***********************************************************************
Oracle GoldenGate Delivery for Oracle
Version 11.2.1.0.1 OGGCORE_11.2.1.0.1_PLATFORMS_120423.0230_FBO
Linux, x64, 64bit (optimized), Oracle 11g on Apr 23 2012 08:48:07
Copyright (C) 1995, 2012, Oracle and/or its affiliates. All rights reserved.
Starting at 2014-03-04 16:43:32
***********************************************************************
Operating System Version:
Linux
Version #1 SMP Wed Jul 27 21:02:33 EDT 2011, Release 2.6.32-200.13.1.el5uek
Node: linusfay-target
Machine: x86_64
soft limit hard limit
Address Space Size : unlimited unlimited
Heap Size : unlimited unlimited
File Size : unlimited unlimited
CPU Time : unlimited unlimited
Process id: 8939
Description:
***********************************************************************
** Running with the following parameters **
***********************************************************************
2014-03-04 16:43:32 INFO OGG-03035 Operating system character set identified as UTF-8. Locale: en_US, LC_ALL:.
replicat rep1
SETENV(ORACLE_SID="ORCL2")
Set environment variable (ORACLE_SID=ORCL2)
SETENV(NLS_LANG="AMERICAN_AMERICA.AL32UTF8")
Set environment variable (NLS_LANG=AMERICAN_AMERICA.AL32UTF8)
userid ggs,password ******
Source Context :
SourceModule :
SourceID :
SourceFunction :
SourceLine :
ThreadBacktrace : elements
: ]
: ]
: [/u01/oracle/ogg/libgglog.so(_MSG_ERR_ORACLE_OCI_ERROR_WITH_DESC_SQL(CSourceContext*, int, char const*, char const*, char const*, CMessageFactory::MessageDisposition)+0
x4e) ]
: ]
: ]
: ]
: [/u01/oracle/ogg/replicat(ORAUTIL_getServerInfo(OCISESS_context_def*, unsigned int*, ggs::gglib::ggapp::CDBObjName<(DBObjType)8>*, ggs::gglib::ggunicode::UString*, ggs:
:gglib::ggunicode::UString*)+0x28e) ]
: ]
: ]
: [/u01/oracle/ogg/replicat(DBOCI_init_connection_logon(ggs::gglib::ggapp::CLoginName const&, ggs::gglib::ggapp::CDBObjName<(DBObjType)12> const&, char const*, int, int,
int, char*)+0xb5) ]
: ]
: ]
: ]
: ]
: ]
: ]
: ]
2014-03-04 16:43:32 ERROR OGG-00665 OCI Error describe for query (status = 942-ORA-00942: table or view does not exist), SQL<SELECT db.name, i.instance_name, i.version FROM v$database db, v$in
stance i>.
2014-03-04 16:43:32 ERROR OGG-01668 PROCESS ABENDING.
报错中提到 查看数据库版本与SID信息
目标端执行：
SQL> SELECT db.name, i
2 .instance_name, i.version FROM v$database db, v$instance i;
NAME INSTANCE_NAME VERSION
--------- ---------------- -----------------
ORCL2 ORCL2 11.2.0.4.0
设置了SETENV(ORACLE_SID="ORCL2") 报错显示和 sid等有关，不太理解。
把源端的ext参数文件也贴出来吧！
页:
[1]