0 积分	1 好友	10 主题

发消息

目标端rep进程启动 OGG-00665

1^#

发表于 2014-3-4 17:54:15 | 查看: 4164| 回复: 1

环境描述
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          : [ggdb.ora.sess]
  SourceID             : [/scratch/aime1/adestore/views/aime1_adc4150256/oggcore/OpenSys/src/gglib/ggdbora/ocisess.c]
  SourceFunction       : [oci_try]
  SourceLine             : [643]
  ThreadBacktrace       : [17] elements
                        : [/u01/oracle/ogg/libgglog.so(CMessageContext::AddThreadContext()+0x1e) [0x7f418442806e]]
                        : [/u01/oracle/ogg/libgglog.so(CMessageFactory::CreateMessage(CSourceContext*, unsigned int, ...)+0x2cc) [0x7f418442444c]]
                        : [/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) [0x7f418441085c]]
                        : [/u01/oracle/ogg/replicat(OCISESS_context_def::oci_try(int, char const*, ...)+0x456) [0x620c76]]
                        : [/u01/oracle/ogg/replicat(OCISESS_context_def::get_param_count(OCIStmt*, int*, int*)+0x70) [0x61f100]]
                        : [/u01/oracle/ogg/replicat(OCISESS_context_def::select_start(bool, query_handle*, ggs::gglib::ggunicode::UString const&, short, ...)+0x11c) [0x61f3ac]]
                        : [/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) [0x62ab2e]]
                        : [/u01/oracle/ogg/replicat(DBOCI_get_ora_version(OCISESS_context_def*, unsigned int*, char*)+0x20) [0x5fef90]]
                        : [/u01/oracle/ogg/replicat(OCISESS_context_def::init_context(int, int)+0x465) [0x620685]]
                        : [/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) [0x5ffc65]]
                        : [/u01/oracle/ogg/replicat [0x5f541d]]
                        : [/u01/oracle/ogg/replicat [0x5f5690]]
                        : [/u01/oracle/ogg/replicat(odbc_param(char*, char*)+0x144) [0x5f5ab4]]
                        : [/u01/oracle/ogg/replicat(get_infile_params(time_elt_def*, time_elt_def*, char**)+0x1352) [0x522192]]
                        : [/u01/oracle/ogg/replicat(main+0x117) [0x548137]]
                        : [/lib64/libc.so.6(__libc_start_main+0xf4) [0x3b0861d994]]
                        : [/u01/oracle/ogg/replicat(__gxx_personality_v0+0x322) [0x4be48a]]

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等有关，不太理解。

分享0