Say first, attached configuration:
Start the start in the source end ggsci w1extdp, error message is as follows:

On the target side has a similar error:

The file does not exist, but under/opt/gg/trails/have a similar file, but the file name is longer than the above file name (more than 3 zero)

Ogg to extract the generated log file name length, than ogg replicat need log file name length is longer, so would be an error,
The question is, why this inconsistency situation? How to solve?

- source side configuration:
GGSCI (rhel7ogg2 localdomain) 33 & gt; The view params MGR

The PORT 7809
USERID goldengate @ former, PASSWORD goldengate
PURGEOLDEXTRACTS/opt/gg/trails/w1 *, USECHECKPOINTS, MINKEEPFILES 10
AUTORESTART ER *, RETRIES, 3 WAITMINUTES 5
MAXKEEPDAYS PURGEMARKERHISTORY MINKEEPDAYS 3, 5, FREQUENCYMINUTES 30
ACCESSRULE, PROG SERVER, ALLOW


GGSCI (rhel7ogg2. Localdomain) 34 & gt; The view params w1ext

EXTRACT w1ext
USERID goldengate @ former, PASSWORD goldengate
EXTTRAIL/opt/gg/trails/w1
DISCARDFILE w1extdsc, APPEND, 5 MEGABYTES
DDL INCLUDE MAPPED
DDLOPTIONS ADDTRANDATA
FETCHOPTIONS USESNAPSHOT, NOUSELATESTVERSION, MISSINGROW REPORT
STATOPTIONS REPORTFETCH
1 h, WARNLONGTRANS CHECKINTERVAL 5 m
TABLE goldengate. *;

GGSCI (rhel7ogg2 localdomain) 35 & gt; The view params w1extdp

EXTRACT w1extdp
USERID goldengate @ former, PASSWORD goldengate
RMTHOST 192.168.56.101 MGRPORT 7809
RMTTRAIL/opt/gg/trails/w1
DISCARDFILE w1extdpdsc, APPEND, 5 MEGABYTES
TABLE goldengate. *;
GGSCI (rhel7ogg2 localdomain) 36 & gt; The info all

The Program Status Group Lag at Chkpt Time Since Chkpt

The MANAGER RUNNING
EXTRACT RUNNING W1EXT 00:00:00 00:00:02
EXTRACT ABENDED W1EXTDP 18:26:33 00:55:05
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
- target side configuration:
GGSCI (rhel7ogg1 localdomain as goldengate @ former) 83 & gt; The view params MGR

The PORT 7809
USERID goldengate @ former, PASSWORD goldengate
PURGEOLDEXTRACTS/opt/gg/trails/w1 *, USECHECKPOINTS, MINKEEPFILES 10
AUTORESTART ER *, RETRIES, 3 WAITMINUTES 5
MAXKEEPDAYS PURGEMARKERHISTORY MINKEEPDAYS 3, 5, FREQUENCYMINUTES 30
ACCESSRULE, PROG SERVER, ALLOW


GGSCI (rhel7ogg1 localdomain as goldengate @ former) 84 & gt; The view params w1rep

REPLICAT w1rep
ASSUMETARGETDEFS
USERID goldengate @ former, PASSWORD goldengate
DISCARDFILE w1repdsc, APPEND, 5 MEGABYTES
DDL INCLUDE MAPPED
DDLOPTIONS REPORT
BATCHSQL
DBOPTIONS DEFERREFCONST
DBOPTIONS LOBWRITESIZE 102400
HANDLECOLLISIONS
DDLERROR DEFAULT the DISCARD RETRYOP MAXRETRIES 5 RETRYDELAY 20
The MAP goldengate. *, TARGET goldengate. *;

CodePudding user response:

1, to determine the network is connected under the
To the target client 192.168.56.101
2, determine the target side deposit/opt/gg/trails/whether there is enough permissions

CodePudding user response:

reference 1st floor liuzhijian2008x response:

1, determine the network is connected under the
To the target client 192.168.56.101
2, determine the target side deposit/opt/gg/trails/whether there is enough permissions

Network communication, can copy, the generated file directory name length is too long, with an error in the log needs do not match the file name, more than 3 0

CodePudding user response:

refer to the second floor karderax response:

Quote: refer to 1st floor liuzhijian2008x response:

1, to determine the network is connected under the
To the target client 192.168.56.101
2, determine the target side deposit/opt/gg/trails/whether there is enough permissions

Network communication, can copy, the generated file directory name length is too long, with an error in the log needs do not match the file name, more than 3 0

Has generated file is/opt/gg/trails/w1000000001, but need to file name is:/opt/gg/trails/w1000001

CodePudding user response:

You this path should be the default is not allowed,
You change the directory path to OGG dirdat directory,
Build your own environment, playing back with process,

CodePudding user response:

EXTRACT mgoupext
The SETENV (ORACLE_HOME="/oracle/database/product/11.2.0 dbhome_1")
The SETENV (NLS_LANG=AMERICAN_AMERICA. AL32UTF8)
USERID GGS, PASSWORD GGS
TRANLOGOPTIONS EXCLUDEUSER GGS
EXTTRAIL/opt/GGS/dirdat/muser/ac
DISCARDFILE./dirrpt mgroupext1. DSC, APPEND, MEGABYTES 512
DBOPTIONS ALLOWNOLOGGING
DBOPTIONS ALLOWUNUSEDCOLUMN
TRANLOGOPTIONS DBLOGREADER
FETCHOPTIONS USESNAPSHOT, NOUSELATESTVERSION, MISSINGROW REPORT
STATOPTIONS REPORTFETCH
DDL INCLUDE mapped
DDLOPTIONS ADDTRANDATA
WARNLONGTRANS 2 h, CHECKINTERVAL 15 m
TABLE MUSER. *;


EXTRACT modtoss
The SETENV (ORACLE_HOME="/oracle/database/product/11.2.0 dbhome_1")
The SETENV (NLS_LANG=AMERICAN_AMERICA. AL32UTF8)
USERID GGS, PASSWORD oracleggs
nullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnull