OGG采用NET8方式读取ASM中日志报OGG-00664(ORA-12162)，配置如下：
环境是双节点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 :
SourceID :
SourceFunction :
SourceLine :
ThreadBacktrace : elements
: ]
: ]
: [/u01/app/ogg/libgglog.so(_MSG_ERR_ORACLE_OCI_ERROR_WITH_DESC(CSourceContext*, int, char const*, char const*, CMessageFactory::MessageDispo
sition)+0x41) ]
: ]
: [/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) ]
: [/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) ]
: ]
: ]
: )+0x5a) ]
: ]
: ]
: ]
: ]
: ]
: ]
: ]
: ]
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啊？？
$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
$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)
$
麻烦了...
什么情况呢？ 建议 使用DBlogreader
页:
[1]