The source library: Oracle11g
Object library: SQL server2012
What has happened is that the OGG already configured,
Process on both ends are open, as shown in figure
Oracle end
SQL server end
And the data file has been generated, as shown in figure
Oracle end
SQL server end

Target side copy process configuration is as follows:
Replicat REMSSQL
Sourcedefs C: \ oggmssql \ dirdef \ defgen def
The SETENV (NLS_LANG=SIMPLIFIED CHINESE_CHINA. ZHS16GBK)
Userid sa targetdb ogg, password P @ ssw0rd
Reperror default, discard
Discardfile C: \ oggmssql \ dirrpt \ REMSSQL DSC, append, megabytes 100
The map dbo gehuantest, target gehuan. Gehuantest;

The question now is:
SQL serve target side there is no data to come in, no error, each process so don't know what causes, please tell a great god! Thank you very much!!

CodePudding user response:

The target side if you have write wrong add replicat path

CodePudding user response:

reference 1st floor sxq129601 response:

add replicat path of the target side you have write wrong

Hello this is the add statements add replicat REMSSQL, exttrail C: \ oggmssql \ dirdat \ REMSSQL \ ex, begin now, checkpointtable dbo. Ckpttab
This path is the goal of the backend server ogg path, there is no wrong

CodePudding user response:

Target to see the info REMSSQL, showch debug operation

CodePudding user response:

reference sxq129601 reply: 3/f

objective to see the info REMSSQL, showch debug check for operating

GGSCI (WIN) - 4 ng6kikuipj as sa @ OGG 67 & gt; The info REMSSQL, showch debug

REPLICAT REMSSQL Last Started the 2019-10-30 men that Status RUNN
Checkpoint Lag 00:00:00 (updated 00:00:00 line)
The Process ID 2760
The Log Read Checkpoint File C: \ oggmssql \ dirdat \ REMSSQL \ ex000000004
The 2019-10-30 14:31:19. 830000 the RBA 3929418


The Current Checkpoint Detail:

Read: # 1

GGS Log Trail

Startup Checkpoint (starting position in the data source) :
The Sequence # : 4
The RBA: 2620425
Timestamp: the 2019-10-30 10:41:00. 814000
Extract Trail: C: \ oggmssql \ dirdat \ REMSSQL \ ex
Seqno Length: 6

The Current Checkpoint (the position of the last record read in the data s
The Sequence # : 4
The RBA: 3929418
Timestamp: the 2019-10-30 14:31:19. 830000
Extract Trail: C: \ oggmssql \ dirdat \ REMSSQL \ ex
9 Seqno Length:

Header:
Version=2
Record Source=A
Type=1
# Input Checkpoints=1
# the Output Checkpoints=0

The File Information:
Block Size=2048
Max Blocks=100
Record Length=2048
The Current Offset=0

Configuration:
Data Source=0
Transaction Integrity=1
Task Type=0

The Database Checkpoint:
Checkpoint table=dbo. Ckpttab
Key=973516930 (0 x3a06b082)
The Create Time=2019-10-30 10:39:54

Status:
The Start Time=2019-10-30 14:38:29
The Last Update Time=2019-10-31 10:01:12
The Stop Status=A
The Last Result=400
This is the execution of the information, it seems that there is no error,,,

CodePudding user response:

The send REPLICAT REMSSQL trace C: \ 111. The log
Modify synchronous table data source end, over 1 minute
The send REPLICAT REMSSQL trace off

Look at the log information

CodePudding user response:

The Log Read Checkpoint File C: \ oggmssql \ dirdat \ REMSSQL \ ex000000004
The 2019-10-30 14:31:19. 830000 the RBA 3929418
The rba looks have gone down, looked at do not have what problem

CodePudding user response:

reference 5 floor sxq129601 reply:

send REPLICAT REMSSQL trace C: \ 111. The log
Modify synchronous table data source end, over 1 minute
The send REPLICAT REMSSQL trace off

Look at the log information

Great god I don't understand what you mean,,, you let me do what?

CodePudding user response:

reference 5 floor sxq129601 reply:

send REPLICAT REMSSQL trace C: \ 111. The log
Modify synchronous table data source end, over 1 minute
The send REPLICAT REMSSQL trace off

Look at the log information

Is that right