1.
[oracle@ora1 ~]$ 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 10g on Apr 23 2012 07:30:46
Copyright (C) 1995, 2012, Oracle and/or its affiliates. All rights reserved.
GGSCI (ora1) 1> dblogin userid ggs,password ggs Cannot load ICU resource bundle 'ggMessage', error code 2 - No such file or directory Cannot load ICU resource bundle 'ggMessage', error code 2 - No such file or directory rlwrap: warning: ggsci killed by SIGABRT. rlwrap has not crashed, but for transparency, it will now kill itself (without dumping core)with the same signal
Aborted
需要在ggs的HOME目录下执行ggsci,在其他位置执行会报错,找不到文件或是目录
[oracle@ora1 ogg]$ 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 10g on Apr 23 2012 07:30:46
Copyright (C) 1995, 2012, Oracle and/or its affiliates. All rights reserved.
GGSCI (ora1) 1> dblogin userid ggs, password ggs Successfully logged into database.
GGSCI (ora1) 2>
2. start mgr 服务启不来查看日志ggserr.log
2014-08-10 23:26:00 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): start mgr. 2014-08-10 23:26:00 ERROR OGG-01091 Oracle GoldenGate Manager for Oracle, mgr.prm: Unable to open file "/home/oracle/ogg/dirrpt/MGR.rpt" (error 2, No such file or directory). 2014-08-10 23:26:00 ERROR OGG-01668 Oracle GoldenGate Manager for Oracle, mgr.prm: PROCESS ABENDING.
用create subdirs 自动增加所有的目录
GGSCI (ora1) 1> create subdirs
Creating subdirectories under current directory /home/oracle/ogg
Parameter files /home/oracle/ogg/dirprm: already exists Report files /home/oracle/ogg/dirrpt: created Checkpoint files /home/oracle/ogg/dirchk: created Process status files /home/oracle/ogg/dirpcs: created SQL script files /home/oracle/ogg/dirsql: created Database definitions files /home/oracle/ogg/dirdef: created Extract data files /home/oracle/ogg/dirdat: created Temporary files /home/oracle/ogg/dirtmp: created Stdout files /home/oracle/ogg/dirout: created
GGSCI (ora1) 2> start mgr
Manager started.
GGSCI (ora1) 3> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING

发表评论