This discussion is archived
10 Replies Latest reply: Jan 14, 2013 10:49 PM by EB RSS

Initial Load Error

EB Newbie
Currently Being Moderated
Hi All
I am trying to make inital load but I am receiving the following error.
But trail file has been created on target in dirdat folder about 2GB size
Source and Destination windows2003 32 Bit
GG version is 11.2.1.0.1 OGGCORE_11.2.1.0.1_PLATFORMS_120423.0230

Have you any idea??

Source Context :
SourceModule : [er.extrout]
SourceID : [er/extrout.c]
SourceFunction : [complete_tcp_msg]
SourceLine : [1480]

2013-01-09 18:00:57 ERROR OGG-01033 There is a problem in network communication, a remote file problem, encryption keys for target and source do not match (if using ENCRYPT) or an unknown error. (Remote file used is ./dirdat/INITLOAD01.DAT, reply received is Error 0 (The operation completed successfully.) getting position in ./dirdat/INITLOAD01.DAT).

2013-01-09 18:00:57 ERROR OGG-01668 PROCESS ABENDING.

ggserr.log on target
OGG-01223 Oracle GoldenGate Collector for Oracle: Error 0 (The operation completed successfully.) getting position in ./dirdat/INITLOAD01.DAT.
INFO OGG-01670 Oracle GoldenGate Collector for Oracle: Closing ./dirdat/INITLOAD01.DAT.
INFO OGG-01676 Oracle GoldenGate Collector for Oracle: Terminating after client disconnect
  • 1. Re: Initial Load Error
    stevencallan Expert
    Currently Being Moderated
    What is your parameter file for creating the dat file?
  • 2. Re: Initial Load Error
    EB Newbie
    Currently Being Moderated
    So sorry I forget

    EXTRACT INT_EXT
    SOURCEISTABLE
    USERID ggs_admin@TEST PASSWORD ggsadmin
    RMTHOST GGSSERVER,MGRPORT 7809
    RMTFILE ./dirdat/INITLOAD01.DAT, PURGE
    TABLE X.*;
  • 3. Re: Initial Load Error
    stevencallan Expert
    Currently Being Moderated
    Are you connecting to a remote host, but specifying a local (relative to the target) file? What does "." mean for the curent position for the remote host?

    Plus, see page 203 of http://docs.oracle.com/cd/E35209_01/doc.1121/e29397.pdf. Your file naming is off a good bit.
  • 4. Re: Initial Load Error
    EB Newbie
    Currently Being Moderated
    trail file has created in dirdat directory that is under gg installation directory.
    Also Document says <path name> is the relative or fully qualified name during the load.
    I am starting initial extract in ggsci start int_ext is that problem ? should I start via os command line ??
  • 5. Re: Initial Load Error
    stevencallan Expert
    Currently Being Moderated
    Where is the rmttrail on the target machine?

    -- Remote trail on the remote host
    RMTTRAIL /ggs/dirdat/aa

    Edited by: stevencallan on Jan 10, 2013 2:27 PM
  • 6. Re: Initial Load Error
    EB Newbie
    Currently Being Moderated
    hii
    I changed config

    EXTRACT INT_EXT
    SOURCEISTABLE
    USERID ggs_admin@TEST PASSWORD ggsadmin
    RMTHOST GGSSERVER,MGRPORT 7809
    RMTFILE C:\gg\dirdat\INITLOAD01.DAT,MEGABYTES 1000,PURGE
    TABLE X.*;
    but nothing has changed
    sometimes C:\gg\dirdat\INITLOAD01.DAT file created about 2.1 GB sometimes about 2.4 GB
    Best Regards
  • 7. Re: Initial Load Error
    stevencallan Expert
    Currently Being Moderated
    Why do you keep naming the file?
    Enter the parameters listed in Table 26 in the order shown, starting a new line for each
    parameter statement. The following is a sample initial-load Extract parameter file for
    loading data from file to Replicat.
    <your extract name>
    SOURCEISTABLE
    SOURCEDB mydb, USERID ogg, PASSWORD
    AACAAAAAAAAAAAJAUEUGODSCVGJEEIUGKJDJTFNDKEJFFFTC &
    AES128, ENCRYPTKEY securekey1
    RMTHOST ny4387, MGRPORT 7888, ENCRYPT AES 192 KEYNAME mykey
    ENCRYPTTRAIL AES192, KEYNAME mykey1
    RMTFILE /ggs/dirdat/initld, MEGABYTES 2, PURGE
    TABLE hr.*;
    TABLE sales.*;
  • 8. Re: Initial Load Error
    EB Newbie
    Currently Being Moderated
    Hello
    it is about file size
    ID 1195705.1
    Thanks for helps
  • 9. Re: Initial Load Error
    stevencallan Expert
    Currently Being Moderated
    Where in that note do you see anything remotely close to naming a file with what you are using?
    rmtfile /gg/dirdat/rf, maxfiles 10, megabytes 2000
    The remote files created above would be a series of 10 files, in ascending numeric order with a common 2 character prefix. This is the definition of a remote file/trail (rmttrail). This allows the replicat to treat the initial load files as a trail, complete with recovery capabilities.
  • 10. Re: Initial Load Error
    EB Newbie
    Currently Being Moderated
    Sorry I did not understand exactly what do you mean ?

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points