Golden Gate entry guide: Installation

Golden Gate entry guide: Install the installation environment of this experiment: www.2cto.com OS → Red Hat Enterprize Linux 5.4 DB → Oracle 10g GG → ogg112101_fbo_ggs_Linux_x86_ora10g_32bit note that if the database version is different, Golden Gate should also select the corresponding version (I) first, decompress the installation file to/u01/app/oracle/ggs [plain] [oracle @ Think vmshare] $ unzip-d/u01/app/oracle/ggs/[oracle @ Think ggs] $ tar-xvof fbo_ggs_Linux_x86_ora10g_32bit.tar (2) set the corresponding environment variables, create [Plain] [oracle @ Think ~] $ Export ORACLE_HOME =/u01/app/oracle/product/10.2.0/db_1 [oracle @ Think ~] $ Export PATH = $ ORACLE_HOME/bin:/u01/app/oracle/ggs: $ PATH [oracle @ Think ~] $ Export LD_LIBRARY_PATH = $ ORACLE_HOME/lib:/u01/app/oracle/ggs (3) enter the GoldenGate command line mode and create a sub-GoldenGate subdirectory [plain] [oracle @ Think ~] $ Ggsci Oracle GoldenGate Command Interpreter for Oracle Version 11.2.1.0.1 oggcore_11.2.1.0.20.platforms_120423.0230_fbo Linux, x86, 32bit (optimized), Oracle 10g on Apr 23 2012 07:06:02 Copyright (C) 1995,201 2, oracle and/or its affiliates. all rights reserved. GGSCI (Think) 1> create subdirs Creating subdirectories under current directory/home/oracle Parameter files/home/oracle/dirprm: created Report files/home/oracle/dirrpt: created Checkpoint files/home/oracle/dirchk: created Process status files/home/oracle/dirpcs: created SQL script files/home/oracle/dirsql: created Database definitions files/home/oracle/dirdef: created Extract data files/home/oracle/dirdat: created Temporary files/home/oracle/dirtmp: created Stdout files/home/oracle/dirout: created (4) Next, you need to create an exclusive user in the Oracle database for the GoldenGate Manager process, extract Process and Replicat process [plain] idle> conn/as sysdba Connected. sys @ ORCL> create tablespace ggs_data datafile size 80 M; Tablespace created. sys @ ORCL> create user ogg identified by ogg default tablespace ggs_data; User created. sys @ ORCL> grant connect, resource to ogg; Grant succeeded. sys @ ORCL> grant select any dictionary, select any table to ogg; Grant succeeded. sys @ ORCL> grant create table to ogg; Grant succeeded. sys @ ORCL> grant flashback any table to ogg; Grant succeeded. sys @ ORCL> grant execute on dbms_flashback to ogg; Grant succeeded. sys @ ORCL> grant execute on utl_file to ogg; Grant succeeded. (v) Confirm that the ogg user we just created can log on to RDBMS [plain] [oracle @ Think ggs] $ ggsci Oracle GoldenGate Command Interpreter for Oracle Version 11.2.1.0.1 except Linux, x86, 32bit (optimized ), oracle 10g on Apr 23 2012 07:06:02 Copyright (C) 1995,201 2, Oracle and/or its affiliates. all rights reserved. GGSCI (Think) 1> dblogin userid ogg, PASSWORD ogg Successfully logged into database. (6) When the supplemental log is created at the DATABASE level, or the Extract process is awakened, [plain] sys @ ORCL> ALTER Database add supplemental log data (ALL) COLUMNS; DATABASE altered is reported. sys @ ORCL> select supplemental_log_data_min, supplemental_log_data_pk, supplemental_log_data_ui, 2 supplemental_log_data_fk, supplemental_log_data_all 3 from v $ database; suppleme sup -------- --- implicit no yes (vii) An error encountered during implementation [plain] GGSCI (Think) 1> dblogin userid ogg, PASSWORD ogg Cannot load ICU resource bundle 'ggmess', error code 2-No such file or directory Cannot load ICU resource bundle 'ggmessage ', error code 2-No such file or directory Aborted: You need to execute ggsci in the HOME directory of ggs before OK. If you execute ggsci in another location, an error is returned. The file or directory cannot be found.