OGG-02022
在做OGG Integrated Mode的时候出现了OGG-02022的报错，配置步骤和报错在附件中，麻烦各位看看是什么原因？ 2013-11-04 09:39:36 WARNING OGG-02064 Oracle GoldenGate Capture for Oracle, ext1.prm: Oracle compatibility version 11.2.0.0.0 has limited datatype support for integrated capture. Version 11.2.0.3 required for full support.2013-11-04 09:39:36 ERROR OGG-02022 Oracle GoldenGate Capture for Oracle, ext1.prm: Logmining server does not exist on this Oracle database.
2013-11-04 09:39:36 ERROR OGG-01668 Oracle GoldenGate Capture for Oracle, ext1.prm: PROCESS ABENDING.
action plan:
sqlplus / as sysdba
show parameter compat MOS中note 1411356.1文档中介绍
For non-Exadata customers, the MLR bug number for OGG/RDBMS patches for IE that we call bp17 is
11.2.0.3.0 16764834 Patch MLR
我的数据库版本是11.2.0.3，也试过BP16764834，还是报OGG-02022. action plan:
sqlplus / as sysdba
show parameter compat
SQL> show parameter com
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
cell_offload_compaction string ADAPTIVE
commit_logging string
commit_point_strength integer 1
commit_wait string
commit_write string
compatible string 11.2.0.0.0
nls_comp string BINARY
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
plsql_v2_compatibility boolean FALSE Oracle compatibility version 11.2.0.0.0 has limited datatype support for integrated capture. Version 11.2.0.3 required for full support.
你的compatible string 11.2.0.0.0
需要compatible 》=11.2.0.3 已修改，还是报OGG-02022 至少说明如何修改的， 效果如何， 报错的具体信息吧？ SQL> alter system set compatible='11.2.0.3.0' scope=spfile;
System altered.
SQL> shutdown immediate
Database closed.
Database dismounted.
startup
ORACLE instance shut down.
SQL> ORACLE instance started.
Total System Global Area 1.6034E+10 bytes
Fixed Size 2237328 bytes
Variable Size 2181041264 bytes
Database Buffers 1.3824E+10 bytes
Redo Buffers 26509312 bytes
Database mounted.
Database opened.
SQL>
GGSCI (pwr750g1) 2> start ext1
Sending START request to MANAGER ...
EXTRACT EXT1 starting
2013-11-04 11:53:45 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (oracle): start ext1.
2013-11-04 11:53:45 INFO OGG-00963 Oracle GoldenGate Manager for Oracle, mgr.prm: Command received from GGSCI on host pwr750g1 (START EXTRACT EXT1 ).
2013-11-04 11:53:45 INFO OGG-00975 Oracle GoldenGate Manager for Oracle, mgr.prm: EXTRACT EXT1 starting.
2013-11-04 11:53:45 INFO OGG-00992 Oracle GoldenGate Capture for Oracle, ext1.prm: EXTRACT EXT1 starting.
2013-11-04 11:53:45 INFO OGG-03035 Oracle GoldenGate Capture for Oracle, ext1.prm: Operating system character set identified as ISO-8859-1. Locale: en_US, LC_ALL:.
2013-11-04 11:53:45 INFO OGG-03500 Oracle GoldenGate Capture for Oracle, ext1.prm: WARNING: NLS_LANG environment variable does not match database character set, or not set. Using database character set value of ZHS16GBK.
2013-11-04 11:53:45 INFO OGG-01635 Oracle GoldenGate Capture for Oracle, ext1.prm: BOUNDED RECOVERY: reset to initial or altered checkpoint.
2013-11-04 11:53:45 INFO OGG-01815 Oracle GoldenGate Capture for Oracle, ext1.prm: Virtual Memory Facilities for: BR
anon alloc: mmap(MAP_ANON) anon free: munmap
file alloc: mmap(MAP_SHARED) file free: munmap
target directories:
/oracle/ogg/BR/EXT1.
2013-11-04 11:53:45 INFO OGG-01815 Oracle GoldenGate Capture for Oracle, ext1.prm: Virtual Memory Facilities for: COM
anon alloc: mmap(MAP_ANON) anon free: munmap
file alloc: mmap(MAP_SHARED) file free: munmap
target directories:
/oracle/ogg/dirtmp.
2013-11-04 11:53:46 ERROR OGG-02022 Oracle GoldenGate Capture for Oracle, ext1.prm: Logmining server does not exist on this Oracle database.
2013-11-04 11:53:46 ERROR OGG-01668 Oracle GoldenGate Capture for Oracle, ext1.prm: PROCESS ABENDING. 这个是昨天上午10点多说到了参数的时候，就已经修改了 http://dbzone.iteye.com/blog/1042455 我想这个文档对于修改及验证compatible有一定的帮助
页:
[1]