OGG-02022

2^#

发表于 2013-11-4 10:05:33

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

3^#

发表于 2013-11-4 10:06:44

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.

4^#

发表于 2013-11-4 10:20:20

action plan:

sqlplus / as sysdba
show parameter compat

5^#

发表于 2013-11-4 10:26:50

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

6^#

发表于 2013-11-4 13:01:09

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

7^#

发表于 2013-11-4 13:36:59

已修改，还是报OGG-02022

8^#

发表于 2013-11-4 16:23:46

至少说明如何修改的，效果如何，报错的具体信息吧？

9^#

发表于 2013-11-5 09:16:29

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^#

发表于 2013-11-5 09:17:30

这个是昨天上午10点多说到了参数的时候，就已经修改了

mql535

11^#

发表于 2013-11-5 09:29:20

http://dbzone.iteye.com/blog/1042455 我想这个文档对于修改及验证compatible有一定的帮助