E.2.3 Creating and Populating the ENCKEYS Lookup File

  1. On the source system, open a new ASCII text file.
  2. For each key value that you generated, enter a logical name of your choosing, followed by the key value itself.
    • The key name can be a string of 1 to 24 alphanumeric characters without spaces or quotes.

    • Place multiple key definitions on separate lines.

    • Do not enclose a key name or value within quotes; otherwise it is interpreted as text.

      Use the following sample ENCKEYS file as a guide.

      Encryption key name Encryption key value
      ## Key name
      superkey
      secretkey
      superkey1
      superkey2
      superkey3
      Key value
      0x420E61BE7002D63560929CCA17A4E1FB
      0x027742185BBF232D7C664A5E1A76B040
      0x42DACD1B0E94539763C6699D3AE8E200
      0x0343AD757A50A08E7F9A17313DBAB045
      0x43AC8DCE660CED861B6DC4C6408C7E8A
  3. Save the file as the name ENCKEYS in all upper case letters, without an extension, in the Oracle GoldenGate installation directory.
  4. Copy the ENCKEYS file to the Oracle GoldenGate installation directory on every system. The key names and values in all of the ENCKEYS files must be identical, or else the data exchange will fail and Extract and Collector will abort with the following message:
    GGS error 118 – TCP/IP Server with invalid data.