在系列一里看了GoldenGate的架構(gòu)，現(xiàn)在看一下安裝GG的系統(tǒng)需求。

Oracle Golden Gate 系列一 -- GG 架構(gòu) 說(shuō)明：http://www./database/201111/111280.html

一. Memory requirements

The amount ofmemory that is required for Oracle GoldenGate depends on the number of concurrentprocesses that will be running. At minimum on thesource system, there is a primary Extract process that captures sourcedata and a secondary Extract data-pump process that transfers data across thenetwork. At minimum on the target system is at leastone Replicat process that applies the replicated data to the target database.In some cases, these processes might all operate on the same system, dependingon the required configuration.

--并發(fā)進(jìn)程的數(shù)據(jù)量決定GG內(nèi)存的大小，在source system端，最少需要一個(gè)Extract 進(jìn)程和一個(gè)data-pump進(jìn)程，在target system 端， 至少需要一個(gè)replicat 進(jìn)程。

（1）The OracleGoldenGate GGSCI command interface fully supports up to 300 concurrent Extractand Replicat processes per instance of Oracle GoldenGate. An instance of OracleGoldenGate equates to one Manager process, which is the main controller process.

-- 在每個(gè)GG instance 上，GGSCI 命令結(jié)構(gòu)最多支持300個(gè)Extract和 replicat 并發(fā)進(jìn)程，每個(gè)GG instance 需要一個(gè)Manager 進(jìn)程。

（2）Each Extractand Replicat process needs approximately 25-55 MB of memory, or more dependingon the size of the transactions and the number of concurrent transactions.

--每個(gè)Extract 和 Replicat 進(jìn)程大概需要25-55M的內(nèi)存，根據(jù)的要根據(jù)事務(wù)的數(shù)量和事務(wù)的并發(fā)量決定。

The actual amount of physical memory that is used by any Oracle GoldenGate process is controlledby the operating system, not the Oracle GoldenGate program. The Oracle GoldenGatecache manager takes advantage of the memory management functions of the operatingsystem to ensure that Oracle GoldenGate processes work in a sustained and efficientmanner.

       --GG 實(shí)際使用的物理內(nèi)存量是由操作系統(tǒng)控制的，GG的cache manager 利用操作系統(tǒng)的memory managementfunctions 來(lái)保證GG 以持續(xù)和有效的方式來(lái)運(yùn)行。

Within its cache, it makes use of modernvirtual memory techniques by:

--GG 的cachemanager 利用virtual memory 技術(shù)：

（1）Allocatingand managing active buffers efficiently.

（2）Recycling oldbuffers instead of paging to disk, when possible.

（3）Pagingless-used information to disk, when necessary.

The cachemanager keeps an Oracle GoldenGate process working within the soft limit of itsglobal cache size, only allocating virtual memory (not physical memory) on demand.System calls to increase the cache size are made only as a last resort and,when used, are always followed by the release of virtual memory back to thesystem.

       --Cache manager 保持GG 進(jìn)程在global cache 的大小內(nèi)工作，在需要時(shí)僅分配virtualmemory，操作完會(huì)，會(huì)釋放virtual memory。 只有在不得已的情況下，才會(huì)增加cache size。

The system musthave sufficient swap space for each Oracle GoldenGate Extract and Replicat processthat will be running.

--系統(tǒng)必須要有足夠的swap space 來(lái)支撐GG Extract 和Replicat 進(jìn)程的運(yùn)行。

To determine the required swap space:

--通過(guò)一下的方法來(lái)確定需要swap space 的大?。?/SPAN>

（1） Start up oneExtract or Replicat.

（2） Run GGSCI.

（3） View thereport file and find the line PROCESS VM AVAIL FROM OS (min).

（4） Round up thevalue to the next full gigabyte if needed. For example, round up 1.76GB to 2GB.

（5） Multiplythat value by the number of Extract and Replicat processes that will be running.The result is the maximum amount of swap space that could be required. To determinethe number of processes you will need, consult the configuration chapters in theOracle GoldenGate Windows and UNIX Administrator’s Guide.

二.Disk requirements

Assign the following free disk space:

（1） 50-150 MB,depending on the database and platform. This includes space for the compresseddownload file and space for the uncompressed files. You can delete the downloadfile after the installation is complete.

--GG 軟件需要的空間大小

（2）40 MB for theworking directories and binaries for each instance of Oracle GoldenGate thatyou are installing on the system. For example, to install two builds of Oracle GoldenGateinto two separate directories, allocate 80 MB of space.

--每個(gè)GG instance 的working directories 和binaries 是40M。

（3）To installOracle GoldenGate into a cluster environment, install the Oracle GoldenGatebinaries and files on a shared file system that is available to all cluster nodes.

--如果是集群環(huán)境上部署GG，GG binaries 和 files 需要放在共享文件系統(tǒng)上。

（4）An additional1 GB of disk space on any system that hosts Oracle GoldenGate trails, which arefiles that contain the working data. You may need more or less than this amount,because the space that is consumed by the trails depends on the volume of datathat will be processed. Start with 1 GB and adjust as needed. See also the followingguidelines.

--至少1G的空間來(lái)存放trails 文件

三.Storagefor Oracle GoldenGate trails

To prevent trailactivity from interfering with business applications, assign a separate disk orfile system to contain the trail files. These files are created duringprocessing to store all of the data that is captured by Oracle GoldenGate. The default size is 10 megabytes, but can be changed duringthe configuration process. Trail files accumulate but can be purged accordingto rules set with the PURGEOLDEXTRACTS parameter.

--為了避免trail 被其他的應(yīng)用干擾，最好分配獨(dú)立的disk 或者 filesystem 來(lái)存放trail 文件。 Trail file 里保存的是GG capture 的data。 Trail file 默認(rèn)大小是10M，該大小可以進(jìn)行配置，trail files 是類型型的，其保留策略可以通過(guò)PURGEOLDEXTRACTS 參數(shù)控制。

Trail files canreside on drives that are local to the Oracle GoldenGate installation, or they canreside on NAS or SAN devices. You will specify the location of the trails whenyou configure Oracle GoldenGate.

--trail files 可以保留在本地磁盤或者NAS/SAN 設(shè)備上，具體在安裝GG時(shí)可以配置。

For trails that are stored at the source location, there should be enough space to handle data accumulation should thenetwork connection fail. In a typical configuration, a secondary Extractprocess (known as a data pump) sends data from a local trail over the network,and it will fail when the network does.

However, theprimary Extract that reads the transaction logs and writes to the local trailwill continue to do so. This Extract should not be stopped during a failure;otherwise, transaction data might be missed if the transaction logs recycle orget removed from the system before the data is completely captured. There mustbe enough disk space to hold the data accumulation.

--在一個(gè)典型的GG 配置，source 會(huì)有Extract 和data-pump進(jìn)程，如果trails 存儲(chǔ)在source 本地，當(dāng)網(wǎng)絡(luò)出現(xiàn)故障，data-pump 進(jìn)程會(huì)失敗，但extract 進(jìn)程還會(huì)繼續(xù)工作，這樣trails 文件會(huì)越來(lái)越大， 必須要有足夠的空間來(lái)存放trails。

For trails atthe target location, provide enough disk space to handle data accumulation accordingto the purge rules set with the PURGEOLDEXTRACTS parameter. Even with PURGEOLDEXTRACTSin use, data will always accumulate on the target because it is transferredacross the network faster than it can be applied to the target database.

       --如果trails 放在target 端，那么需要根據(jù)PURGEOLDEXTRACTS參數(shù)來(lái)決定所需要的磁盤空間。

To estimate requiredtrail space:

--估算trailspace 方法：

1. Estimate thelongest time that the network could be unavailable. Plan to store enough datato withstand the longest possible outage, because otherwise you will need to resynchronizethe source and target data if the outage outlasts disk capacity.

--估算網(wǎng)絡(luò)不可用的最長(zhǎng)時(shí)間

2. Estimate howmuch transaction log volume your business applications generate in one hour.

--估算每個(gè)小時(shí)生成的事務(wù)log量。

3. Use thefollowing formula to calculate the required disk space.

trail disk space=[logvolume in one hour] x [number of hours downtime] x 0.4

This equationuses a multiplier of 40 percent because only about 40 percent of the data in atransaction log is needed by Oracle GoldenGate.

--注意這里乘以了40%，因?yàn)镚G 只需要大概40%的事務(wù)log。

NOTE：

This formula isa conservative estimate, and you should run tests once you have configuredOracle GoldenGate to determine exactly how much space you need.

--以上方法僅是保守的估算，具體要根據(jù)實(shí)際情況決定。

四.Temporarydisk requirements

By default,Oracle GoldenGate maintains data that it swaps to disk in the dirtmp subdirectoryof the Oracle GoldenGate installation directory. The cache manager assumes thatall of the free space on the file system is available. You can assign adirectory by using the CACHEDIRECTORY option of the CACHEMGR parameter.

--默認(rèn)情況下，GG 的maintains data 會(huì)放在GG 安裝目錄的dirtmp子目錄下，可以使用CACHEMGR的CACHEDIRECTORY來(lái)進(jìn)行修改。

五.OracleRAC requirements

To installOracle GoldenGate in an Oracle Real Application Cluster (RAC) environment, installOracle GoldenGate on the shared drive(s) that are accessed by the RAC nodes.This allows you to start the Oracle GoldenGate processes from any of the nodes.If the node where the processes are running fails, you can start them onanother node without modifying parameter files, because the processingcheckpoints are preserved in the installation directory.

--對(duì)于RAC 集群，GG 需要安裝在共享設(shè)備里，這樣可以從任何一個(gè)節(jié)點(diǎn)啟動(dòng)，而且當(dāng)在一個(gè)節(jié)點(diǎn)上運(yùn)行失敗時(shí)，可以從其他的節(jié)點(diǎn)啟動(dòng)，并不需要修改配置。

六. Network

1. Configure the system to use TCP/IPservices, including DNS.

2. Configure the network with the hostnames or IP addresses of all systems that will be hosting Oracle GoldenGateprocesses and to which Oracle GoldenGate will be connecting. Host names areeasier to use.

3. Oracle GoldenGate requires the followingunreserved and unrestricted TCP/IP ports:

（1） One port forcommunication between the Manager process and other Oracle GoldenGateprocesses.

（2）A range ofports for local Oracle GoldenGate communications: can be the default rangestarting at port 7840 or a customized range of up to 256 other ports.

--GG 的端口，默認(rèn)從7840開(kāi)始

4. Keep a record of the ports that youassigned to Oracle GoldenGate. You will specify them with parameters whenconfiguring the Manager process.

5. Configure your firewalls to acceptconnections through the Oracle GoldenGate ports.

七. Operating system privileges

1. To install onWindows, the person who installs Oracle GoldenGate must log in as Administrator.

2. To install onUNIX, the person who installs Oracle GoldenGate must have read and writeprivileges on the Oracle GoldenGate installation directory.

3. The OracleGoldenGate Extract, Replicat, and Manager processes must operate as an operatingsystem user that has privileges to read, write, and delete files and subdirectoriesin the Oracle GoldenGate directory. In addition, the Manager process requiresprivileges to control the other Oracle GoldenGate processes.

4. The Extractprocess must operate as an operating system user that has read access to thetransaction log files, both online and archived. On UNIX systems, that usermust be a member of the group that owns the Oracle instance. If you install theManager process as a Windows service during the installation steps in thisdocumentation, you must install as Administrator for the correct permissions tobe assigned. If you cannot install Manager as a service, assign read access tothe Extract process manually, and then always run Manager and Extract asAdministrator.

5. Dedicate theExtract, Replicat, and Manager operating system users to Oracle GoldenGate.Sensitive information might be available to anyone who runs an Oracle GoldenGateprocess, depending on how database authentication is configured.

八．Itanium requirements

To installOracle GoldenGate on a Microsoft Itanium system, the vcredist_IA64.exe runtime librarypackage must be installed. You can download this package from the Microsoft website.This package includes VisualStudio DLLs necessary for Oracle GoldenGate to operateon the Itanium platform. If these libraries are not installed, OracleGoldenGate generates the following error.

“The application failed to initializeproperly (0xc0150002). Click on Ok to terminate the application.

--在安騰的windows的系統(tǒng)上運(yùn)行GG，必須要先安裝vcredist_IA64.exe包。如果沒(méi)有安裝，會(huì)報(bào)錯(cuò)。 不過(guò)Oracle 12c 已經(jīng)不在支持Itanium CPU，所以這塊了解一下就ok了。

九．Other programs

1. Beforeinstalling Oracle GoldenGate on a Windows system, install and configure the MicrosoftVisual C ++ 2005 SP1 Redistributable Package. Make certain it is the SP1 versionof this package, and make certain to get the correct bit version for yourserver. This package installs runtime components of Visual C++ Libraries. For moreinformation, and to download this package, go to http://www.microsoft.com/.

--在Windows 上安裝GG，需要先安裝MicrosoftVisual C ++ 2005 SP1包。

2. Oracle GoldenGate fully supports virtual machine environmentscreated with any virtualization software on any platform. When installingOracle GoldenGate into a virtual machine environment, select a build thatmatches the database and the operating system of the virtual machine, not thehost system. For example, on a Windows system with a RHAS 4.0 virtual machinerunning Oracle11g, you would install the RHAS 4.0 build for Oracle 11g, just asyou would on an actual Linux machine.

--GG 支持虛擬機(jī)環(huán)境。

十. Database configuration

1. To run OracleGoldenGate for multiple Oracle instances on a Windows system, you must installan instance of Oracle GoldenGate for each one

2. On 64-bit SunSolaris, HP Tru64 (OSF/1), and LINUX machines with 32-bit Oracle databases,Oracle GoldenGate requires LD_LIBRARY_PATH to include the 32-bit Oracle libraries.You will be instructed to set LD_LIBRARY_PATH in the installation instructions inthis manual.

--在Linux 32bit等系統(tǒng)上運(yùn)行GG，需要指定LD_LIBRARY_PATH，其要包含32bit的oraclelibraries。

3. If thedatabase is Oracle 10g or later and configured to use a Bequeath connection,the sqlnet.ora file must contain the bequeath_detach=true setting.

--如果是Oracle 10g以后的版本，必須要在sqlnet.ora 中設(shè)置bequeath_detach=true，以使用Bequeath connection

4. To supportthe default RMAN log retention feature on Oracle RAC, you must download andinstall the database patch that is provided in BUGFIX 11879974 before you add theExtract groups.

5. Additionaldatabase configuration requirements are explained elsewhere in this manual.

十一. Database client

The full Oracle client must be used with Oracle GoldenGate so that the Oracle GoldenGate programshave access to the Oracle XDK libraries. Do not use Oracle Instant Client,which lacks those libraries. You can download the full client from the Oraclewebsite.

十二. Database user for Oracle GoldenGateprocesses

1. Create adatabase user that is dedicated to Oracle GoldenGate. It can be the same user forall of the Oracle GoldenGate processes that must connect to a database:

（1） Extract (source database)

（2） Replicat (target database)

（3） Manager (source database, if usingDDL support)

（4） DEFGEN (source or target database)

2 To preservethe security of your data, and to monitor Oracle GoldenGate processing accurately,do not permit other users, applications, or processes to log on as, or operate as,the Oracle GoldenGate database user.

  Keep a record of the database users. They must be specified in the Oracle GoldenGate parameterfiles with the USERID parameter. Use the USERID parameter for the database user,and use the TRANLOGOPTIONS parameter with the ASMUSER and ASMPASSWORD optionsfor the ASM user.

十三. Database privileges

Certainprivileges are required for a regular Oracle instance, plus additionalprivileges for an ASM instance and additional privileges for Oracle EnterpriseEdition 10.2 or later.

1.     Regular Oracle database instance

To assign the correct privileges to theOracle GoldenGate database user, see Table 1.

2.Oracle ASM instance

If Oracle 10g AutomaticStorage Management (ASM) is in use, Oracle GoldenGate requires a user for theExtract process to access the ASM instance. Oracle GoldenGate does not supportusing operating-system authentication for the ASM user. You can use SYS user orany user with SYSDBA privileges in the ASM instance. See Table 2.

--如果使用ASM，GG 需要能夠訪問(wèn)ASM instance。

3.  Oracle Enterprise Edition 10.2 or later instance

In OracleEnterprise Edition 10.2 or later, the additional privileges in Table 3 arerequired for the Extract database user. In these Enterprise Edition versions,Oracle Recovery Manager (RMAN) works with Extract to retain the archive logsthat Extract needs for recovery. The special privileges are required forinteraction with an underlying Oracle Streams Capture and with RMAN.