goldengate monitor 11.1安装配置一——OGG配置

官方文档：http://docs.oracle.com/cd/E22355_01/doc.11111/e17815.pdf
goldengate monitor是一套监控goldengate的软件，如果安装的ogg比较多，使用goldengate monitor可以清楚的看见全部OGG的每个进程运行状态，以及整个OGG的架构图。配置简单，可以通过web方式访问。功能之强大，所以goldengate monitor的价格比goldengate还贵。
详细的介绍见官方文档（里面有很多拓扑图及例子）。
首先配置OGG 环境
创建ogg用户（正式环境须注意，指定另外的表空间，密码过于简单，dba权限）
sqlplus / as sysdba
create users ogguser identified by ogguser
grant dba to ogguser
配置OGG：
[code][oracle@localhost ogghome]$ ./ggsci

Oracle GoldenGate Command Interpreter for Oracle
Version 11.2.1.0.1 OGGCORE_11.2.1.0.1_PLATFORMS_120423.0230_FBO
Linux, x86, 32bit (optimized), Oracle 11g on Apr 23 2012 08:09:25

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

GGSCI (localhost.localdomain) 1> info all

Program Status Group Lag at Chkpt Time Since Chkpt

MANAGER STOPPED

GGSCI (localhost.localdomain) 2> create subdirs

Creating subdirectories under current directory /u01/ogg/ogghome

Parameter files /u01/ogg/ogghome/dirprm: already exists
Report files /u01/ogg/ogghome/dirrpt: created
Checkpoint files /u01/ogg/ogghome/dirchk: created
Process status files /u01/ogg/ogghome/dirpcs: created
SQL script files /u01/ogg/ogghome/dirsql: created
Database definitions files /u01/ogg/ogghome/dirdef: created
Extract data files /u01/ogg/ogghome/dirdat: created
Temporary files /u01/ogg/ogghome/dirtmp: created
Stdout files /u01/ogg/ogghome/dirout: created

GGSCI (localhost.localdomain) 3> edit params mgr
USERID ogguser,PASSWORD ogguser
PORT 7848

GGSCI (localhost.localdomain) 1> edit params ./GLOBALS
GGSCHEMA ogguser
CHECKPOINTTABLE ogguser.checkpoint[/code]
创建测试表
[code]SQL> conn awen/oracle
Connected.
SQL> create table ogg_obj as select * from dba_objects where 1=2;

Table created.

SQL> create table ogg_seg as select * from dba_segments where 1=2;

Table created.

SQL> conn scott/oracle
Connected.
SQL> create table ogg_obj as select * from dba_objects where 1=2;

Table created.

SQL> create table ogg_seg as select * from dba_segments where 1=2;

Table created.[/code]
配置进程
[code]GGSCI (localhost.localdomain) 2> dblogin userid ogguser,password ogguser
Successfully logged into database.
GGSCI (localhost.localdomain) 4> add trandata awen.ogg_obj

2013-08-22 10:17:15 WARNING OGG-00869 No unique key is defined for table 'OGG_OBJ'. All viable columns will be used to represent the key, but may not guarantee uniqueness. KEYCOLS may be used to define the key.

Logging of supplemental redo data enabled for table AWEN.OGG_OBJ.

GGSCI (localhost.localdomain) 5> add trandata awen.ogg_seg

2013-08-22 10:17:27 WARNING OGG-00869 No unique key is defined for table 'OGG_SEG'. All viable columns will be used to represent the key, but may not guarantee uniqueness. KEYCOLS may be used to define the key.

Logging of supplemental redo data enabled for table AWEN.OGG_SEG.

GGSCI (localhost.localdomain) 6> add extract awen_ext, tranlog, begin now
EXTRACT added.

GGSCI (localhost.localdomain) 7> add exttrail ./dirdat/va, EXTRACT awen_ext, megabytes 100
EXTTRAIL added.

GGSCI (localhost.localdomain) 8> add extract awen_pump , exttrailsource ./dirdat/va
ERROR: Invalid group name (must be at most 8 characters).

GGSCI (localhost.localdomain) 9> add extract awen_pmp , exttrailsource ./dirdat/va
EXTRACT added.

GGSCI (localhost.localdomain) 10> add rmttrail ./dirdat/vb, EXTRACT awen_pmp, megabytes 100
RMTTRAIL added.

GGSCI (localhost.localdomain) 11> eidt params awen_ext
ERROR: Invalid command.

GGSCI (localhost.localdomain) 12> edit params awen_ext
EXTRACT awen_ext
USERID ogguser,PASSWORD ogguser
EXTTRAIL ./dirdat/va
TABLE awen.ogg_obj;
TABLE awen.ogg_seg;

GGSCI (localhost.localdomain) 13> edit params awen_pmp
EXTRACT awen_pmp
USERID ogguser,PASSWORD ogguser
RMTHOST 127.0.0.1,MGRPORT 7848,COMPRESS
RMTTRAIL ./dirdat/vb
TABLE awen.*;

GGSCI (localhost.localdomain) 14> add CHECKPOINTTABLE
ERROR: Missing checkpoint table specification.

GGSCI (localhost.localdomain) 15> info CHECKPOINTTABLE ;

Checkpoint table ; does not exist.

GGSCI (localhost.localdomain) 16> add CHECKPOINTTABLE ogguser.checkpoint
ERROR: OCI Error ORA-00955: name is already used by an existing object (status = 955). Creating checkpoint table ogguser.checkpoint, SQL <CREATE TABLE ogguser.checkpoint ( group_name VARCHAR2(8) NOT NULL, group_key NUMBER(19) NOT NULL, seqno integer, rba NUMBER(19) NOT NULL, audit_ts VARCHAR2(29), create_ts DATE NOT NULL, last_update_ts DATE NOT NULL, current_dir VARCHAR2(255) NOT NULL, log_csn VARCHAR2(129), log_xid VARCHAR2(129), log_cmplt_csn VARCHAR2(129), log_cmplt_xids VARCHAR2(2000), version NUMBER(3), PRIMARY KEY (group_name, group_key))>.

GGSCI (localhost.localdomain) 17> ADD REPLICAT awen_rep, EXTTRAIL ./dirdat/vb
ERROR: No checkpoint table specified for ADD REPLICAT.

GGSCI (localhost.localdomain) 18> add CHECKPOINTTABLE ogguser.checkpoint

Successfully created checkpoint table ogguser.checkpoint.

GGSCI (localhost.localdomain) 19> ADD REPLICAT awen_rep, EXTTRAIL ./dirdat/vb
ERROR: No checkpoint table specified for ADD REPLICAT.

GGSCI (localhost.localdomain) 20> ADD REPLICAT awen_rep, EXTTRAIL ./dirdat/vb, ,CHECKPOINTTABLE ogguser.checkpoint;
REPLICAT added.

GGSCI (localhost.localdomain) 21> edit params awen_rep
replicat awen_rep
ASSUMETARGETDEFS
USERID ogguser, PASSWORD ogguser
DISCARDFILE ./dirrpt/awen_rep.dsc, PURGE
map awen.ogg_obj, target scott.ogg_obj;
map awen.ogg_seg, target scott.ogg_seg;

GGSCI (localhost.localdomain) 22> info all

Program Status Group Lag at Chkpt Time Since Chkpt

MANAGER STOPPED
EXTRACT STOPPED AWEN_EXT 00:00:00 00:13:48
EXTRACT STOPPED AWEN_PMP 00:00:00 00:12:42
REPLICAT STOPPED AWEN_REP 00:00:00 00:04:32

GGSCI (localhost.localdomain) 23> start mgr

Manager started.

GGSCI (localhost.localdomain) 24> start AWEN_EXT

Sending START request to MANAGER ...
EXTRACT AWEN_EXT starting

GGSCI (localhost.localdomain) 25> info all

Program Status Group Lag at Chkpt Time Since Chkpt

MANAGER RUNNING
EXTRACT RUNNING AWEN_EXT 00:14:05 00:00:05
EXTRACT STOPPED AWEN_PMP 00:00:00 00:13:03
REPLICAT STOPPED AWEN_REP 00:00:00 00:04:53

GGSCI (localhost.localdomain) 26> start AWEN_PMP

Sending START request to MANAGER ...
EXTRACT AWEN_PMP starting

GGSCI (localhost.localdomain) 27> info all

Program Status Group Lag at Chkpt Time Since Chkpt

MANAGER RUNNING
EXTRACT RUNNING AWEN_EXT 00:00:00 00:00:02
EXTRACT RUNNING AWEN_PMP 00:00:00 00:00:05
REPLICAT STOPPED AWEN_REP 00:00:00 00:05:22

GGSCI (localhost.localdomain) 28> start AWEN_REP

Sending START request to MANAGER ...
REPLICAT AWEN_REP starting

GGSCI (localhost.localdomain) 29> info all

Program Status Group Lag at Chkpt Time Since Chkpt

MANAGER RUNNING
EXTRACT RUNNING AWEN_EXT 00:00:00 00:00:08
EXTRACT RUNNING AWEN_PMP 00:00:00 00:00:10
REPLICAT RUNNING AWEN_REP 00:00:00 00:00:09

GGSCI (localhost.localdomain) 30>

[oracle@localhost dirdat]$ ls
va000000 vb000000
[oracle@localhost dirdat]$ pwd
/u01/ogg/ogghome/dirdat
[oracle@localhost dirdat]$[/code]
配置完成之后，进程正常运行，并生成队列文件。
下一节是ogg的简单数据同步测试。