Oracle+GoldenGate+Veridata+12.2.1.4安裝配置使用全手冊

1、目錄1. OGG Veridata Server體系結(jié)構21.1 OGG Veridata Server架構圖21.2 OGG Veridata Server安裝路徑圖21.3 OGG Veridata Server目錄結(jié)構41.4 OGG Veridata支持數(shù)據(jù)庫41.4.1 支持比較的數(shù)據(jù)庫41.4.2 支持與不支持repair的數(shù)據(jù)庫52. OGG Veridata Server安裝前準備52.1 版本說明52.2 驗證安裝環(huán)境要求52.2.1 驗證你的使用環(huán)境是否受支持62.2.2 驗證安裝環(huán)境是否滿足要求62.2.3 驗證多產(chǎn)品多版本之間協(xié)作性62.3 Oracle Fusion

2、Middleware操作系統(tǒng)配置要求62.3.1 umask62.3.2 不能使用root安裝62.3.3 管理軟件安裝用戶要求72.3.4 Windows操作系統(tǒng)要求72.3.5 JDK安裝版本要求72.3.6 ORACLE_HOME目錄要求72.4 Oracle Fusion Middleware資料檔案庫數(shù)據(jù)庫要求72.4.1 服務器端組件資料檔案庫數(shù)據(jù)庫需求72.4.2 資料檔案庫支持數(shù)據(jù)庫類型82.4.3 OGG Veridata Server資料檔案庫需要的數(shù)據(jù)庫權限82.4.4 Oracle GoldenGate Veridata Server需要的環(huán)境變量配置相關82.5 Or

3、acle GoldenGate Veridata網(wǎng)頁端安裝要求82.5.1 安裝程序92.5.2 JAVA環(huán)境要求92.5.3 瀏覽器版本要求92.5.4 屏幕分辨率92.5.5 端口92.6 OGG Veridata Agent System Requirements92.6.1 Java Agent與C-agent92.6.2 Java-agent支持數(shù)據(jù)庫102.6.3 C-Agent支持與說明102.6.4 Agent組件磁盤以及內(nèi)存要求102.6.5 Agent組件需要的數(shù)據(jù)庫權限103. 安裝配置113.1 檢查系統(tǒng)版本113.2 安裝Fusion Middleware Infra

4、structure123.3 OGG Veridata Server安裝173.4 opatch打補丁223.4.1 查看補丁信息223.4.2 升級opatch工具223.4.3 應用補丁223.5 使用RCU工具創(chuàng)建資料檔案庫243.5.1 創(chuàng)建數(shù)據(jù)庫用戶243.5.2 啟動RCU243.5.3 DBA權限用戶說明243.5.4 具有DBA權限253.5.5 沒有DBA權限283.6 創(chuàng)建Weblogic Domain343.6.1 運行配置向?qū)onfig.sh343.6.2 按照向?qū)?zhí)行下面步驟343.7 啟動Administration Server433.7.1 前臺啟動433.7

5、.2 后臺啟動433.7.3 Administration訪問地址433.7.4 停止weblogic443.8 啟動Veridata Server443.8.1 前臺啟動443.8.2 后臺啟動443.8.3 OGG Veridata Server訪問地址443.8.4 停止OGG Veridata Server444. Agent安裝部署454.1 異機安裝454.1.1 Oracle Fushion Middleware Infrastructure安裝454.1.2 agent安裝454.1.3 補丁安裝504.2 agent配置504.2.1 agent_config.sh504.2

6、.2 perties配置文件514.2.3 拷貝drivers驅(qū)動到drivers目錄514.2.4 啟動/停止OGG Veridata Agent515. OGG Veridata使用515.1 添加agent受管機器515.2 比對535.3 group配置541. OGG Veridata Server體系結(jié)構1.1 OGG Veridata Server架構圖1.2 OGG Veridata Server安裝路徑圖Table 1-2 Oracle GoldenGate Veridata Installation RoadmapTaskDescriptionDocume

7、ntationVerify your system environment and install the prerequisitesBefore beginning the installation, verify that the minimum system and network requirements are met.SeeOracle GoldenGate Veridata Prerequisites and System Requirements.Obtain the appropriate distribution for your installation typeThe

8、Oracle GoldenGate Veridata distribution. For Oracle GoldenGate Veridata .0, the installer isfmw_.0_ogg.jar.SeeOracle GoldenGate Veridata Distribution.Determine your installation directoriesVerify that the directories that will need to be created can be created or accessed by the inst

9、aller, and exist on systems that meet the minimum requirements.SeeUnderstanding the Recommended Directory StructureinPlanning an Installation of Oracle Fusion Middleware.Install Oracle GoldenGate VeridataInstalling software transfers the software to your system and creates the Oracle home directory.

10、For more information about the install types available during installation, seeUnderstanding Oracle GoldenGate Veridata Distribution.For installation instructions, seeInstalling Oracle GoldenGate Veridata.Create Oracle GoldenGate Veridata Repository schema.Use the Repository Creation Utility (RCU) t

11、o create the Repository database schemas.SeeCreating the Oracle GoldenGate Veridata Repository Schema.Create and configure your domainUse the configuration wizard to create and configure your domain.SeeConfiguring Domain for Oracle GoldenGate Veridatato create the domain.Apply patch using OPatchUse

12、OPatch to apply latest bundle patch, and execute repository patch if applicable.SeeNext Steps After Configuring an Oracle GoldenGate Veridata Domain.1.3 OGG Veridata Server目錄結(jié)構Table 6-1 Directories in an Oracle GoldenGate Veridata InstallationDirectory VariableDirectory PathORACLE_HOME/install_locat

13、ion/Oracle_Home. This is the home directory for the Oracle Fusion Middleware products.VERIDATA_PRODUCT_HOME/ORACLE_HOME/veridataAGENT_ORACLE_HOME/VERIDATA_PRODUCT_HOME/agentAGENT_DEPLOY_LOCATIONThis is the location where the Oracle GoldenGate Veridata Agent is deployed.Note that this location should

14、 be outside theORACLE_HOME.1.4 OGG Veridata支持數(shù)據(jù)庫1.4.1 支持比較的數(shù)據(jù)庫l Oracle, ADW, ATP, DBCSl SQL Serverl MySQLl Teradatal BigData Hivel DB2 for i, DB2 LUW, and DB2 z/OSl Informixl Non Stop (Enscribe, SQL/MP, SQL/MX)l Sybase Adaptive Server Enterprise (ASE)1.4.2 支持與不支持repair的數(shù)據(jù)庫l Oracle GoldenGate Veridat

15、a supports the following databases for repair functionality: Oracle, ADW, ATP, DBCS SQL Server Teradata DB2 for i, DB2 LUW, and DB2 z/OS Informix Sybase Adaptive Server Enterprise (ASE) MySQLl Oracle GoldenGate Veridata doesnt support the following databases for repair functionality, but supported b

16、y Oracle GoldenGate: Non Stop (Enscribe, SQL/MP, SQL/MX)BigData Hive2. OGG Veridata Server安裝前準備2.1 版本說明l 最新版本Oracle GoldenGate Veridata (.0) 9月版本（20201029）l .0為基礎版本。l .0各個更新新特性：（1）9月版本： This is a compatibility release for bug fix only, no new feature was added.（2）7月版本： Suppor

17、t has been added for MySQL Repair Functionality Oracle GoldenGate Veridata now supports users to repair out-of-sync data in MySQL database.（3）1月版本： Oracle GoldenGate Veridata .200115 release includes the following new and changed features : Added MySQL support for comparison as source or tar

18、get database. However, there is no support added for repair. Oracle GoldenGate Veridata now fully supports Oracle Multitenant Container database. Added support to EXCLUDE VIEWS when creating compare pair. Added support to filter objects using NOT LIKE when creating compare pair.2.2 驗證安裝環(huán)境要求l OGG Ver

19、idata Server不需要一定在服務端安裝OGG軟件，如果安裝在有OGG軟件的服務器上，則需要安裝在不同目錄。2.2.1 驗證你的使用環(huán)境是否受支持Oracle Fusion Middleware Supported System Configurations地址：2.2.2 驗證安裝環(huán)境是否滿足要求Oracle Fusion Middleware System Requirements and Specifications地址：2.2.3 驗證多產(chǎn)品多版本之間協(xié)作性l 如果為全新安裝，不存在Oracle Fushion Middleware Infrastructure與Veridata

20、 Server軟件不同版本，則可以不進行驗證，安裝統(tǒng)一版本即可。Oracle Fusion Middleware Understanding Interoperability and Compatibility地址：2.3 Oracle Fusion Middleware操作系統(tǒng)配置要求本章節(jié)主要描述Oracle Fushion Middleware Infrastructure安裝，安裝OGG Veridata Server需要先在操作系統(tǒng)安裝Oracle Fushion Middleware Infrastructure，然后才可以將OGG Veridata Server安裝在Oracle

21、 Fushion Middleware Infrastructure相同Oracle_Home。2.3.1 umaskl UNIX操作系統(tǒng)，Oracle建議umask設置為027。l 需要與安裝程序同一終端運行上述命令。$ umask 0272.3.2 不能使用root安裝UNIX操作系統(tǒng)，不能使用root安裝程序。2.3.3 管理軟件安裝用戶要求當管理軟件時，例如打補丁，需要使用與安裝相同用戶。2.3.4 Windows操作系統(tǒng)要求Windows，執(zhí)行安裝，需要具有Administrator權限。2.3.5 JDK安裝版本要求下面鏈接查看需要安裝的版本jdk：ORACLE建議jdk目錄安裝在

22、：/home/oracle/products/jdkFor 12c (.0), the certified JDK is 1.8.0_221 and laterJDK下載：2.3.6 ORACLE_HOME目錄要求完成操作系統(tǒng)JDK安裝之后，使用Oracle Fusion Middleware .0 Infrastructure installer安裝Oracle WebLogic Server .0以及Oracle Java Required Files (JRF) Infrastructure servicesOracle home需要考慮如

23、下：a) 路徑不能包含空格。b) 在每個Oracle home目錄只能安裝一個Oracle Fusion Middleware product實例。c) 如果要在一臺機器維護多版本，不同版本需要具有不同Oracle home目錄。2.4 Oracle Fusion Middleware資料檔案庫數(shù)據(jù)庫要求2.4.1 服務器端組件資料檔案庫數(shù)據(jù)庫需求l 可以參考下面文檔，查看更詳細相關信息：l Oracle GoldenGate Veridata服務端需要一個數(shù)據(jù)庫作為資料檔案庫，用來存儲使用Oracle GoldenGate Veridata網(wǎng)頁端時創(chuàng)建的對象的信息以及環(huán)境首選項配置等。l U

24、se the Repository Creation Utility (RCU) to create the repository. See Creating the Oracle GoldenGate Veridata Repository Schema.2.4.2 資料檔案庫支持數(shù)據(jù)庫類型l Oraclel SQL Server2.4.3 OGG Veridata Server資料檔案庫需要的數(shù)據(jù)庫權限l Oraclea) Create a user and password.b) Specify QUOTA UNLIMITED on the users default tablespac

25、e.l SQL Servera) Create a database and login that is a user of the database where you will be installing the repository.b) Grant this login sufficient privileges to perform the following operations:c) CONNECT to the databased) CREATE, ALTER, DROP TABLE in the databasee) CREATE and DROP INDEX in the

26、databasef) INSERT, UPDATE, DELETE from tables in the databaseh) SELECT from tables in the databasei) ALTER SCHEMA of the logins default schema2.4.4 Oracle GoldenGate Veridata Server需要的環(huán)境變量配置相關l Oraclea) The database instance nameb) The ORACLE_HOME (if using TNSNAMES connection method)c) Default and

27、temporary tablespaces for the repository (if you will be creating a new user for the server component during installation)d) A login and password, if using an existing database user for the repository.l SQL Servera) The SQL Server instance must be configured to use a static port number. b) This port

28、 is stored in a configuration file so that it can be referenced to make JDBC connections to the database.c) A login and password (or integrated authentication), if using an existing database user for the repository.2.5 Oracle GoldenGate Veridata網(wǎng)頁端安裝要求這個章節(jié)主要描述OGG Veridata Server端安裝，安裝OGG Veridata Se

29、rver，需要先安裝ADR（Application Development Runtime）環(huán)境Oracle Fushion Middleware Infrastructure。2.5.1 安裝程序One installer program installs both Oracle GoldenGate Veridata Web Server component and Oracle GoldenGate Veridata Web User Interface.2.5.2 JAVA環(huán)境要求JDK 1.8.0_221 or higher is required for the Veridata

30、Web User Interface installation.2.5.3 瀏覽器版本要求l Microsoft Internet Explorer version 11 or higherl Mozilla Firefox version 38 or higherl Google Chrome version 432.5.4 屏幕分辨率Minimum of 1024 x 7682.5.5 端口l The Oracle GoldenGate Veridata Web application interacts with Oracle WebLogic Server. l Oracle WebL

31、ogic Server is installed with Oracle GoldenGate Veridata Server on default ports. You can change the port numbers if needed.l Oracle GoldenGate Veridata Web makes use of the default port 8830.2.6 OGG Veridata Agent System Requirements2.6.1 Java Agent與C-agentl Java agent除了NonStop平臺都可以使用，NonStop platf

32、orm只能使用C-agentl Java agent使用UTF-8字符集比較字符數(shù)據(jù)。Out-of-sync數(shù)據(jù)使用UTF-8字符集寫入報告文件。l OGG Veridata Oracle C-Agent可以用于比較源端與目標端相同字符集以及相同字節(jié)序的平臺。l C-Agent不能與Java-agent進行比較，比較報告中非有效utf-8字符將以16進制顯示。l 一個agent不能檢索不同數(shù)據(jù)庫實例數(shù)據(jù)行。l Java agent使用JDBC連接數(shù)據(jù)庫，可以安裝在數(shù)據(jù)庫所在服務器或者不同服務器，但是安裝在不同數(shù)據(jù)庫要考慮不在數(shù)據(jù)庫服務器帶來的網(wǎng)絡帶寬消耗以及處理資源消耗。注：Java agen

33、t可以不安裝在要比對的數(shù)據(jù)庫端，可以遠程連接，也可以安裝在OGG Veridata Server端，然后一次安裝啟動多個agent，連接不同數(shù)據(jù)庫。2.6.2 Java-agent支持數(shù)據(jù)庫Oracle GoldenGate Veridata provides a Java-based agent for the following databases:l DB2 for i, DB2 LUW, and DB2 z/OSl Oraclel SQL Serverl Sybase ASEl Teradatal Informixl BigData Hive2.6.3 C-Agent支持與說明l C-

34、agent對于NonStop SQL/MP以及Enscribe數(shù)據(jù)庫是必須的，可以安裝在守護環(huán)境。l C-agent支持Oracle database，但是從.0版本開始，不再被加強。l C-agent必須安裝在數(shù)據(jù)庫所在服務器。l 對于Oracle，C-agent動態(tài)函式庫要可用，在不同平臺需要設置如下環(huán)境變量：Variable Operating SystemPATH=Oracle_libraries WindowsSHLIB_PATH=Oracle_libraries HP-UXLIBPATH=Oracle_libraries IBM AIXLD_LIBRARY_PATH

35、=Oracle_libraries All other supported UNIX platforms2.6.4 Agent組件磁盤以及內(nèi)存要求l agent需要至少1GB內(nèi)存l agent對于磁盤需求根據(jù)不同平臺需要不同，大約200M。2.6.5 Agent組件需要的數(shù)據(jù)庫權限 Agent組件需要的權限并不需要預先配置，只需要在訪問OGG Veridata Server網(wǎng)頁端時，配置連接串，連接數(shù)據(jù)庫用戶時，該用戶需要具有相應權限，才能正常比對與repair修復數(shù)據(jù)。l Required database privileges for Oracle GoldenGate Veridata

36、Agent DB2SELECT privileges on the tables that will be compared. OracleGRANT CONNECTGRANT SELECT on the tables to be compared. It is recommended, but not necessary, to GRANT SELECT ANY TABLE.SELECT_CATALOG_ROLE NonStop SQL/MP and EnscribeRead access to the SQL/MP system catalog (for queries to CATALO

37、GS table).Read access to the SQL/MP catalogs that you want Oracle GoldenGate Veridata to use.Read access to the DDL dictionaries that you want Oracle GoldenGate Veridata to use.Read access to the Enscribe and SQL/MP tables that will be compared.Read, write, create, purge permissions for the Oracle G

38、oldenGate Veridata report and trace files, and access to the sub volumes where they are installed. SQL Serverdb_datareader or the equivalent on the tables to be compared.VIEW DEFINITION in the databases to be compared.The database must allow SQL Server authentication. Sybase ASEAccess to the databas

39、es to be compared.SELECT privileges on the tables to be compared.SELECT privileges on the sysdatabases system table in the master database to view the list of databases available in the server. TeradataSELECT privileges on the tables to be compared. InformixSELECT privileges on the tables to be comp

40、ared. BigData HiveSELECT privileges on the tables to be compared.l Required Database Privileges for Using the Repair Feature For all databases, the database user must have the UPDATE, INSERT, and DELETE privileges on the tables to be repaired. For Sybase database, if the table has triggers and suppr

41、ession of triggers enabled, the database user must have the replication_role privilege. For SQL Server database, If the table being repaired has identity columns, the Repair User specified must be either the table owner, or should have ALTER permission on the table that is being repaired.3. 安裝配置3.1

42、檢查系統(tǒng)版本# uname -a# java -version# java 不符合下載jdk，安裝。# rpm -ivh jdk-8u261-linux-x64.rpm# su - oracle$ vi .bash_profileexport JAVA_HOME=/usr/java/jdk1.8.0_261-amd64export PATH=$PATH:/usr/java/jdk1.8.0_261-amd64/bin# 創(chuàng)建Oracle_Home，如果不創(chuàng)建默認安裝/home/oracle/Oracle/Middleware/Oracle_Home# mkdir -p /u01/app/Ora

43、cle/Middleware/Oracle_Home# chown -R oracle:oinstall /u01/app/Oracle3.2 安裝Fusion Middleware InfrastructureApplication Development Runtime找到對應版本選項下載，F(xiàn)usion Middleware Infrastructure Installer。$ /usr/java/jdk-15/bin/java -jar fmw_.0_infrastructure.jarjava版本安裝為jdk 2613.3 OGG Veridata Server安裝$

44、export DISPLAY=00:0.0$ /usr/java/jdk-15/bin/java -jar fmw_.0_ogg.jar# 選擇Oracle Home時需要選則Fushion Middleware Infrastructure安裝時的Oracle Home。Oracle Home要選擇，上一步Oracle Fushion Middleware Infrastructure安裝的Oracle Home目錄。3.4 opatch打補丁3.4.1 查看補丁信息$ /home/oracle/Oracle/Middleware/Oracle_Ho

45、me/OPatch/opatch lsinventory -jre $ORACLE_HOME/oracle_common/jdk/jre3.4.2 升級opatch工具參考README，如果必要升級opatch3.4.3 應用補丁$ echo $ORACLE_HOME/home/oracle/Oracle/Middleware/Oracle_Home$ cd oggveridata/31044508/$ /home/oracle/Oracle/Middleware/Oracle_Home/OPatch/opatch applyOracle Interim Patch Installer ver

46、sion .1Copyright (c) 2020, Oracle Corporation. All rights reserved.Oracle Home : /home/oracle/Oracle/Middleware/Oracle_HomeCentral Inventory : /oracle/app/oraInventory from : /home/oracle/Oracle/Middleware/Oracle_Home/oraInst.locOPatch version : .1OUI version : .0Log file loc

47、ation : /home/oracle/Oracle/Middleware/Oracle_Home/cfgtoollogs/opatch/opatch2020-10-20_23-44-36PM_1.logOPatch detects the Middleware Home as /home/oracle/Oracle/Middleware/Oracle_HomeVerifying environment and performing prerequisite checks.OPatch continues with these patches: 31044508 Do you want to

48、 proceed? y|nyUser Responded with: YAll checks passed.Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.(Oracle Home = /home/oracle/Oracle/Middleware/Oracle_Home)Is the local system ready for patching? y|nyUser Responded with: YBacking up files.Applying interim pat

49、ch 31044508 to OH /home/oracle/Oracle/Middleware/Oracle_HomePatching component oracle.rcu.veridata, .0.Patching component oracle.veridata.agent.core, .0.Patching component oracle.veridata.agent.core, .0.Patching component oracle.veridata.web.core, .0.Patching componen

50、t oracle.veridata.web.core, .0.Patching component oracle.fmw.upgrade.veridata, .0.Patch 31044508 successfully applied.Log file location: /home/oracle/Oracle/Middleware/Oracle_Home/cfgtoollogs/opatch/opatch2020-10-20_23-44-36PM_1.logOPatch succeeded.3.5 使用RCU工具創(chuàng)建資料檔案庫3.5.1 創(chuàng)建數(shù)據(jù)庫用戶SYSm

51、essay create user oggveridata identified by oggveridata;SYSmessay grant unlimited tablespace to oggveridata;3.5.2 啟動RCU進入$ORACLE_HOME/oracle_common/bin啟動RCU.l Set the JAVA_HOME environment variable to your JDK location.l On UNIX operating systems:setenv JAVA_HOME=/home/Oracle/Java/jdkversionl On Win

52、dows operating systems, 右鍵計算機-屬性-高級計算機設置配置環(huán)境變量l 進入ORACLE_HOME/oracle_common/bin目錄Repository Creation Utility RCU.a) On UNIX operating systems:$ export DISPLAY=00:0.0$ ./rcu3.5.3 DBA權限用戶說明l 如果運行RCU時，擁有的數(shù)據(jù)庫用戶沒有DBA權限，則需要在選擇功能時，只選擇Perform Product Load，最后完成界面找到腳本目錄，交由DBA權限用戶執(zhí)行下面腳本，創(chuàng)建相應表空間，完成

53、system load：SYSmessay script_systemLoad.sql# 根據(jù)上面腳本提示，需要為每個schema設置密碼，記住密碼，下一步再次運行rcu還需要使用。l 如果具有DBA權限，則選擇，systemload and product load。Unix：$ export DISPLAY=00:0.0$ ./rcu# 選擇On Windows operating systems:rcu.bat3.5.4 具有DBA權限3.5.5 沒有DBA權限RCU創(chuàng)建Repository如果安裝沒有DBA權限，則需要選擇第二個，生成SQL腳本，由具有DBA權限的用戶執(zhí)行，這里選擇第二個，需要手工使用DBA用戶執(zhí)行system_load腳本之后再次運行RCU。 進入上面Script Location目錄，執(zhí)行script_systemLoad.sql腳本再次運行RCU密碼：Oracle1233.6 創(chuàng)建Weblogic Domain OGG Veridata Server通過Weblogic域進行管理，所以在可以訪問OGG Veridata Serve