Shulou(Shulou.com)06/01 Report--

The first step is to download the installation package for ogg. Download address is as follows

Http://www.oracle.com/technetwork/middleware/goldengate/downloads/index.html

Upload the installation package to the server

Decompress the package

[oracle@localhost app] $mkdir / u01/app/ogg [oracle@localhost app] $unzip-d / u01/app/ogg ogg112101_fbo_ggs_Linux_x64_ora11g_64bit.zip Archive: ogg112101_fbo_ggs_Linux_x64_ora11g_64bit.zip inflating: / u01/app/ogg/fbo_ggs_Linux_x64_ora11g_64bit.tar inflating: / u01/app/ogg/OGG_WinUnix_Rel_Notes _ 11.2.1.0.1.pdf inflating: / u01/app/ogg/Oracle GoldenGate 11.2.1.0.1 README.txt inflating: / u01/app/ogg/Oracle GoldenGate 11.2.1.0.1 README.doc [oracle@localhost app] $cd ogg/ [oracle@localhost ogg] $tar-xvf fbo_ggs_Linux_x64_ora11g_64bit.tar

Modify the environment variable to add PATH, LD_LIBARY_PATH

[oracle@localhost ~] $vi .bash _ profile export PATH=/u01/app/ogg/:$ORACLE_HOME/bin:$PATHexport LD_LIBRARY_PATH=/u01/app/ogg:$ORACLE_HOME/lib:/lib:/usr/lib

Go to the installation directory of ogg and run the ggsci command

[oracle@localhost ogg] $. / ggsci Oracle GoldenGate Command Interpreter for OracleVersion 11.2.1.0.1 OGGCORE_11.2.1.0.1_PLATFORMS_120423.0230_FBOLinux, x64, 64bit (optimized), Oracle 11g on Apr 23 2012 08:32:14Copyright (C) 1995, 2012, Oracle and/or its affiliates. All rights reserved.GGSCI (localhost.localdomain) 1 >

Create a working directory for OGG

GGSCI (localhost.localdomain) 1 > create subdirsCreating subdirectories under current directory / u01/app/oggParameter files / u01/app/ogg/dirprm: already existsReport files / u01/app/ogg/dirrpt: createdCheckpoint files / u01/app/ogg/dirchk: createdProcess status files / u01/app/ogg/dirpcs: createdSQL script files / u01/app/ogg/dirsql: createdDatabase definitions files / u01 / App/ogg/dirdef: createdExtract data files / u01/app/ogg/dirdat: createdTemporary files / u01/app/ogg/dirtmp: createdStdout files / u01/app/ogg/dirout: created

Configure parameters for the Manager process

GGSCI (localhost.localdomain) 6 > EDIT PARAMS MGR

Add the following to define the communication port for the Manger process

-- This is the minimal configuration of Manager PORT 7809

-- followed by comments

Start the Manager process

GGSCI (localhost.localdomain) 14 > start mgrManager started.

View Manager processes

GGSCI (localhost.localdomain) 17 > info mgrManager is running (IP port localhost.localdomain.7809).

Stop the Manager process

GGSCI (localhost.localdomain) 18 > stop mgrManager process is required by other GGS processes.Are you sure you want to stop it (YSEO)? YSending STOP request to MANAGER... Request processed.Manager stopped.

If you ignore the confirmation message

GGSCI (localhost.localdomain) 20 > stop mgr! Sending STOP request to MANAGER... Request processed.Manager stopped.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.