[Oracle数据库] 【GoldenGate】ERROR OGG-00446 ,ERROR OGG-01668

一、故障说明 配置好OGG的抽取进程后，启动时报错（如下），根据下面红色报错信息得知不能打开redo log /u01/app/oracle/product/11.2.0/db/dbs/arch1_12_896804745.dbf文件，此时大家应该能反映出两种可能，要不文件不存在，要不文件存在却无法访问。通过查询，发现文件确定存在，应该是无法访问导致。此时可以确认是权限问题。让我们去处理问题吧。  错误日志：http://www.kmnk03.com/hxpfk/tf/344.html 2015-11-27 15:25:40 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (ogg): start eora. 2015-11-27 15:25:40 INFO OGG-00963 Oracle GoldenGate Manager for Oracle, mgr.prm: Command received from GGSCI on host test2 (START EXTRACT EORA ). 2015-11-27 15:25:40 INFO OGG-00975 Oracle GoldenGate Manager for Oracle,http://www.kmnk03.com/hxpfk/tf/345.html mgr.prm: EXTRACT EORA starting. 2015-11-27 15:25:40 INFO OGG-00992 Oracle GoldenGate Capture for Oracle, eora.prm: EXTRACT EORA starting. 2015-11-27 15:25:40 INFO OGG-03035 http://www.kmnk03.com/hxpfk/tf/346.htmlOracle GoldenGate Capture for Oracle, eora.prm: Operating system character set identified as UTF-8. Locale: en_US, LC_ALL:. 2015-11-27 15:25:40 INFO OGG-03500 Oracle GoldenGate Capture for Oracle, eora.prm: WARNING: NLS_LANG environmenthttp://www.kmnk03.com/hxpfk/tx/347.html variable does not match database character set, or not set. Using database character set value of ZHS16GBK. 2015-11-27 15:25:40 INFO OGG-01635 Oracle GoldenGate Capture for Oracle, eora.prm: BOUNDED RECOVERY: reset to initial or altered checkpoint. 2015-11-27 15:25:40 INFO OGG-01815 Oracle GoldenGate Capture for Oracle, eora.prm: Virtual Memory Facilities for: BR anon alloc: mmap(MAP_ANON) anon free:http://www.kmnk03.com/hxpfk/tx/348.html munmap file alloc: mmap(MAP_SHARED) file free: munmap target directories: /home/ogg/BR/EORA. 2015-11-27 15:25:40 INFO OGG-01815 Oracle GoldenGate Capture for Oracle, eora.prm: Virtual Memory Facilities for: COM anon alloc: mmap(MAP_ANON) anon free: munmap file alloc: mmap(MAP_SHARED) file free: munmap target directories: /home/ogg/dirtmp. 2015-11-27 15:25:41 INFO OGG-01515 Oracle GoldenGate Capture for Oracle, eora.prm: Positioning to begin time Nov 27, 2015 3:07:04 PM. 2015-11-27 15:26:01 ERROR OGG-00446 Oracle GoldenGate Capture for http://www.kmnk01.com/hxpfk/2015/tf_1220/322.htmlOracle, eora.prm: error 13 (Permission denied) opening redo log /u01/app/oracle/product/11.2.0/db/dbs/arch1_12_896804745.dbf for sequence 12Not able to establish initial position for begin time 2015-11-27 15:07:04. 2015-11-27 15:26:01 ERROR OGG-01668 Oracle GoldenGate Capture for Oracle, eora.prm: PROCESS ABENDING.  二、故障处理： [oracle@test2 TESTDB]$ ls -l redo* -rw-r-----. 1 oracle oinstall 524288512 Nov 27 14:44 redo04.log -rw-r-----. 1 oracle oinstall 524288512 Nov 27 15:39 redo05.log -rw-r-----. 1 oracle oinstall 524288512 Nov 27 14:44 redo06.log  [oracle@test2 dbshttp://www.kmnk01.com/hxpfk/2015/tf_1220/323.html]$ ls -l arch* -rw-r-----. 1 oracle oinstall 44121600 Nov 27 15:05 arch1_11_896804745.dbf -rw-r-----. 1 oracle oinstall 3210240 Nov 27 15:16 arch1_12_896804745.dbf -rw-r-----. 1 oracle oinstall 1024 Nov 27 15:16 arch1_13_896804745.dbf -rw-r-----. 1 oracle oinstall 7168 Nov 27 15:16 arch1_14_896804745.dbf  [root@test2 ~]http://www.kmnk01.com/hxpfk/2015/tf_1220/324.html# usermod -g oinstall ogg [root@test2 ~]# id ogg uid=503(ogg) gid=501(oinstall) groups=501(oinstall),502(dba),601(ogg)  GGSCI (test2) 5> stop mgr Manager process is required by other GGS processes. Are you sure you want to stop it (y/n)? y  Sending STOP request to MANAGER ... Request processed. Manager stopped.  GGSCI (test2) 6> start mgr  Manager started.  GGSCI (test2) 7> info all  Program Statushttp://www.kmnk01.com/hxpfk/2015/hzj_1220/325.html Group Lag at Chkpt Time Since Chkpt  MANAGER RUNNING EXTRACT STOPPED EORA 00:00:00 00:25:22 EXTRACT STOPPED PORA 00:00:00 00:58:49  GGSCI (test2) 8> start eora  Sending START request to MANAGER ... EXTRACT EORA starting  GGSCI (test2) 9> info all  Program Status Group Lag at Chkpt Time Since Chkpt  MANAGER RUNNING EXTRACT RUNNING EORA 00:25:34 00:00:00 EXTRACT STOPPED PORA 00:00:00 00:59:01  GGSCI (test2) 10> info all  Program Status Group Lag at Chkpt Time Since Chkpt  MANAGER RUNNING EXTRACT RUNNING EORA 00:00:00 00:00:06 EXTRACT STOPPED PORA 00:00:00 01:07:21  [ogg@test2 dirdat]$ ls -l total 4 -rw-rw-rw-. 1 ogg oinstall 1007 Nov 27 15:32 et000000  2015-11-27 15:32:37 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (ogg): start eora. 2015-11-27 15:32:37 INFO OGG-00963 Oracle GoldenGate Manager for Oracle, mgr.prm: Command received from GGSCI on host test2 (START EXTRACT EORA ). 2015-11-27 15:32:37 INFO OGG-00975 Oracle GoldenGate Manager for Oracle, mgr.prm: EXTRACT EORA starting. 2015-11-27 15:32:38 INFO OGG-00992 Oracle GoldenGate Capture for Oracle, eora.prm: EXTRACT EORA starting. 2015-11-27 15:32:38 INFO OGG-03035 Oracle GoldenGate Capture for Oracle, eora.prm: Operating system character set identified as UTF-8http://www.kmnk01.com/hxpfk/2015/hzj_1220/326.html. Locale: en_US, LC_ALL:. 2015-11-27 15:32:38 INFO OGG-03500 Oracle GoldenGate Capture for Oracle, eora.prm: WARNING: NLS_LANG environment variable does not match database character set, or not set. Using database character set value of ZHS16GBK. 2015-11-27 15:32:38 INFO OGG-01635 Oracle GoldenGate Capture for Oracle, eora.prm: BOUNDED RECOVERY: reset to initial or altered checkpoint. 2015-11-27 15:32:38 INFO OGG-01815 Oracle GoldenGate Capture for Oracle, eora.prm: Virtual Memory Facilities for: BR anon alloc: mmap(MAP_ANON) anon free: munmap file alloc: mmap(MAP_SHARED) file free: munmap target directories: /home/ogg/BR/EORA. 2015-11-27 15:32:38 INFO OGG-01815 Oracle GoldenGate Capture for Oracle, eora.prm: Virtual Memory Facilities for: COM anon alloc: mmap(MAP_ANON) anon free: munmap file alloc: mmap(MAP_SHARED) file free: munmap target directories: /home/ogg/dirtmp. 2015-11-27 15:32:38 INFO OGG-01515 Oracle GoldenGate Capture for Oracle, eora.prm: Positioning to begin time Nov 27, 2015 3:07:04 PM. 2015-11-27 15:32:38 INFO OGG-01516 Oracle GoldenGate Capture for Oracle, eora.prm: Positioned to Sequence 12, RBA 1453568, SCN 0.0, Nov 27, 2015 3:07:04 PM. 2015-11-27 15:32:38 INFO OGG-00993 Oracle GoldenGate Capture for Oracle, eora.prm: EXTRACT EORA started. 2015-11-27 15:32:38 INFO OGG-01052 Oracle GoldenGate Capture for Oracle, eora.prm: No recovery is required for target file ./dirdat/et000000, at RBA 0 (file not opened). 2015-11-27 15:32:38 INFO OGG-01478 Oracle GoldenGate Capture for Oracle, eora.prm: Output file ./dirdat/et is using format RELEASE 11.2. 2015-11-27 15:32:38 INFO OGG-01517 Oracle GoldenGate Capture for Oracle, eora.prm: Position of first record processed Sequence 12, RBA 1453584, SCN 0.1100123, Nov 27, 2015 3:07:06 PM.  三、总结 此次故障对于细心的朋友们是不会出现的，还是因为在建立ogg用户后没有即时分配对应权限导致。相信在这里摔过跟头的朋友们都会长个大经验。 Where there’s a will, there ’s a way.  kmnk01.com kmnk03.com www.knmk01.com] www.kmnk03.com]