OGG采用NET8方式读取ASM中日志报OGG-00664(ORA-12162)，配置如下：

hanghangyang

环境是双节点RAC（GI 11.2.0.4/DB 11.2.0.4）
OGG版本12.1.2.1.0

NET8方式/BEQ方式还是DBLOGREADER方式都报同样的错误

过程如下：

tnsnames.ora文件中增加:
ASM =
(DESCRIPTION =
   (ADDRESS = (PROTOCOL = TCP)(HOST = node1-vip)(PORT = 1521))
   (LOAD_BALANCE = yes)
   (CONNECT_DATA =
     (SERVER = DEDICATED)
     (SERVICE_NAME = +ASM)
     (INSTANCE_NAME = +ASM1)
   )




extract进程配置参数如下：
EXTRACT ext1
EXTTRAIL ./dirdat/e1
USERID ggadmin, PASSWORD ggadmin
TRANLOGOPTIONS ASMUSER sys@asm, ASMPASSWORD oracle
--TRANLOGOPTIONS ASMUSER sys@ASM_BEQ, ASMPASSWORD oracle
--TRANLOGOPTIONS DBLOGREADER
--USERID ggadmin@prod_beq, PASSWORD ggadmin
WILDCARDRESOLVE DYNAMIC
DYNAMICRESOLUTION
TABLE test.*;


GGSCI (node1.example.com as ggadmin@ora11g1) 15> ADD EXTRACT ext1, TRANLOG, BEGIN NOW, THREADS 2
EXTRACT added.


GGSCI (node1.example.com as ggadmin@ora11g1) 16> ADD EXTTRAIL ./dirdat/e1, EXTRACT ext1, MEGABYTES 10
EXTTRAIL added.


GGSCI (node1.example.com as ggadmin@ora11g1) 17> info all

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     RUNNING                                          
EXTRACT     STOPPED     EXT1        00:00:00      00:00:27   


GGSCI (node1.example.com as ggadmin@ora11g1) 18> start ext1

Sending START request to MANAGER ...
EXTRACT EXT1 starting


GGSCI (node1.example.com as ggadmin@ora11g1) 19> info all

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     RUNNING                                          
EXTRACT     STOPPED     EXT1        00:00:00      00:00:37   


GGSCI (node1.example.com as ggadmin@ora11g1) 22> view report ext1


***********************************************************************
                 Oracle GoldenGate Capture for Oracle
   Version 12.1.2.1.0 OGGCORE_12.1.2.1.0_PLATFORMS_140727.2135.1_FBO
   Linux, x64, 64bit (optimized), Oracle 12c on Aug  7 2014 10:40:21

Copyright (C) 1995, 2014, Oracle and/or its affiliates. All rights reserved.


                    Starting at 2015-05-06 04:42:16
***********************************************************************

Operating System Version:
Linux
Version #1 SMP Sat Jun 23 02:39:07 EDT 2012, Release 2.6.39-200.24.1.el6uek.x86_64
Node: node1.example.com
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: 9337

Description:

***********************************************************************
**            Running with the following parameters                  **
***********************************************************************

2015-05-06 04:42:16  INFO    OGG-03059  Operating system character set identified as UTF-8.

2015-05-06 04:42:16  INFO    OGG-02695  ANSI SQL parameter syntax is used for parameter parsing.
EXTRACT ext1
EXTTRAIL ./dirdat/e1
USERID ggadmin, PASSWORD *******

Source Context :
  SourceModule            : [ggdb.ora.sess]
  SourceID                : [/scratch/aime1/adestore/views/aime1_adc4150384/oggcore/OpenSys/src/gglib/ggdbora/ocisess.c]
  SourceFunction          : [oci_try]
  SourceLine              : [816]
  ThreadBacktrace         : [17] elements
                          : [/u01/app/ogg/libgglog.so(CMessageContext::AddThreadContext()+0x1e) [0x7fcaf01f4dae]]
                          : [/u01/app/ogg/libgglog.so(CMessageFactory::CreateMessage(CSourceContext*, unsigned int, ...)+0x340) [0x7fcaf01efac0]]
                          : [/u01/app/ogg/libgglog.so(_MSG_ERR_ORACLE_OCI_ERROR_WITH_DESC(CSourceContext*, int, char const*, char const*, CMessageFactory::MessageDispo
sition)+0x41) [0x7fcaf01d89bf]]
                          : [/u01/app/ogg/extract(OCISESS_context_def::oci_try(int, char const*, ...)+0x4e2) [0x6fc8b2]]
                          : [/u01/app/ogg/extract(OCISESS_context_def::logon(ggs::gglib::ggapp::CLoginName const&, ggs::gglib::ggapp::CDBObjName<(DBObjType)12> const&,
ggs::gglib::ggunicode::UString const&, int, bool, int)+0x2b2) [0x6f91a2]]
                          : [/u01/app/ogg/extract(DBOCI_init_connection_logon(ggs::gglib::ggapp::CLoginName const&, ggs::gglib::ggapp::CDBObjName<(DBObjType)12> const&
, char const*, int, int, int, char*)+0x83) [0x6be633]]
                          : [/u01/app/ogg/extract() [0x6ef4dd]]
                          : [/u01/app/ogg/extract() [0x6ef6c3]]
                          : [/u01/app/ogg/extract(gl_odbc_param(char const*, char const*, char (&) [2048])+0x5a) [0x6ef9fa]]
                          : [/u01/app/ogg/extract(get_infile_params(time_elt_def*, time_elt_def*, char**)+0x10a5) [0x59a175]]
                          : [/u01/app/ogg/extract(extract_main(int, char**)+0x109) [0x5bfd89]]
                          : [/u01/app/ogg/extract(ggs::gglib::MultiThreading::MainThread::ExecMain()+0x4f) [0x6ab4df]]
                          : [/u01/app/ogg/extract(ggs::gglib::MultiThreading::Thread::RunThread(ggs::gglib::MultiThreading::Thread::ThreadArgs*)+0x104) [0x6ab9e4]]
                          : [/u01/app/ogg/extract(ggs::gglib::MultiThreading::MainThread::Run(int, char**)+0x8b) [0x6abdab]]
                          : [/u01/app/ogg/extract(main+0x3f) [0x5bfa2f]]
                          : [/lib64/libc.so.6(__libc_start_main+0xfd) [0x361001ecdd]]
                          : [/u01/app/ogg/extract() [0x534319]]

2015-05-06 04:42:16  ERROR   OGG-00664  OCI Error during OCIServerAttach (status = 12162-ORA-12162: TNS:net service name is incorrectly specified).

2015-05-06 04:42:16  ERROR   OGG-01668  PROCESS ABENDING.


GGSCI (node1.example.com as ggadmin@ora11g1) 23>


问题是出在监听上面？但是监听我看着OK啊？？


[04:45:30 oracle@node1 admin]$lsnrctl status

LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 06-MAY-2015 04:45:34

Copyright (c) 1991, 2013, Oracle.  All rights reserved.

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 11.2.0.4.0 - Production
Start Date                06-MAY-2015 04:31:04
Uptime                    0 days 0 hr. 14 min. 30 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/app/11.2.0/network/admin/listener.ora
Listener Log File         /u01/app/grid/diag/tnslsnr/node1/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.56.81)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.56.83)(PORT=1521)))
Services Summary...
Service "+ASM" has 1 instance(s).
  Instance "+ASM1", status READY, has 1 handler(s) for this service...
Service "ora11g.example.com" has 1 instance(s).
  Instance "ora11g1", status READY, has 1 handler(s) for this service...
Service "ora11gXDB.example.com" has 1 instance(s).
  Instance "ora11g1", status READY, has 1 handler(s) for this service...
The command completed successfully
[04:45:34 oracle@node1 admin]$tnsping asm

TNS Ping Utility for Linux: Version 11.2.0.4.0 - Production on 06-MAY-2015 04:45:39

Copyright (c) 1997, 2013, Oracle.  All rights reserved.

Used parameter files:


Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = node1-vip)(PORT = 1521)) (LOAD_BALANCE = yes) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = +ASM) (INSTANCE_NAME = +ASM1)))
OK (0 msec)
[04:45:39 oracle@node1 admin]$

麻烦了...

hanghangyang

什么情况呢？

wjl7813

建议  使用DBlogreader