OGG-02022 Logmining server does not exist on this Oracle database.

extract进程启动失败：

GGSCI (cs-db) 16> start e_jaml

Sending START request to MANAGER ...
EXTRACT E_JAML starting
GGSCI (cs-db as c##ggs@orcl/JAM) 27> info all

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     RUNNING                                           
EXTRACT     STOPPED     D_JAML      00:00:00      00:29:15    
EXTRACT     RUNNING     D_JCMS      00:00:00      00:00:05    
EXTRACT     RUNNING     D_TO11      00:00:00      00:00:05    
EXTRACT     RUNNING     EXT_TO11    00:00:00      00:00:09    
EXTRACT     STOPPED     E_JAML      00:00:00      03:29:21    
EXTRACT     RUNNING     E_JCMS      00:00:00      00:00:02    
REPLICAT    RUNNING     R_18        00:00:00      00:00:01    
REPLICAT    RUNNING     R_JCMS      00:00:00      00:00:01  

 

查看报错：
GGSCI (cs-db) 19> view report E_JAML:
2019-03-04 14:07:13  ERROR   OGG-02022  Logmining server does not exist on this Oracle database.

2019-03-04 14:07:13  ERROR   OGG-01668  PROCESS ABENDING.

 

检查参数文件：
GGSCI (cs-db) 22> view param E_JAML

extract e_jaml
setenv (NLS_LANG="AMERICAN_AMERICA.ZHS16GBK")
setenv (ORACLE_SID="orcl")
setenv (ORACLE_HOME="/oracle/soft/u01/app/oracle/product/18.0.0/dbhome_1")
USERID c##ggs, password  admin123##

exttrail ./dirdat/zl
GETUPDATEBEFORES
GETTRUNCATES
BR BRINTERVAL 2H
CACHEMGR CACHESIZE 500MB
WARNLONGTRANS 2H,CHECKINTERVAL 5M
NUMFILES 4000
EOFDELAYCSECS 10
LOGALLSUPCOLS
TRANLOGOPTIONS INTEGRATEDPARAMS (max_sga_size 200, parallelism 2)
SOURCECATALOG JAM

DYNAMICRESOLUTION
discardfile ./dirrpt/jmzl.dsc,append, megabytes 200
TABLE lzl.*;

 

注册extract进程到pdb：

GGSCI (cs-db) 30> dblogin USERID c##ggs, password  admin123##;
Successfully logged into database CDB$ROOT.

GGSCI (cs-db as c##ggs@orcl/CDB$ROOT) 32> register extract E_JAML database container(jam)

2019-03-04 14:35:33  INFO    OGG-02003  Extract E_JAML successfully registered with database at SCN 38164922.

GGSCI (cs-db as c##ggs@orcl/CDB$ROOT) 34> start E_JAML

Sending START request to MANAGER ...
EXTRACT E_JAML starting

 问题解决

 

 

报错含义：

  OGG-02022  Logmining server does not exist on this Oracle database
ext进程没有登录到目标库

 

解决办法：
1.检查环境变量ORACLE_SID,ORACLE_HOME
2.检查extract进程参数，USERID那行和SOURCECATALOG
3.Register extract

 

参考文档：

Creating Extract Getting Error: OGG-02022 Logmining Server Does Not Exist On This Oracle Database. (Doc ID 2320611.1)