在一个复杂的环境下,比如OGG、RAC、ADG等,修改IP地址或者端口一定要考虑周全,不然就可能会对其系统造成影响。
<hxdevdb:hxdevdb:/ora12data/ogg>$./ggsci
Oracle GoldenGate Command Interpreter for Oracle
Version 12.3.0.1.4 OGGCORE_12.3.0.1.0_PLATFORMS_180415.0359_FBO
AIX 6, ppc, 64bit (optimized), Oracle 12c on Apr 19 2018 09:40:59
Operating system character set identified as US-ASCII.
Copyright (C) 1995, 2018, Oracle and/or its affiliates. All rights reserved.
GGSCI (hxdevdb) 1> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
EXTRACT ABENDED EX_TDAS 00:00:00 267:41:05 --进程异常
EXTRACT RUNNING P_TDAS 00:00:00 00:00:08
GGSCI (hxdevdb) 2>
--查看报错信息
GGSCI (hxdevdb) 4> view report ex_tdas
***********************************************************************
Oracle GoldenGate Capture for Oracle
Version 12.3.0.1.4 OGGCORE_12.3.0.1.0_PLATFORMS_180415.0359_FBO
AIX 6, ppc, 64bit (optimized), Oracle 12c on Apr 19 2018 09:41:06
Copyright (C) 1995, 2018, Oracle and/or its affiliates. All rights reserved.
Starting at 2019-01-07 13:48:58
***********************************************************************
Operating System Version:
AIX
Version 7, Release 1
Node: hxdevdb
Machine: 00F768554C00
soft limit hard limit
Address Space Size : unlimited unlimited
Heap Size : unlimited unlimited
File Size : unlimited unlimited
CPU Time : unlimited unlimited
Process id: 44564598
Description:
***********************************************************************
** Running with the following parameters **
***********************************************************************
2019-01-07 13:48:58 INFO OGG-03059 Operating system character set identified as US-ASCII.
2019-01-07 13:48:58 INFO OGG-02695 ANSI SQL parameter syntax is used for parameter parsing.
2019-01-07 13:48:58 INFO OGG-01360 EXTRACT is running in Integrated mode.
EXTRACT ex_tdas
USERIDALIAS oggsource
Source Context :
SourceModule : [ggdb.ora.sess]
SourceID : [/scratch/jkrath/view_storage/jkrath_oggaix123vw/oggcore/OpenSys/src/gglib/ggdbora/ocisess.c]
SourceMethod : [OCISESS_context_def::oci_try(int, const char *, ...)]
SourceLine : [978]
2019-01-07 13:48:59 ERROR OGG-00664 OCI Error during OCIServerAttach (status = 12541-ORA-12541: TNS:no listener).
--提示监听问题,了解发现监听的端口被修改为20198。
2019-01-07 13:48:59 ERROR OGG-01668 PROCESS ABENDING.
<hxdevdb:hxdevdb:/home/oracle/product/12.2.0/db_1/network/admin>$vi tnsnames.ora
OGGS =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = hxdevdb)(PORT =** 6666**))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = hxdevdb)
)
)
--tnsnames.ora 这个文件端口修改为20198,也就是现在监听的端口
GGSCI (hxdevdb) 2> start ex_tdas
Sending START request to MANAGER ...
EXTRACT EX_TDAS starting
GGSCI (hxdevdb) 3> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
EXTRACT RUNNING EX_TDAS 00:00:00 268:17:54 --恢复正常
EXTRACT RUNNING P_TDAS 00:00:00 00:00:06
GGSCI (hxdevdb) 4> view report ex_tdas
GGSCI (hxdevdb) 5> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
EXTRACT ABENDED EX_TDAS 00:00:00 268:18:20
EXTRACT RUNNING P_TDAS 00:00:00 00:00:01