Posted by: michaelverzijl | 13/10/2011

GoldenGate – Checkparams

One of the parameters I noticed in the manual was “CHECKPARAMS”

Use the CHECKPARAMS parameter to test the syntax of a parameter file. To start the test:
1. Edit the parameter file to add CHECKPARAMS.
2. (Optional) To verify the tables, add the NODYNAMICRESOLUTION parameter.
3. Start the process. Without processing data, Oracle GoldenGate audits the syntax. If
NODYNAMICRESOLUTION exists, Oracle GoldenGate connects to the database to verify that
the tables specified with TABLE or MAP exist. If there is a syntax failure, the process
abends with error 190. If the syntax succeeds, the process stops and writes a message
to the report file that the parameters processed successfully.
4. Do one of the following:

  • If the test succeeds, edit the file to remove the CHECKPARAMS parameter and the NODYNAMICRESOLUTION parameter, if used, and then start the process again to begin processing.
  • If the test fails, edit the parameter file to fix the syntax based on the report’s findings, and then remove NODYNAMICRESOLUTION and start the process again. CHECKPARAMS can be positioned anywhere within the parameter file.

To do a test:

EXTRACT ext1
USERID ggs_owner, PASSWORD ggs_owner
exttrail ./dirdat/t1
CHECKPARAMS
TABLE schema_src.TABEL;

The result is visible in the report file EXT1.RPT:

***********************************************************************
                 Oracle GoldenGate Capture for Oracle
                     Version 11.1.1.0.0 Build 078
      Windows x64 (optimized), Oracle 11 on Jul 28 2010 15:04:33

Copyright (C) 1995, 2010, Oracle and/or its affiliates. All rights reserved.

                    Starting at 2011-10-13 20:21:29
***********************************************************************

Operating System Version:
Microsoft Windows 7 , on x64
Version 6.1 (Build 7600: )

Process id: 7200

Description:

***********************************************************************
**            Running with the following parameters                  **
***********************************************************************
EXTRACT ext1
USERID ggs_owner, PASSWORD *********
exttrail ./dirdat/t1
CHECKPARAMS
TABLE schema_srasdc.TABEL;
Parameters processed successfully.

 
If a error is made in the syntax of the file, you will see:

***********************************************************************
                 Oracle GoldenGate Capture for Oracle
                     Version 11.1.1.0.0 Build 078
      Windows x64 (optimized), Oracle 11 on Jul 28 2010 15:04:33

Copyright (C) 1995, 2010, Oracle and/or its affiliates. All rights reserved.

                    Starting at 2011-10-13 20:21:10
***********************************************************************

Operating System Version:
Microsoft Windows 7 , on x64
Version 6.1 (Build 7600: )

Process id: 7900

Description:

***********************************************************************
**            Running with the following parameters                  **
***********************************************************************
EXTRACT ext1
USERID ggs_owner, PASSWORD *********
exttraidl ./dirdat/t1

Source Context :
  SourceModule            : [er.main]
  SourceID                : [er/rep.c]
  SourceFunction          : [get_infile_params]
  SourceLine              : [12083]
  ThreadBacktrace         : [7] elements
                          : [c:\Oracle\GoldenGate\extract.exe(ERCALLBACK+0x2521c4) [0x000000014032DED4]]
                          : [c:\Oracle\GoldenGate\extract.exe(ERCALLBACK+0x20e688) [0x00000001402EA398]]
                          : [c:\Oracle\GoldenGate\extract.exe(<exe) [0x0000000140094F7D]]
                          : [c:\Oracle\GoldenGate\extract.exe(<exe) [0x00000001400BCBC5]]
                          : [c:\Oracle\GoldenGate\extract.exe(releaseCProcessManagerInstance+0x1e7d0) [0x00000001403966B0]]
                          : [C:\windows\system32\kernel32.dll(BaseThreadInitThunk+0xd) [0x000000007711F33D]]
                          : [C:\windows\SYSTEM32\ntdll.dll(RtlUserThreadStart+0x21) [0x00000000776C2CC1]]

2011-10-13 20:21:10  ERROR   OGG-00303  Unrecognized parameter (exttraidl).

2011-10-13 20:21:10  ERROR   OGG-01668  PROCESS ABENDING.

Checkparams will only check the syntax of the parameter file. It will not check if the tables exists provided in the mapping.
If you want to run the extract/replicat please make sure you remove the CHECKPARAMS from the parameter file.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

Categories

%d bloggers like this: