ORA-00600 (17183、729)

玉树林风

2014-03-17 19:54:13  ERROR   OGG-02028  Oracle GoldenGate Capture for Oracle, lin.prm:  Failed to attach to logmining server Error code 1405, error message: ORA-01405: fetched column value is NULL.
2014-03-17 19:54:13  ERROR   OGG-01668  Oracle GoldenGate Capture for Oracle, lin.prm:  PROCESS ABENDING.
2014-03-17 19:54:19  ERROR   OGG-00664  Oracle GoldenGate Capture for Oracle, lin.prm:  OCI Error end oci session (status = 600-ORA-00600: internal error code, arguments: [17183], [0x7FA443F18178], [], [], [], [], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [729], [20800], [space leak], [], [], [], [], [], [], [], [], []).

travel.liu

信息不全！说明 ogg版本！db 版本 ,alert日志,trace文件

玉树林风

SQL> select * from v$version;

BANNER
--------------------------------------------------------------------------------
    CON_ID
----------
Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production
         0

PL/SQL Release 12.1.0.1.0 - Production
         0

CORE        12.1.0.1.0        Production
         0


BANNER
--------------------------------------------------------------------------------
    CON_ID
----------
TNS for Linux: Version 12.1.0.1.0 - Production
         0

NLSRTL Version 12.1.0.1.0 - Production


GGSCI (goldengate1) 13> exit
[oracle@goldengate1 software]$ ./ggsci

Oracle GoldenGate Command Interpreter for Oracle
Version 12.1.2.0.0 17185003 OGGCORE_12.1.2.0.0_PLATFORMS_130924.1316_FBO
Linux, x64, 64bit (optimized), Oracle 12c on Sep 25 2013 02:33:54
Operating system character set identified as UTF-8.

玉树林风

之前对goldengatetest11 pdb数据库做过unplumb操作，然后通过xml文件还原了该pdb数据库，并且实例是打开的。后发现ERROR   OGG-02028  Oracle GoldenGate Capture for Oracle, lin.prm:  Failed to attach to logmining server Error code 1405, error message: ORA-01405: fetched column value is NULL.
于是检查pdb下对应的我的scott表，没有数据，重新执行utlsamp.sql，再查询数据有了。之前启动extract进程没事，难道这次是unplumb操作引起的异常？求解。

travel.liu

从新配置吧

玉树林风

MOS上查的结果。

玉树林风

看来是要重新配置了，主要不知道到底是因为啥导致的错误，(+﹏+)~狂晕

玉树林风

按着如下步骤已经解决：
GGSCI (goldengate1) 2> dblogin userid C##OGG,PASSWORD Ogg
Successfully logged into database CDB$ROOT.

GGSCI (goldengate1) 3> unregister extract lin database
Successfully unregistered EXTRACT LIN from database.


GGSCI (goldengate1) 4> register extract lin database
ERROR: One or more containers must be specified when registering Extract for a container database.


GGSCI (goldengate1) 5> register extract lin database
ERROR: One or more containers must be specified when registering Extract for a container database.


GGSCI (goldengate1) 6> register extract lin database container(goldengatetest11)
Extract LIN successfully registered with database at SCN 2955330.


GGSCI (goldengate1) 7> add extract lin,integrated tranlog,begin now
ERROR: EXTRACT LIN already exists.


GGSCI (goldengate1) 8> delete extract lin
Deleted EXTRACT LIN.


GGSCI (goldengate1) 9> add extract lin,integrated tranlog,begin now
EXTRACT added.


GGSCI (goldengate1) 10> start extract lin

Sending START request to MANAGER ...
EXTRACT LIN starting


GGSCI (goldengate1) 11> add extrail ./dirdat/zi,extract lin
ERROR: Invalid command.

GGSCI (goldengate1) 12> add exttrail ./dirdat/zi,extract lin
EXTTRAIL added.


GGSCI (goldengate1) 13> start extract lin

Sending START request to MANAGER ...
EXTRACT LIN starting


GGSCI (goldengate1) 14> ADD EXTTRAIL/RMTTRAIL ./dirdat/zq, EXTRACT LIN
ERROR: Invalid command.

GGSCI (goldengate1) 15> add rmttrail ./dirdat/zq,extract lin
RMTTRAIL added.


GGSCI (goldengate1) 16> start extract lin

Sending START request to MANAGER ...
EXTRACT LIN starting


成功源端日志：
2014-03-17 22:44:01  INFO    OGG-00992  Oracle GoldenGate Capture for Oracle, lin.prm:  EXTRACT LIN starting.
2014-03-17 22:44:01  INFO    OGG-03059  Oracle GoldenGate Capture for Oracle, lin.prm:  Operating system character set identified as UTF-8.
2014-03-17 22:44:01  INFO    OGG-02695  Oracle GoldenGate Capture for Oracle, lin.prm:  ANSI SQL parameter syntax is used for parameter parsing.
2014-03-17 22:44:01  INFO    OGG-02095  Oracle GoldenGate Capture for Oracle, lin.prm:  Successfully set environment variable NLS_LANG=AMERICAN_AMERICA.ZHS16GBK.
2014-03-17 22:44:06  INFO    OGG-03522  Oracle GoldenGate Capture for Oracle, lin.prm:  Setting session time zone to source database time zone 'GMT'.
2014-03-17 22:44:06  INFO    OGG-02623  Oracle GoldenGate Capture for Oracle, lin.prm:  Default source catalog name goldengatetest11 will be used for source table name scott.emp mapping.
2014-03-17 22:44:06  INFO    OGG-02623  Oracle GoldenGate Capture for Oracle, lin.prm:  Default source catalog name goldengatetest11 will be used for source table name scott.dept mapping.
2014-03-17 22:44:06  INFO    OGG-01815  Oracle GoldenGate Capture for Oracle, lin.prm:  Virtual Memory Facilities for: BR
    anon alloc: mmap(MAP_ANON)  anon free: munmap
    file alloc: mmap(MAP_SHARED)  file free: munmap
    target directories:
    /goldengate/software/BR/LIN.
2014-03-17 22:44:06  INFO    OGG-01851  Oracle GoldenGate Capture for Oracle, lin.prm:  filecaching started: thread ID: 140584356452096.
2014-03-17 22:44:06  INFO    OGG-01815  Oracle GoldenGate Capture for Oracle, lin.prm:  Virtual Memory Facilities for: COM
    anon alloc: mmap(MAP_ANON)  anon free: munmap
    file alloc: mmap(MAP_SHARED)  file free: munmap
    target directories:
    /goldengate/software/dirtmp.
2014-03-17 22:44:06  INFO    OGG-06495  Oracle GoldenGate Capture for Oracle, lin.prm:  OGG created a session pool with SESSIONPOOLMAX 10, SESSIONPOOLMIN 2 and SESSIONPOOLINCR 2.
2014-03-17 22:44:06  WARNING OGG-01423  Oracle GoldenGate Capture for Oracle, lin.prm:  No valid default archive log destination directory found for thread 1.
2014-03-17 22:44:06  INFO    OGG-02089  Oracle GoldenGate Capture for Oracle, lin.prm:  Source redo compatibility version is: 12.1.0.0.
2014-03-17 22:44:23  WARNING OGG-02045  Oracle GoldenGate Capture for Oracle, lin.prm:  Database does not have streams_pool_size initialization parameter configured.
2014-03-17 22:44:36  INFO    OGG-02068  Oracle GoldenGate Capture for Oracle, lin.prm:  Integrated capture successfully attached to logmining server OGG$CAP_LIN using OGGCapture API.
2014-03-17 22:44:37  INFO    OGG-02086  Oracle GoldenGate Capture for Oracle, lin.prm:  Integrated Dictionary will be used.
2014-03-17 22:44:37  INFO    OGG-00993  Oracle GoldenGate Capture for Oracle, lin.prm:  EXTRACT LIN started.
2014-03-17 22:44:39  INFO    OGG-01055  Oracle GoldenGate Capture for Oracle, lin.prm:  Recovery initialization completed for target file ./dirdat/zi000003, at RBA 1463.
2014-03-17 22:45:27  WARNING OGG-01223  Oracle GoldenGate Capture for Oracle, lin.prm:  TCP/IP error 111 (Connection refused), endpoint: goldengate2:7809.
2014-03-17 22:46:14  INFO    OGG-01226  Oracle GoldenGate Capture for Oracle, lin.prm:  Socket buffer size set to 27985 (flush size 27985).
2014-03-17 22:46:15  INFO    OGG-01230  Oracle GoldenGate Capture for Oracle, lin.prm:  Recovered from TCP error, host goldengate2, port 7820.
2014-03-17 22:46:16  INFO    OGG-01055  Oracle GoldenGate Capture for Oracle, lin.prm:  Recovery initialization completed for target file ./dirdat/zq000003, at RBA 1463.
2014-03-17 22:46:17  INFO    OGG-01478  Oracle GoldenGate Capture for Oracle, lin.prm:  Output file ./dirdat/zi is using format RELEASE 12.1.
2014-03-17 22:46:17  INFO    OGG-01478  Oracle GoldenGate Capture for Oracle, lin.prm:  Output file ./dirdat/zq is using format RELEASE 12.1.
2014-03-17 22:46:18  INFO    OGG-01026  Oracle GoldenGate Capture for Oracle, lin.prm:  Rolling over remote file ./dirdat/zi000003.
2014-03-17 22:46:28  INFO    OGG-01053  Oracle GoldenGate Capture for Oracle, lin.prm:  Recovery completed for target file ./dirdat/zi000004, at RBA 1463.
2014-03-17 22:46:28  INFO    OGG-01026  Oracle GoldenGate Capture for Oracle, lin.prm:  Rolling over remote file ./dirdat/zq000004.
2014-03-17 22:46:28  INFO    OGG-01053  Oracle GoldenGate Capture for Oracle, lin.prm:  Recovery completed for target file ./dirdat/zq000004, at RBA 1405.
2014-03-17 22:46:28  INFO    OGG-01057  Oracle GoldenGate Capture for Oracle, lin.prm:  Recovery completed for all targets.
2014-03-17 22:46:37  INFO    OGG-03522  Oracle GoldenGate Capture for Oracle, lin.prm:  Setting session time zone to source database time zone 'GMT'

travel.liu