OGG验证参数文件的命令 checkprm

以下摘自官方文档： administering-oracle-goldengate.pdf 

The checkprm validation native command is run from the command line and gives an assessment of the specified parameter file, with a configurable application and running environment. It can provide either a simple PASS/FAIL or with optional details about how the values of each parameter are stored and interpreted

checkprm的帮助：

[oracle@redhat762100 ogg19c]$ ./checkprm ?
 
Usage: checkprm <param file> [--COMPONENT(-C) <component name>]
           [--MODE(-M) <mode name>] [--PLATFORM(-P) <platform name>]
           [--DATABASE(-D) <database name>] [--VERBOSE(-V)]
 
Possible options (case insensitive)
 
  COMPONENT (auto detect for extract and replicat) :
     CACHEFILEDUMP            COBGEN                   CONVCHK
     CONVPRM                  DDLCOB                   DEFGEN
     EMSCLNT                  EXTRACT                  GGCMD
     GGSCI                    KEYGEN                   LOGDUMP
     MGR                      OGGERR                   REPLICAT
     RETRACE                  REVERSE                  SERVER
     GLOBALS
 
  MODE :
     Classic Extract          Source Extract           Integrated Extract
     Initial Load Extract     Remote Task Extract      Data Pump Extract
     Passive Extract          Classic Replicat         Coordinated Replicat
     Integrated Replicat      Parallel Integrated Replicat
     Parallel Nonintegrated Replicat                   Special Run Replicat
     Remote Task Replicat     All
 
  PLATFORM (default value Linux) :
     AIX                      HP-OSS                   HPUX-IT
     HPUX-PA                  Linux                    OS400
     ZOS                      Solaris SPARC            Solaris x86
     Windows x64              All
 
  DATABASE (default value Oracle 19c) :
     Generic                  Oracle 8                 Oracle 9i
     Oracle 10g               Oracle 11g               Oracle 12c
     Oracle 18c               Oracle 19c               Sybase
     DB2LUW 9.5               DB2LUW 9.7               DB2LUW 10.5
     DB2LUW 10.1              DB2LUW 11.1              DB2 Remote
     Teradata                 Timesten                 Timesten 7
     Timesten 11.2.1          MySQL                    Ctree8
     Ctree9                   DB2 for i                DB2 for i Remote
     MS SQL                   MS SQL CDC               Informix
     Informix1150             Informix1170             Informix1210
     Ingres                   SQL/MX                   DB2 z/OS
     PostgreSQL
 
 

验证mgr参数:

[oracle@redhat762100 ogg19c]$ ./checkprm /u01/ogg19c/dirprm/mgr.prm -C mgr -v
 
Parameter file validation context:
 
component(s): MGR
mode(s)     : N/A
platform(s) : Linux
database(s) : Oracle 19c
 
 
/u01/ogg19c/dirprm/mgr.prm
 
port                                 : 7809
accessrule                           : <enabled>
  prog                               : SERVER
  allow                              : <enabled>
dynamicportlist                      : 7800-8000
autorestart                          : <enabled>
  extract                            : *
  retries                            : 5
  waitminutes                        : 7
lagreporthours                       : 1
purgeoldextracts                     : ./dirdat/ext1/*
  usecheckpoints                     : <enabled>
  minkeepdays                        : 3
laginfominutes                       : 30
lagcriticalminutes                   : 45
 
 
2023-01-11 10:55:51  INFO    OGG-10183  Parameter file /u01/ogg19c/dirprm/mgr.prm:  Validity check: PASS.
 
Runtime parameter validation is not reflected in the above check.
 


验证extract进程参数:

[oracle@redhat762100 ogg19c]$ ./checkprm /u01/ogg19c/dirprm/ext1.prm -C extract -v
 
2023-01-11 10:58:01  INFO    OGG-02095  Successfully set environment variable NLS_LANG=AMERICAN_AMERICA.AL32UTF8.
 
2023-01-11 10:58:01  INFO    OGG-02095  Successfully set environment variable ORACLE_HOME=/u01/app/oracle.
 
2023-01-11 10:58:01  INFO    OGG-02095  Successfully set environment variable ORACLE_SID=orcl.
 
Parameter file validation context:
 
component(s): EXTRACT
mode(s)     : N/A
platform(s) : Linux
database(s) : Oracle 19c
 
 
/u01/ogg19c/dirprm/ext1.prm
 
extract                              : ext1
setenv                               : (NLS_LANG="AMERICAN_AMERICA.AL32UTF8")
setenv                               : (ORACLE_HOME = "/u01/app/oracle")
setenv                               : (ORACLE_SID = "orcl")
userid                               : ogg
  password                           : *******
warnlongtrans                        : 4 hour(s)
  checkinterval                      : 10 minute(s)
dynamicresolution                    : <enabled>
exttrail                             : ./dirdat/ext1/ee
table                                : bb.t
 
 
(ext1.prm) line 7: Parsing error, [dynamicresolution] is deprecated.
 
2023-01-11 10:58:01  INFO    OGG-10183  Parameter file /u01/ogg19c/dirprm/ext1.prm:  Validity check: PASS.
 
Runtime parameter validation is not reflected in the above check.
 
[oracle@redhat762100 ogg19c]$