Network Security Internet Technology Development Database Servers Mobile Phone Android Software Apple Software Computer Software News IT Information

In addition to Weibo, there is also WeChat

Please pay attention

WeChat public account

Shulou

[OGG] download and install OGG

2025-01-18 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Database >

Share

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

[OGG] download and install OGG

1. 1 BLOG document structure map

I. 2 preface part 1. 2.1 introduction

Technical enthusiasts, after reading this article, you can master the following skills, and you can also learn some other knowledge that you do not know, ~ O (∩ _ ∩) Olympiad:

Download and install ① OGG

If there are any mistakes or imperfections in this article, please correct them as much as you can, ITPUB or QQ. Your criticism is the biggest motivation of my writing.

I. 2.2 introduction to the experimental environment

11.2.0.3 RHEL6.5

I. 2.3 introduction to this article

A colleague called on me to solve the problem that OGG could not be synchronized. I was ashamed that I had learned about installation and simple configuration before, which was successful at that time. As a result, when I helped my colleagues build it, the data could not be synchronized. So I made up my mind to study the content of OGG again these days.

I.3 gg installation

Installing OGG on Linux is easy and is generally divided into the following sections:

1. Downloading Oracle GoldenGate software.

2. Setting ORACLE_HOME and ORACLE_SID

3. Setting library paths for dynamic builds

4. Installing the Oracle GoldenGate software

I. 3.1 Downloading Oracle GoldenGate software.

The first step is to download gg software, which can be downloaded directly in two ways.

I. 3.1.1 the first: http://edelivery.oracle.com

1. On a browser, go to http://edelivery.oracle.com

2. Welcome page:

L Select language

L Continue

3. Export Validation:

N Enter your name, company, email, country

N Accept Trial License (even if you have permanent license)

N Accept Export Restrictions

N Continue

4. Media Pack Search:

Select a Product Pack: Oracle Fusion Middleware

Select a platform from the drop-down list

Go

5. Results:

Select the Oracle GoldenGate Media Pack you want

Continue

6. View Readme

7. Download software

8. Download documentation

I. 3.1.2 the second: http://www.oracle.com

1. Log in to www.oracle.com and select See All under Middleware

two。 Select GoldenGate

Pay attention to selecting the corresponding version and platform:

There is no need to elaborate, so the final download address:

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

English: http://www.oracle.com/technetwork/cn/middleware/goldengate/downloads/index.html

I. 3.2 Setting ORACLE_HOME and ORACLE_SID

Set the environment variables in your .bash _ profile (Bash)

ORACLE_BASE=/u01

ORACLE_HOME=$ORACLE_BASE/oracle

ORACLE_SID=ggsource

PATH=$ORACLE_BASE/gg11:$ORACLE_HOME/bin:$PATH

LD_LIBRARY_PATH=$ORACLE_BASE/gg11:$ORACLE_HOME/lib:$LD_LIBRARYPATH

Export ORACLE_BASE ORACLE_HOME ORACLE_SID

Export PATH LD_LIBRARY_PATH

Myself:

Export ORACLE_BASE=/u01/app/oracle

Export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/dbhome_1

Export OGG_HOME=/u01/gg11

Export PATH=$OGG_HOME:$ORACLE_HOME/bin:$PATH

Export LD_LIBRARY_PATH=$OGG_HOME:$ORACLE_HOME/lib:$LD_LIBRARYPATH

Stty erase ^ h

Alias ggsci='rlwrap ggsci'

I. 3.3 Setting library paths for dynamic builds

Platform

Environment variables

IBM AIX

LIBPATH

IBM z/OS

HP-UX

SHLIB_PATH

Solaris

LD_LIBRARY_PATH

HP Tru64

Linux

I. 3.4 Installing the Oracle GoldenGate software

Use the gzip and tar options appropriate for your system. If you are installing GoldenGate into a cluster environment, make certain that the GoldenGate binaries and files are installed on a file system that is available to all cluster nodes. After installing GoldenGate, make certain to configure the GoldenGate Manager process within the cluster application, as directed by the vendor's documentation, so that GoldenGate will fail over properly with the other applications. The Manager process is the master control program for all GoldenGate operations.

A GoldenGate instance is a single installation of GoldenGate.

L Unzip the Oracle GoldenGate media pack .zip file on a Windows system. This produces a .tar file.

L FTP the .tar file in binary mode to the system and directory where you want GoldenGate to be installed.

L Extract the .tar file into the current directory:

Tar-xvof .tar

L Run the command shell and change directories to the new GoldenGate directory.

GGSCI > CREATE SUBDIRS

I. 3.5 GoldenGate Directories

Directory

Contents

Dirchk

GoldenGate checkpoint files

Dirdat

GoldenGate trail and extract files

Dirdef

Data definitions produced by DEFGEN and used to translate heterogeneous data

Dirpcs

Process status files

Dirprm

Parameter files

Dirrpt

Process report files

Dirsql

SQL scripts

Dirtmp

Temporary storage for transactions that exceed allocated memory

A.dirchk: store checkpoint files

B.dirdat: storing Trail files

C.dirdef: stores the source or destination data definition files generated by the DEFGEN tool

D.dirpcs: stores process status files

E.dirprm: stores configuration parameter files

F.dirrpt: store process report files

G.dirsql: store sql script files

H.dirtmp: when the memory required for food exceeds the allocated memory, it is stored in this directory by default.

I. 4 system requirements

1. An OGG instance supports a maximum of 300 concurrent extract and replicat processes, each of which requires 25-55 MB of memory.

2.GGSCI report view report, find the PROCESS VM AVAIL FROM OS, which is about the size of the GGSCI needed by the system

3. Disk space is 50-150m per instance, plus trail and so on, at least 1G. The method for estimating the space required for trail is: [log volume in one hour] x [number of hours downtime] * 0.4

4. / tmp space. The default is dirtmp directory, which can be specified by the CACHEDIRECTORY option of the CACHEMGR parameter.

5. The user who installs OGG must belong to the group of the ORACLE database instance, usually dba.

6. To support the RMAN log retention feature in RAC, you must install patch BUGFIX 11879974 before add extract

I. 5 my own installation example

The installation process is the same on both the source and target sides.

I. 5.1 configure environment variables

[oracle@rhel6_lhr ~] $vi gg_env.sh

[oracle@rhel6_lhr] $. Gg_env.sh

[oracle@rhel6_lhr ~] $more gg_env.sh

Export ORACLE_BASE=/u01/app/oracle

Export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/dbhome_1

Export PATH=/u01/gg11:$ORACLE_HOME/bin:$PATH

Export LD_LIBRARY_PATH=/u01/gg11:$ORACLE_HOME/lib:$LD_LIBRARYPATH

Stty erase ^ h

Alias ggsci='rlwrap ggsci'

[oracle@rhel6_lhr ~] $mkdir / u01/gg11

[oracle@rhel6_lhr ~] $env | grep LD

LD_LIBRARY_PATH=/u01/app/oracle/product/11.2.0/dbhome_1/lib:/usr/lib

[oracle@rhel6_lhr] $unzip / mnt/hgfs/share/V28941-01.zip-d / tmp/gg/

Archive: / mnt/hgfs/share/V28941-01.zip

Inflating: / tmp/gg/fbo_ggs_Linux_x64_ora11g_64bit.tar

Inflating: / tmp/gg/OGG_WinUnix_Rel_Notes_11.1.1.1.2.pdf

Inflating: / tmp/gg/Oracle_GoldenGate_11.1.1.1_README.txt

[oracle@rhel6_lhr ~] $ll / tmp/gg

Total 268088

-rw-r--r--. 1 oracle oinstall 274247680 Oct 7 2011 fbo_ggs_Linux_x64_ora11g_64bit.tar

-rw-r--r--. 1 oracle oinstall 245329 Oct 29 2011 OGG_WinUnix_Rel_Notes_11.1.1.1.2.pdf

-rw-r--r--. 1 oracle oinstall 25065 Oct 29 2011 Oracle_GoldenGate_11.1.1.1_README.txt

I. 5.2 decompression

[oracle@rhel6_lhr] $tar xvf / tmp/gg/fbo_ggs_Linux_x64_ora11g_64bit.tar-C / u01/gg11/

Bcpfmt.tpl

Bcrypt.txt

Cfg/

Cfg/MPMetadataSchema.xsd

Cfg/Config.properties

Cfg/ProfileConfig.xml

Cfg/password.properties

Cfg/mpmetadata.xml

Cfg/jps-config-jse.xml

Chkpt_ora_create.sql

Cobgen

Convchk

Db2cntl.tpl

Ddl_access.tpl

Ddl_cleartrace.sql

Ddlcob

Ddl_db2_os390.tpl

Ddl_db2.tpl

Ddl_ddl2file.sql

Ddl_disable.sql

Ddl_enable.sql

Ddl_filter.sql

Ddlgen

Ddl_informix.tpl

Ddl_mss.tpl

Ddl_mysql.tpl

Ddl_nopurgeRecyclebin.sql

Ddl_nssql.tpl

Ddl_ora10.sql

Ddl_ora10upCommon.sql

Ddl_ora11.sql

Ddl_ora9.sql

Ddl_oracle.tpl

Ddl_pin.sql

Ddl_purgeRecyclebin.sql

Ddl_remove.sql

Ddl_session1.sql

Ddl_session.sql

Ddl_setup.sql

Ddl_sqlmx.tpl

Ddl_status.sql

Ddl_staymetadata_off.sql

Ddl_staymetadata_on.sql

Ddl_sybase.tpl

Ddl_tandem.tpl

Ddl_tracelevel.sql

Ddl_trace_off.sql

Ddl_trace_on.sql

Defgen

Demo_more_ora_create.sql

Demo_more_ora_insert.sql

Demo_ora_create.sql

Demo_ora_insert.sql

Demo_ora_lob_create.sql

Demo_ora_misc.sql

Demo_ora_pk_befores_create.sql

Demo_ora_pk_befores_insert.sql

Demo_ora_pk_befores_updates.sql

Dirjar/

Dirjar/oraclepki.jar

Dirjar/jps-unsupported-api.jar

Dirjar/fmw_audit.jar

Dirjar/spring-security-cas-client-3.0.1.RELEASE.jar

Dirjar/jps-manifest.jar

Dirjar/xstream-1.3.jar

Dirjar/monitor-common.jar

Dirjar/commons-logging-1.0.4.jar

Dirjar/org.springframework.jdbc-3.0.0.RELEASE.jar

Dirjar/jps-upgrade.jar

Dirjar/org.springframework.core-3.0.0.RELEASE.jar

Dirjar/org.springframework.aop-3.0.0.RELEASE.jar

Dirjar/org.springframework.web-3.0.0.RELEASE.jar

Dirjar/ldapjclnt11.jar

Dirjar/jmxremote_optional-1.0-b02.jar

Dirjar/spring-security-acl-3.0.1.RELEASE.jar

Dirjar/jps-wls.jar

Dirjar/identityutils.jar

Dirjar/identitystore.jar

Dirjar/org.springframework.context-3.0.0.RELEASE.jar

Dirjar/jsr250-api-1.0.jar

Dirjar/jacc-spi.jar

Dirjar/jagent.jar

Dirjar/org.springframework.expression-3.0.0.RELEASE.jar

Dirjar/org.springframework.context.support-3.0.0.RELEASE.jar

Dirjar/spring-security-core-3.0.1.RELEASE.jar

Dirjar/jps-api.jar

Dirjar/org.springframework.test-3.0.0.RELEASE.jar

Dirjar/osdt_core.jar

Dirjar/jps-ee.jar

Dirjar/osdt_cert.jar

Dirjar/log4j-1.2.15.jar

Dirjar/org.springframework.aspects-3.0.0.RELEASE.jar

Dirjar/org.springframework.instrument-3.0.0.RELEASE.jar

Dirjar/jps-common.jar

Dirjar/spring-security-config-3.0.1.RELEASE.jar

Dirjar/jps-mbeans.jar

Dirjar/xmlparserv2.jar

Dirjar/commons-codec-1.3.jar

Dirjar/xpp3_min-1.1.4c.jar

Dirjar/spring-security-web-3.0.1.RELEASE.jar

Dirjar/jps-patching.jar

Dirjar/spring-security-taglibs-3.0.1.RELEASE.jar

Dirjar/org.springframework.orm-3.0.0.RELEASE.jar

Dirjar/slf4j-log4j12-1.4.3.jar

Dirjar/org.springframework.beans-3.0.0.RELEASE.jar

Dirjar/jdmkrt-1.0-b02.jar

Dirjar/jps-internal.jar

Dirjar/slf4j-api-1.4.3.jar

Dirjar/org.springframework.asm-3.0.0.RELEASE.jar

Dirjar/org.springframework.transaction-3.0.0.RELEASE.jar

Dirjar/osdt_xmlsec.jar

Emsclnt

Extract

FreeBSD.txt

GgMessage.dat

Ggsci

Help.txt

Jagent.sh

Keygen

Libicudata.so.38

Libicui18n.so.38

Libicuuc.so.38

Libxerces-c.so.28

Libxml2.txt

Logdump

Marker_remove.sql

Marker_setup.sql

Marker_status.sql

Mgr

Notices.txt

Params.sql

Prvtclkm.plb

Pw_agent_util.sh

Remove_seq.sql

Replicat

Retrace

Reverse

Role_setup.sql

Sequence.sql

Server

Sqlldr.tpl

Tcperrs

UserExitExamples/

UserExitExamples/ExitDemo_lobs/

UserExitExamples/ExitDemo_lobs/Makefile_lob.SOLARIS

UserExitExamples/ExitDemo_lobs/readme.txt

UserExitExamples/ExitDemo_lobs/exitdemo_lob.vcproj

UserExitExamples/ExitDemo_lobs/Makefile_lob.AIX

UserExitExamples/ExitDemo_lobs/Makefile_lob.LINUX

UserExitExamples/ExitDemo_lobs/Makefile_lob.HPUX

UserExitExamples/ExitDemo_lobs/exitdemo_lob.c

UserExitExamples/ExitDemo/

UserExitExamples/ExitDemo/exitdemo.c

UserExitExamples/ExitDemo/readme.txt

UserExitExamples/ExitDemo/Makefile_exit_demo.HPUX

UserExitExamples/ExitDemo/Makefile_exit_demo.AIX

UserExitExamples/ExitDemo/Makefile_exit_demo.SOLARIS

UserExitExamples/ExitDemo/Makefile_exit_demo.LINUX

UserExitExamples/ExitDemo/Makefile_exit_demo.HP_OSS

UserExitExamples/ExitDemo/exitdemo.vcproj

UserExitExamples/ExitDemo_pk_befores/

UserExitExamples/ExitDemo_pk_befores/Makefile_pk_befores.SOLARIS

UserExitExamples/ExitDemo_pk_befores/readme.txt

UserExitExamples/ExitDemo_pk_befores/Makefile_pk_befores.HPUX

UserExitExamples/ExitDemo_pk_befores/exitdemo_pk_befores.c

UserExitExamples/ExitDemo_pk_befores/Makefile_pk_befores.LINUX

UserExitExamples/ExitDemo_pk_befores/exitdemo_pk_befores.vcproj

UserExitExamples/ExitDemo_pk_befores/Makefile_pk_befores.AIX

UserExitExamples/ExitDemo_more_recs/

UserExitExamples/ExitDemo_more_recs/Makefile_more_recs.SOLARIS

UserExitExamples/ExitDemo_more_recs/readme.txt

UserExitExamples/ExitDemo_more_recs/exitdemo_more_recs.c

UserExitExamples/ExitDemo_more_recs/Makefile_more_recs.AIX

UserExitExamples/ExitDemo_more_recs/Makefile_more_recs.HPUX

UserExitExamples/ExitDemo_more_recs/Makefile_more_recs.LINUX

UserExitExamples/ExitDemo_more_recs/exitdemo_more_recs.vcproj

UserExitExamples/ExitDemo_passthru/

UserExitExamples/ExitDemo_passthru/Makefile_passthru.HPUX

UserExitExamples/ExitDemo_passthru/Makefile_passthru.AIX

UserExitExamples/ExitDemo_passthru/exitdemo_passthru.c

UserExitExamples/ExitDemo_passthru/readme.txt

UserExitExamples/ExitDemo_passthru/Makefile_passthru.SOLARIS

UserExitExamples/ExitDemo_passthru/Makefile_passthru.LINUX

UserExitExamples/ExitDemo_passthru/exitdemopassthru.vcproj

UserExitExamples/ExitDemo_passthru/Makefile_passthru.HP_OSS

Usrdecs.h

Zlib.txt

I. 5.3 installation

1. Make sure that the user of the gg11 directory is Oracle, if not executed: chown-R oracle:oinstall gg11

two。 Enter the gg11 directory during installation, otherwise it will be installed under the currently logged in directory

[oracle@rhel6_lhr ~] $cd / U01

[oracle@rhel6_lhr U01] $ll

Total 8

Drwxrwxr-x. 5 grid oinstall 4096 Jun 14 22:13 app

Drwxr-xr-x. 5 oracle oinstall 4096 Oct 30 15:39 gg11

[oracle@rhel6_lhr gg11] $ggsci

Oracle GoldenGate Command Interpreter for Oracle

Version 11.1.1.1.2 OGGCORE_11.1.1.1.2_PLATFORMS_111004.2100

Linux, x64, 64bit (optimized), Oracle 11g on Oct 4 2011 23:49:46

Copyright (C) 1995, 2011, Oracle and/or its affiliates. All rights reserved.

GGSCI (rhel6_lhr) 1 > create subdirs

Creating subdirectories under current directory / u01/gg11

Parameter files / u01/gg11/dirprm: created

Report files / u01/gg11/dirrpt: created

Checkpoint files / u01/gg11/dirchk: created

Process status files / u01/gg11/dirpcs: created

SQL script files / u01/gg11/dirsql: created

Database definitions files / u01/gg11/dirdef: created

Extract data files / u01/gg11/dirdat: created

Temporary files / u01/gg11/dirtmp: created

Veridata files / u01/gg11/dirver: created

Veridata Lock files / u01/gg11/dirver/lock: created

Veridata Out-Of-Sync files / u01/gg11/dirver/oos: created

Veridata Out-Of-Sync XML files / u01/gg11/dirver/oosxml: created

Veridata Parameter files / u01/gg11/dirver/params: created

Veridata Report files / u01/gg11/dirver/report: created

Veridata Status files / u01/gg11/dirver/status: created

Veridata Trace files / u01/gg11/dirver/trace: created

Stdout files / u01/gg11/dirout: created

GGSCI (rhel6_lhr) 2 > exit

[oracle@rhel6_lhr gg11] $ls-ltr

Total 249672

-Rafael, Rafe, Rafael. 1 oracle oinstall 1476 Oct 15 2010 zlib.txt

-Rafael, Rafe, Rafael. 1 oracle oinstall 759 Oct 15 2010 tcperrs

-Rafael, Rafe, Rafael. 1 oracle oinstall 248 Oct 15 2010 sqlldr.tpl

-Rafael, Rafe, Rafael. 1 oracle oinstall 1668 Oct 15 2010 libxml2.txt

-Rafael, Rafe, Rafael. 1 oracle oinstall 1968 Oct 15 2010 freeBSD.txt

-Rafael, Rafe, Rafael. 1 oracle oinstall 2653 Oct 15 2010 ddl_tandem.tpl

-Rafael, Rafe, Rafael. 1 oracle oinstall 3523 Oct 15 2010 ddl_sybase.tpl

-Rafael, Rafe, Rafael. 1 oracle oinstall 2652 Oct 15 2010 ddl_sqlmx.tpl

-Rafael, Rafe, Rafael. 1 oracle oinstall 3458 Oct 15 2010 ddl_oracle.tpl

-Rafael, Rafe, Rafael. 1 oracle oinstall 2653 Oct 15 2010 ddl_nssql.tpl

-Rafael, Rafe, Rafael. 1 oracle oinstall 3481 Oct 15 2010 ddl_mysql.tpl

-Rafael, Rafe, Rafael. 1 oracle oinstall 2984 Oct 15 2010 ddl_informix.tpl

-Rafael, Rafe, Rafael. 1 oracle oinstall 3017 Oct 15 2010 ddl_db2.tpl

-Rafael, Rafe, Rafael. 1 oracle oinstall 3502 Oct 15 2010 ddl_db2_os390.tpl

-Rafael, Rafe, Rafael. 1 oracle oinstall 3334 Oct 15 2010 ddl_access.tpl

-Rafael, Rafe, Rafael. 1 oracle oinstall 159 Oct 15 2010 db2cntl.tpl

-Rafael, Rafe, Rafael. 1 oracle oinstall 1725 Oct 15 2010 bcrypt.txt

-Rafael, Rafe, Rafael. 1 oracle oinstall 426 Oct 15 2010 bcpfmt.tpl

-Rafael, Rafe, Rafael. 1 oracle oinstall 21197 Oct 15 2010 usrdecs.h

-Rafael, Rafe, Rafael. 1 oracle oinstall 1715 Oct 15 2010 marker_status.sql

-Rafael, Rafe, Rafael. 1 oracle oinstall 3702 Oct 15 2010 marker_setup.sql

-Rafael, Rafe, Rafael. 1 oracle oinstall 2162 Oct 15 2010 marker_remove.sql

-Rafael, Rafe, Rafael. 1 oracle oinstall 2275 Oct 15 2010 demo_ora_misc.sql

-Rafael, Rafe, Rafael. 1 oracle oinstall 4015 Oct 15 2010 demo_ora_lob_create.sql

-Rafael, Rafe, Rafael. 1 oracle oinstall 821 Oct 15 2010 demo_ora_insert.sql

-Rafael, Rafe, Rafael. 1 oracle oinstall 883 Oct 15 2010 demo_ora_create.sql

-Rafael, Rafe, Rafael. 1 oracle oinstall 2862 Oct 15 2010 ddl_trace_on.sql

-Rafael, Rafe, Rafael. 1 oracle oinstall 2955 Oct 15 2010 ddl_tracelevel.sql

-Rafael, Rafe, Rafael. 1 oracle oinstall 2501 Oct 15 2010 ddl_staymetadata_on.sql

-Rafael, Rafe, Rafael. 1 oracle oinstall 2506 Oct 15 2010 ddl_staymetadata_off.sql

-Rafael, Rafe, Rafael. 1 oracle oinstall 8872 Oct 15 2010 ddl_status.sql

-Rafael, Rafe, Rafael. 1 oracle oinstall 1227 Oct 15 2010 ddl_purgeRecyclebin.sql

-Rafael, Rafe, Rafael. 1 oracle oinstall 1026 Oct 15 2010 ddl_pin.sql

-Rafael, Rafe, Rafael. 1 oracle oinstall 388 Oct 15 2010 ddl_nopurgeRecyclebin.sql

-Rafael, Rafe, Rafael. 1 oracle oinstall 692 Oct 15 2010 ddl_enable.sql

-Rafael, Rafe, Rafael. 1 oracle oinstall 746 Oct 15 2010 ddl_disable.sql

-Rafael, Rafe, Rafael. 1 oracle oinstall 4189 Oct 15 2010 ddl_ddl2file.sql

-Rafael, Rafe, Rafael. 1 oracle oinstall 1059 Oct 15 2010 ddl_cleartrace.sql

-Rafael, Rafe, Rafael. 1 oracle oinstall 739 Oct 15 2010 chkpt_ora_create.sql

-Rafael, Rafe, Rafael. 1 oracle oinstall 2520 Oct 15 2010 demo_ora_pk_befores_updates.sql

-Rafael, Rafe, Rafael. 1 oracle oinstall 1227 Oct 15 2010 demo_ora_pk_befores_insert.sql

-Rafael, Rafe, Rafael. 1 oracle oinstall 1269 Oct 15 2010 demo_ora_pk_befores_create.sql

-Rafael, Rafe, Rafael. 1 oracle oinstall 967 Oct 15 2010 demo_more_ora_insert.sql

-Rafael, Rafe, Rafael. 1 oracle oinstall 1217 Oct 15 2010 demo_more_ora_create.sql

-Rafael, Rafe, Rafael. 1 oracle oinstall 1053 Oct 15 2010 ddl_session.sql

-Rafael, Rafe, Rafael. 1 oracle oinstall 425 Oct 15 2010 ddl_session1.sql

-Rafael, Rafe, Rafael. 1 oracle oinstall 3686 Oct 15 2010 ddl_remove.sql

-Rafael, Rafe, Rafael. 1 oracle oinstall 3414 Oct 15 2010 ddl_mss.tpl

-Rafael, Rafe, Rafael. 1 oracle oinstall 1272 Dec 10 2010 prvtclkm.plb

-Rafael, Rafe, Rafael. 1 oracle oinstall 206155 Dec 10 2010 notices.txt

-Rafael, Rafe, Rafael. 1 oracle oinstall 4752 Dec 10 2010 params.sql

-Rafael, Rafe, Rafael. 1 oracle oinstall 3102 Feb 10 2011 ddl_filter.sql

-r--r--r-x. 1 oracle oinstall 12622 Feb 10 2011 ddl_ora11.sql

-r--r--r-x. 1 oracle oinstall 6380 Feb 10 2011 ddl_ora10upCommon.sql

-r--r--r-x. 1 oracle oinstall 12947 Feb 10 2011 ddl_ora10.sql

-r--r--r-x. 1 oracle oinstall 2721 Feb 10 2011 ddl_trace_off.sql

-Rafael, Rafe, Rafael. 1 oracle oinstall 4375 Mar 11 2011 role_setup.sql

-Rafael, Rafe, Rafael. 1 oracle oinstall 2406 Mar 31 2011 remove_seq.sql

-r-xr-xr-x. 1 oracle oinstall 248842 May 27 2011 ddl_setup.sql

-r--r--r-x. 1 oracle oinstall 13989 May 27 2011 ddl_ora9.sql

-r--r--r-x. 1 oracle oinstall 156062 Jul 19 2011 help.txt

-r _ r 1 oracle oinstall 32608 Sep 2 2011 sequence.sql

-r-xr-xr-x. 1 oracle oinstall 5323945 Sep 10 2011 libxerces-c.so.28

-r-xr-xr-x. 1 oracle oinstall 11360748 Sep 10 2011 libicudata.so.38

-r-xr-xr-x. 1 oracle oinstall 4034679 Sep 10 2011 libicuuc.so.38

-r-xr-xr-x. 1 oracle oinstall 5359083 Sep 10 2011 libicui18n.so.38

Drwxr-xr-x. 7 oracle oinstall 4096 Oct 5 2011 UserExitExamples

-rw-r--r--. 1 oracle oinstall 475120 Oct 5 2011 ggMessage.dat

-rwxr-xr-x. 1 oracle oinstall 41448853 Oct 5 2011 mgr

-rwxr-xr-x. 1 oracle oinstall 24780728 Oct 5 2011 ggsci

-rwxr-xr-x. 1 oracle oinstall 1015 Oct 5 2011 pw_agent_util.sh

-rwxr-xr-x. 1 oracle oinstall 406 Oct 5 2011 jagent.sh

Drwxr-xr-x. 2 oracle oinstall 4096 Oct 5 2011 dirjar

Drwxr-xr-x. 2 oracle oinstall 4096 Oct 5 2011 cfg

-rwxr-xr-x. 1 oracle oinstall 8196806 Oct 5 2011 cobgen

-rwxr-xr-x. 1 oracle oinstall 8277142 Oct 5 2011 ddlcob

-rwxr-xr-x. 1 oracle oinstall 8676240 Oct 5 2011 emsclnt

-rwxr-xr-x. 1 oracle oinstall 105222 Oct 5 2011 keygen

-rwxr-xr-x. 1 oracle oinstall 1351252 Oct 5 2011 logdump

-rwxr-xr-x. 1 oracle oinstall 8140619 Oct 5 2011 retrace

-rwxr-xr-x. 1 oracle oinstall 402443 Oct 5 2011 reverse

-rwxr-xr-x. 1 oracle oinstall 13821413 Oct 5 2011 server

-rwxr-xr-x. 1 oracle oinstall 8138320 Oct 5 2011 convchk

-rwxr-xr-x. 1 oracle oinstall 9787054 Oct 5 2011 ddlgen

-rwxr-xr-x. 1 oracle oinstall 9668859 Oct 5 2011 defgen

-rwxr-xr-x. 1 oracle oinstall 45803664 Oct 7 2011 extract

-rwxr-xr-x. 1 oracle oinstall 39442364 Oct 7 2011 replicat

Drwxrwxr-x. 9 oracle oinstall 4096 Oct 30 15:54 dirver

Drwxrwxr-x. 2 oracle oinstall 4096 Oct 30 15:54 dirtmp

Drwxrwxr-x. 2 oracle oinstall 4096 Oct 30 15:54 dirsql

Drwxrwxr-x. 2 oracle oinstall 4096 Oct 30 15:54 dirrpt

Drwxrwxr-x. 2 oracle oinstall 4096 Oct 30 15:54 dirprm

Drwxrwxr-x. 2 oracle oinstall 4096 Oct 30 15:54 dirpcs

Drwxrwxr-x. 2 oracle oinstall 4096 Oct 30 15:54 dirout

Drwxrwxr-x. 2 oracle oinstall 4096 Oct 30 15:54 dirdef

Drwxrwxr-x. 2 oracle oinstall 4096 Oct 30 15:54 dirdat

Drwxrwxr-x. 2 oracle oinstall 4096 Oct 30 15:54 dirchk

[oracle@rhel6_lhr gg11] $

[oracle@rhel6_lhr ~] $cd $OGG_HOME

[oracle@rhel6_lhr gg11] $ggsci

Oracle GoldenGate Command Interpreter for Oracle

Version 11.2.1.0.1 OGGCORE_11.2.1.0.1_PLATFORMS_120423.0230_FBO

Linux, x64, 64bit (optimized), Oracle 11g on Apr 23 2012 08:32:14

Copyright (C) 1995, 2012, Oracle and/or its affiliates. All rights reserved.

GGSCI (rhel6_lhr) 1 > info all

Program Status Group Lag at Chkpt Time Since Chkpt

MANAGER STOPPED

GGSCI (rhel6_lhr) 2 > help

GGSCI Command Summary:

Object: Command:

SUBDIRS CREATE

ER INFO, KILL, LAG, SEND, STATUS, START, STATS, STOP

EXTRACT ADD, ALTER, CLEANUP, DELETE, INFO, KILL

LAG, REGISTER, SEND, START, STATS, STATUS, STOP

UNREGISTER

EXTTRAIL ADD, ALTER, DELETE, INFO

GGSEVT VIEW

MANAGER INFO, SEND, START, STOP, STATUS

MARKER INFO

PARAMS EDIT, VIEW

REPLICAT ADD, ALTER, CLEANUP, DELETE, INFO, KILL, LAG, SEND

START, STATS, STATUS, STOP

REPORT VIEW

RMTTRAIL ADD, ALTER, DELETE, INFO

TRACETABLE ADD, DELETE, INFO

TRANDATA ADD, DELETE, INFO

SCHEMATRANDATA ADD, DELETE, INFO

CHECKPOINTTABLE ADD, DELETE, CLEANUP, INFO

Commands without an object:

(Database) DBLOGIN, LIST TABLES, ENCRYPT PASSWORD, FLUSH SEQUENCE

MININGDBLOGIN

(DDL) DUMPDDL

(Miscellaneous) FC, HELP, HISTORY, INFO ALL, OBEY, SET EDITOR, SHELL

SHOW, VERSIONS,! (note: you must type the word

COMMAND after the! To display the! Help topic.)

I.e.: GGSCI (sys1) > help! Command

For help on a specific command, type HELP.

Example: HELP ADD REPLICAT

GGSCI (rhel6_lhr) 3 >

I. 6 Summary

The installation of OGG is very simple compared to the installation of ORACLE, that is, configure the environment variables, then extract it, and finally create a directory.

1. 7 About Me

. .

The author: wheat seedlings, only focus on the technology of database, pay more attention to the application of technology.

ITPUB BLOG: http://blog.itpub.net/26736162

Address: http://blog.itpub.net/26736162/viewspace-1693241/

Pdf version of this article: http://yunpan.cn/QCwUAI9bn7g7w extraction code: af2d

If you add QQ to QQ:642808185, please indicate the title of the article you are reading

Creation time and place: 2015-06-09 10 00 ~ 2015-06-09 19:00 at × × trading center

. .

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.

Views: 0

*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.

Share To

Database

Wechat

© 2024 shulou.com SLNews company. All rights reserved.

12
Report