Install Goldengate upload data, goldengateveridata

Install Goldengate upload data, goldengateveridata

Goldengate internal data is a tool for oracle to compare data consistency. It supports Oracle, Terdata, SQL Server, and other databases. Start installation below:

Overall architecture:

Installation environment:
Here I will install the external data Server directly on agent1:

Agent1：name：zbdba1OS:redhat 6.3IP:192.168.56.60Agent2:name：zbdba2OS:redhat 6.3IP:192.168.56.61

Install the external data agent on agent1 and agent2:
Check whether the database is enabled and the listener is enabled before installation.
Decompress:
[Root @ zbdba1 database] # unzip V35569-01.zip
Go to the agent directory and configure the parameter file:

cp agent.properties.sample agent.properties[root@zbdba1 agent]# cat agent.propertiesserver.port=1261database.url=jdbc:oracle:thin:@localhost:1521:orcl11gserver.driversLocation = driversserver.jdbcDriver=ojdbc6.jardatabase.transaction.isolation=READ_COMMITTED

Configure JRE:

[root@zbdba1 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
[Root @ zbdba1 agent] #./agent. sh start
Monitoring log file:
[Root @ zbdba1 ~] # Tail-100f/database/agent/veridata-agent.log

[root@zbdba1 agent]# ps -ef |grep agentroot      2217  2198  0 22:11 pts/3    00:00:00 tail -100f /database/agent/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 agent2.

Install external data server on agent1:

[Root @ zbdba1 database] # unzip V35572-01.zip [root @ zbdba1 database] # export DISPLAY = 192.168.56.1: 0.0 [root @ zbdba1 database] #./goldengate_1_data_redhatas40_x64.sh one-step installation Based on the GUI

After the installation is complete, check whether the external data server process is started:

[root@zbdba1 database]# ps -ef |grep veridataroot      1770  1750  0 21:27 pts/2    00:00:00 tail -1000f veridataweb.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 logs:

[root@zbdba1 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 persistence 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 08 21:29:22 EDT 2015]; root of context hierarchyINFO (2015-03-08 21:29:22,367)  [XmlBeanDefinitionReader:loadBeanDefinitions, line 315] - Loading XML bean definitions from class path resource [context-dao.xml]INFO (2015-03-08 21:29:23,568)  [XmlBeanDefinitionReader:loadBeanDefinitions, line 315] - Loading XML bean definitions from class path resource [context-bu.xml]INFO (2015-03-08 21:29:23,915)  [VeridataConfig:<init>, line 99] - No override /veridata.cfg config fileINFO (2015-03-08 21:29:23,946)  [VeridataConfig:<init>, line 124] - veridata.cfg Location: /opt/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.springframework.beans.factory.support.DefaultListableBeanFactory@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 'VeridataServer'INFO (2015-03-08 21:29:28,118)  [SorterManager:<init>, line 73] - Total sort memory is 766mINFO (2015-03-08 21:29:28,119)  [SorterManager:<init>, line 84] - Maximum comparison memory is 100mINFO (2015-03-08 21:29:28,119)  [SorterManager:<init>, line 89] - The maximum number of concurrent writes is 4INFO (2015-03-08 21:29:28,120)  [SorterManager:<init>, line 92] - 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 40] - 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 96] - Oracle GoldenGate Veridata Server - Version 11.2.1.0  OGGVDT_11.2.1.0.0_PLATFORMS_121108.1625INFO (2015-03-08 21:29:28,907)  [VeridataSessionLogger:log, line 97] - EclipseLink, version: Eclipse Persistence Services - 2.1.2.v20101206-r8635INFO (2015-03-08 21:29:37,094)  [VeridataSessionLogger:log, line 97] - file:/opt/Oracle_GoldenGate_Veridata/web/webapps/veridata/WEB-INF/lib/veridata-server.jar_VeridataServer login successful

Use a browser to log on to external data
Http: // 192.168.56.60: 8830/invalid data/

Enter the user name and password to log on.

Click Connection Configuration on the right
New

Click group Configuration on the right.
New

After the creation is complete, click edit and click Go to Compare Pair Configuration on the right.
Select tables as needed for comparison

Click job Configuration
New

Run job

View the report to find out the specific error

To start external data later:

Start the agent: [root @ zbdba1 agent] #. /agent. sh start [root @ zbdba2 agent] #. /agent. sh start server: [root @ zbdba1 bin] # pwd/opt/Oracle_GoldenGate_Veridata/web/bin [root @ zbdba1 bin] #. /startup. sh CATALINA_HOME:/opt/oracle_goldengate_1_data/webJRE_HOME:/opt/oracle_goldengate_1_data/jreJAVA_OPTS:-Xms1024m-Xmx1024m-Djava. awt. headless = true-d1_data. home =/opt/oracle_goldengate_invalid data-d1_data. log. dir =/opt/oracle_goldengate_sharedata/shared/logs-d1_data. log. file = paidataweb. logUsing CATALINA_BASE:/opt/Oracle_GoldenGate_Veridata/webUsing CATALINA_HOME:/opt/logs/webUsing CATALINA_TMPDIR:/opt/logs/web/tempUsing JRE_HOME:/opt/logs/jre