本文主要向大家介绍了Oracle数据库之OGG-00664，通过具体的内容向大家展现，希望对大家学习Oracle数据库有所帮助。

在一个复杂的环境下，比如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  

本文由职坐标整理并发布，希望对同学们学习Oracle有所帮助，更多内容请关注职坐标数据库Oracle数据库频道！