How to check syntax of parameters in parameter files without logging to GGSCI prompt ?
Version :GoldenGate 12.2 new feature
Utility Name:checkprm
Location:GoldenGate Home
You are working on GoldenGate environment and want to build and test the parameter files
like
1.Manager parameter file
2.Extract parameter file
3.Datapump parameter file
4.Replicat parameter file
So one way to do this is to do edit <Parameter file Name>
and save and test it. If there is any typo you get error and then once again you need to
go back to edit <Parameter file Name> and that also in GGSCI prompt .
Its cumbersome and time consuming , Oracle Goldengate 12.2 onward it come up with an utility
called checkprm
Which you can run as below and check if everything in parameter files are syntactically
correct or not
[oracle@ggate1 ogg_trg]$ ./checkprm ./dirprm/mgr.prm -C mgr -v
Parameter file validation context:
component(s): MGR
mode(s) : N/A
platform(s) : Linux
database(s) : Oracle 12c
./dirprm/mgr.prm
port : 7809
2020-01-01 22:29:44 INFO OGG-10183 Parameter file ./dirprm/mgr.prm: Validity check: PASS.
Runtime parameter validation is not reflected in the above check.
Look at the last line it says " Runtime parameter validation is not reflected in the above check."
This means this utility only checks syntax not the runtime validation of the syntax
For more details you can follow the URL
https://docs.oracle.com/goldengate/c1221/gg-winux/GWURF/checkprm.htm#GWURF1245
Comments
Post a Comment