【正文】 ATH=$ORACLE_HOME/lib:${LD_LIBRARY_PATH}export PATH=${ORACLE_HOME}/bin:${PATH}export LD_LIBRARY_PATH=/opt/oracle/app/oracle/:/bak/gg:${LD_LIBRARY_PATH}umask 022. 使用oracle用戶，修改/opt/oracle/app/oracle/。. 1) 使用grid用戶登錄是id命令可以看當前用戶2) 修改參數remote_login_passwordfilealter system set remote_login_passwordfile = shared scope=spfile。 crsctl stop crs f crsctl start crsshutdown r (不能用reboot)Crsctl stop. 設置環(huán)境變量ORACLE_HOME=e:\app\Administrator\product\\dbhome_1ORACLE_SID=fenxiDB2重啟服務器C:\Users\Administratorecho %ORACLE_HOME%C:\app\Administrator\product\\dbhome_1C:\Users\Administratorecho %ORACLE_SID%JSDB142. 安裝GG（只在小機1和分析2上建）1) 解壓GG軟件到f:\gg目錄（分析服務器2），\bak\gg目錄（小機1）2) 用cmd命令，進入f:\gg目錄中，敲“GGSCI”命令3) 敲“CREATE SUBDIRS”命令. 官方系統(tǒng)要求每個GoldenGate實例可以支持并發(fā)500個Extract和Replicat進程。工作目錄每個GoldenGate實例的工作目錄，大約需要40M的空間。這部分空間的消耗取決于Trail，依賴于將要處理的數據量。對于RAC環(huán)境GoldenGate的相關軟件和工作目錄都需要配置在共享盤中，從而保證對所有node都是可用的，從任何一個node都可以啟動GoldenGate的進程，當其中一個node出現(xiàn)異常是，可以在剩余的node啟動而無須修改任何配置參數。必須兩臺機子保持時鐘同步。Oracle GoldenGate parameters settings for RAC●On AIX and Solaris machines, use the Extract parameter THREADOPTIONS with theBINDCPU n option. This parameter handles threadsafety issues related to memorythat is updated by different processors.●Oracle GoldenGate queues data in memory before sending it to the target system. TheINQUEUESIZE and OUTQUEUESIZE options of the THREADOPTIONS parameter determine howmuch data to queue. If needed, you can increase the performance of Extract on OracleRAC by tuning these parameters.●Oracle GoldenGate detects orphaned transactions, which can occur when a node failsduring a transaction and Extract cannot capture the rollback. Although the databaseperforms the rollback on the failover node, the transaction would otherwise remain inthe Extract transaction list indefinitely and prevent further checkpointing for theExtract thread that was processing the transaction. By default, Oracle GoldenGatepurges these transactions from its list after they are confirmed as orphaned. To controlthis behavior, use the TRANLOGOPTIONS parameter with the PURGEORPHANEDTRANSACTIONS| NOPURGEORPHANEDTRANSACTIONS and TRANSCLEANUPFREQUENCY options. This functionalitycan be controlled on demand with the SEND EXTRACT mand in GGSCI.Special procedures on RAC●If the primary database instance against which Oracle GoldenGate is running stops orfails for any reason, Extract will abend. To resume processing, you can restart theinstance, or you can mount the Oracle GoldenGate binaries to another node where thedatabase is running and then restart the Oracle GoldenGate processes. Stop theManager process on the original node before starting Oracle GoldenGate processesfrom another node.●Any time the number of redo threads changes, the Extract group must be dropped andrecreated. For the remended procedure, see the Oracle GoldenGate Windows andUNIX Administrator’s Guide.●To write SQL operations to the trail, Extract must verify that there are no otheroperations from other RAC nodes that precede those in the current redo log that it isreading. For example, if a log contains operations that were performed from 1:00 .to 2:00 ., and the log from Node 2 contains operations that were performed from1:30 . to 2:30 ., then only those operations up to, and including, the 2:00 .one can be moved to the server where the main Extract is coordinating the redo data.Extract must ensure that there are no more operations between 2:00 . and 2:30 .that need to be captured.●In activepassive environments, the preceding requirement means that you might needto perform some operations and archive log switching on the passive node to ensurethat operations from the active node are passed to the passive node. This eliminatesany issues that could arise from a slow archiver process, failed network links, and otherlatency issues caused by moving archive logs from the Oracle nodes to the server wherethe main Extract is coordinating the redo data.●To process the last transaction in a RAC cluster before shutting down Extract, insert adummy record into a source table that Oracle GoldenGate is replicating, and thenswitch log files on all nodes. This will update the Extract checkpoint and confirm to theprocess that all available archive logs are available to read. It also confirms that alltransactions in those archive logs are captured and written to the trail in the correctorder.對于ASM環(huán)境GoldenGate的Extract進程需要一個用戶來訪問ASM實例，所以可以使用sys用戶或其他具有sysdba/sysasm權限的用戶來連接到ASM實例。操作系統(tǒng)要求●To install on Windows, the user installing Oracle GoldenGate must log in as Administrator.●To install on UNIX, the user installing Oracle GoldenGate must have read and write privileges on the Oracle GoldenGate installation directory.●The Oracle GoldenGate processes require an operating system user that has privileges to read, write, and delete files and subdirectories in the Oracle GoldenGate directory. In addition, the user for the Manager process requires privileges to control OracleGoldenGate processes.●The Extract process requires an operating system user that has read access to thetransaction log files, both online and archived. On UNIX systems, that user must be a member of the group that owns the Oracle instance. If you install the Manager process as a Windows service during the installation steps in this documentation, you must install as Administrator for the correct permissions to be assigned. If you cannot install Manager as a service, assign read access to Extract manually, and then run Manager and Extract as Administrator whenever you start them.●Dedicate these operating system users to Oracle GoldenGate. Sensitive informationmight be available to anyone who runs an Oracle GoldenGate process, depending onhow database authentication is con