Install Goldengate Veridata

Goldengate Veridata is Oracle's tool for comparing data consistency, supporting databases such as Oracle, Terdata, SQL Server, and more. Start the installation below:

Overall architecture:

Installation Environment:
Here I will install the Veridata server directly onto the AGENT1:

Agent1:name:zbdba1OS:redhat 6.3ip:192.168.56.60agent2:name:zbdba2os:redhat 6.3ip:192.168.56.61

Install the Veridata agent on Agent1 and Agent2:
Make sure the database is turned on before installing, and monitoring is turned on
Extract:
[Email protected] database]# Unzip V35569-01.zip
To enter the agent directory, configure the parameter file:

CP agent.properties.sample Agent.properties[[email protected] agent]# cat agent.propertiesserver.port= 1261database.url=jdbc:oracle:thin: @localhost: 1521:orcl11gserver.driverslocation = driversserver.jdbcdriver= ojdbc6.jardatabase.transaction.isolation=read_committed

To configure the JRE:

[Email protected] agent]# cat/root/.bash_profile# bash_profile# Get the aliases and Functionsif [-f ~/.BASHRC]; Then        . ~/.bashrcfi# User specific environment and startup Programspath= $PATH: $HOME/binexport pathexport java_home1= /jre1.7.0_75/binexport java_home=/jre1.7.0_75/export path= $PATH: $JAVA _home: $JAVA _home1

Start Agent
[[email protected] agent]#./agent.sh start
Monitoring log files:
[Email protected] ~]# Tail-100f/database/agent/veridata-agent.log

[Email protected] agent]# ps-ef |grep agentroot      2217  2198  0 22:11 pts/3    00:00:00 tail-100f/database/a Gent/veridata-agent.logroot      2546     1  0 22:36 pts/0    00:00:03/jre1.7.0_75//bin/java-xmx1024m- Xms1024m-djava.awt.headless=true-xx:+useparallelgc-jar/database/agent/javaagent.jarroot      2760  1491  0 23:05 pts/0    00:00:00 grep agent

Perform the same operation on the Agent2.

To install Veridata server on Agent1:

[Email protected] database]# unzip V35572-01.zip[[email protected] database]# export Display=192.168.56.1:0.0[[email Protected] database]#./goldengate_veridata_redhatas40_x64.sh Follow the graphical interface step-by-step installation

Install complete to see if the Veridata server process is started:

[[email protected] database]# ps-ef |grep veridataroot 1770 1750 0 21:27 pts/2 00:00:00 tail-1000f Verida Taweb.logroot 1852 1 0 21:29 pts/1 00:00:35/opt/oracle_goldengate_veridata/jre/bin/java-xms1024m-xmx1024m -djava.awt.headless=true-dveridata.home=/opt/oracle_goldengate_veridata-dveridata.log.dir=/opt/oracle_ Goldengate_veridata/shared/logs-dveridata.log.file=veridataweb.log-djava.util.logging.manager= org.apache.juli.classloaderlogmanager-djava.util.logging.config.file=/opt/oracle_goldengate_veridata/web/conf/ Logging.properties-djava.endorsed.dirs=/opt/oracle_goldengate_veridata/web/common/endorsed-classpath:/opt/ oracle_goldengate_veridata/web/bin/bootstrap.jar:/opt/oracle_goldengate_veridata/web/bin/ Commons-logging-api.jar-dcatalina.base=/opt/oracle_goldengate_veridata/web-dcatalina.home=/opt/oracle_ Goldengate_veridata/web-djava.io.tmpdir=/opt/oracle_goldengate_veridata/web/temp Org.apache.catalina.startup.Bootstrap Startroot 2217 2198 0 22:11 PTS/3 00:00:00 tail-100f/database/agent/veridata-agent.logroot 2778 1491 0 23:07 pts/0 00:00:00 grep veridata

View Log Status:

[[email protected] logs]# Tail-100f/opt/oracle_goldengate_veridata/shared/logs/veridataweb.loginfo ( 2015-03-08 21:27:09,179) [Abstractentitymanagerfactorybean:destroy, line 387]-Closing JPA entitymanagerfactory for per Sistence unit ' veridataserver ' INFO (2015-03-08 21:29:22,188) [Contextloader:initwebapplicationcontext, Line 182]-Root Webapplicationcontext:initialization Startedinfo (2015-03-08 21:29:22,279) [Abstractapplicationcontext: Preparerefresh, line 447]-refreshing Root webapplicationcontext:startup date [Sun Mar 21:29:22 EDT 2015]; Root of Context Hierarchyinfo (2015-03-08 21:29:22,367) [Xmlbeandefinitionreader:loadbeandefinitions, line 315]-Loadin G XML bean definitions from class path resource [Context-dao.xml]info (2015-03-08 21:29:23,568) [Xmlbeandefinitionreader: Loadbeandefinitions, line 315]-Loading XML beans definitions from class path resource [Context-bu.xml]info (2015-03-08 21 : 29:23,915) [Veridataconfig:<init>, line]-No override/veridata.cfg config FileINFO (2015-03-08 21:29:23,946) [Veridataconfig:<init>, line 124]-veridata.cfg location:/op T/oracle_goldengate_veridata/web/webapps/veridata/web-inf/classes/. /.. /.. /.. /.. /shared/conf/veridata.cfginfo (2015-03-08 21:29:24,281) [Defaultlistablebeanfactory:preinstantiatesingletons, line 532]-pre-instantiating singletons in org.s[email protected]5f4275d4:defining beans [Serverpassword, Repositorypassword,connectionwallet,agentpoolmanager,comparisonreportsdao,veridataconfig, Org.springframework.context.annotation.internalConfigurationAnnotationProcessor, Org.springframework.context.annotation.internalAutowiredAnnotationProcessor, Org.springframework.context.annotation.internalRequiredAnnotationProcessor, Org.springframework.context.annotation.internalCommonAnnotationProcessor, Org.springframework.context.annotation.internalPersistenceAnnotationProcessor, Org.springframework.aop.config.internalautoproxycreator,org.springframework.transaction.annotation.annotAtiontransactionattributesource#0,org.springframework.transaction.interceptor.transactioninterceptor#0, Org.springframework.transaction.config.internalTransactionAdvisor, Com.goldengate.veridata.util.veridatapropertyconfigurer#0,myemf,veridatadatasource,mytxmanager,connectiondao, Jobdao,profiledao,finishedstatsdao,groupdao,comparepairdao,userpreferencesdao,favoritedao,performancestatsdao, Veridatacontroldao,admindao,connectionmanager,jobmanager,groupmanager,comparepairmanager,profilemanager, Userpreferencesmanager,favoritetaskmanager,runmanager,finishedjobsmanager,metalookupmanager,oosreportsmanager, Performancestatsmanager,veridatacontrolmanager,comparisonreportsmanager]; Root of Factory Hierarchyinfo (2015-03-08 21:29:26,438) [Localcontainerentitymanagerfactorybean: Createnativeentitymanagerfactory, line 221] – Building JPA container entitymanagerfactory for persistence unit ' Veridatas Erver ' INFO (2015-03-08 21:29:28,118) [Sortermanager:<init>, line-up]-total sort memory is 766mINFO (2015-03-08 21:29:28,119) [Sortermanager:<init>, line +]-Maximum comparison memory is 100mINFO (2015-03-08 21: 29:28,119) [Sortermanager:<init>, line "]-the maximum number of concurrent writes is 4INFO (2015-03-08-21:29:28, [Sortermanager:<init>]-the maximum number of concurrent reads is 4INFO (2015-03-08 21:29:28,203) [ Contextloader:initwebapplicationcontext, line 202]-Root webapplicationcontext:initialization completed in 6012 MsINFO  (2015-03-08 21:29:28,728) [Versionbean:<init>, line]-loading Jar:file:/opt/oracle_goldengate_veridata/web/webapps/veridata/web-inf /lib/vericom.jar!/veridata-version.propertiesinfo (2015-03-08 21:29:28,728) [Veridatacontextlistener: Contextinitialized, line]-Oracle GoldenGate veridata server-version 11.2.1.0 oggvdt_11.2.1.0.0_platforms_121108.16 25INFO (2015-03-08 21:29:28,907) [Veridatasessionlogger:log, line]-Eclipselink, version:eclipse persistence Service s-2.1.2.v20101206-r8635INFO (2015-03-08 21:29:37,094) [Veridatasessionlogger:log, line]-file:/opt/oracle_goldengate_veridata/web/ Webapps/veridata/web-inf/lib/veridata-server.jar_veridataserver Login Successful

Log in using your browser veridata
http://192.168.56.60:8830/veridata/

Enter user name and password to log in

Click on the right connection Configuration
New

When the new is complete, click Group Configuration on the right
New

When the new is complete, click Edit and click on the right go to Compare Pair Configuration.
Select tables for comparison by actual situation

When you are done, click Job Configuration
New

Run Job

View the report to know the specific error

Steps to start Veridata later:

Start Agent:[[email protected] agent]#./agent.sh start[[email protected] agent]#./agent.sh Start Start Server:[[email Protected] bin]# Pwd/opt/oracle_goldengate_veridata/web/bin[[email protected] bin]#./startup.sh catalina_home:/opt/ Oracle_goldengate_veridata/webjre_home:/opt/oracle_goldengate_veridata/jrejava_opts:-xms1024m-xmx1024m- Djava.awt.headless=true-dveridata.home=/opt/oracle_goldengate_veridata-dveridata.log.dir=/opt/oracle_ Goldengate_veridata/shared/logs-dveridata.log.file=veridataweb.logusing catalina_base:   /opt/Oracle_ Goldengate_veridata/webusing catalina_home:   /opt/oracle_goldengate_veridata/webusing CATALINA_TMPDIR:/opt/ Oracle_goldengate_veridata/web/tempusing jre_home:       /opt/oracle_goldengate_veridata/jre

Install Goldengate Veridata