请选择 进入手机版 | 继续访问电脑版

ORACLE SOS

 找回密码
 立即注册

QQ登录

只需一步,快速开始

搜索
查看: 4671|回复: 9

ORA-00600 (17183、729)

[复制链接]

3

主题

15

帖子

55

积分

注册会员

Rank: 2

积分
55
发表于 2014-3-17 20:28:59 | 显示全部楼层 |阅读模式
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], [], [], [], [], [], [], [], [], []).


本帖子中包含更多资源

您需要 登录 才可以下载或查看,没有帐号?立即注册

x
回复

使用道具 举报

4

主题

46

帖子

259

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
259
发表于 2014-3-17 21:43:33 | 显示全部楼层
信息不全!说明 ogg版本!db 版本 ,alert日志,trace文件
-------------------------------------------
Travel
长路漫漫, 所思在远道
Email:travel.liu@outlook.com
www.traveldba.com
--------------------------------------------
回复 支持 反对

使用道具 举报

3

主题

15

帖子

55

积分

注册会员

Rank: 2

积分
55
 楼主| 发表于 2014-3-17 21:47:26 | 显示全部楼层
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.
回复 支持 反对

使用道具 举报

3

主题

15

帖子

55

积分

注册会员

Rank: 2

积分
55
 楼主| 发表于 2014-3-17 21:49:39 | 显示全部楼层
之前对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操作引起的异常?求解。
回复 支持 反对

使用道具 举报

4

主题

46

帖子

259

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
259
发表于 2014-3-17 21:53:08 | 显示全部楼层
从新配置吧
-------------------------------------------
Travel
长路漫漫, 所思在远道
Email:travel.liu@outlook.com
www.traveldba.com
--------------------------------------------
回复 支持 反对

使用道具 举报

3

主题

15

帖子

55

积分

注册会员

Rank: 2

积分
55
 楼主| 发表于 2014-3-17 21:54:10 | 显示全部楼层
MOS上查的结果。

本帖子中包含更多资源

您需要 登录 才可以下载或查看,没有帐号?立即注册

x
回复 支持 反对

使用道具 举报

3

主题

15

帖子

55

积分

注册会员

Rank: 2

积分
55
 楼主| 发表于 2014-3-17 21:55:06 | 显示全部楼层
看来是要重新配置了,主要不知道到底是因为啥导致的错误,(+﹏+)~狂晕
回复 支持 反对

使用道具 举报

3

主题

15

帖子

55

积分

注册会员

Rank: 2

积分
55
 楼主| 发表于 2014-3-17 23:02:52 | 显示全部楼层
按着如下步骤已经解决:
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'
回复 支持 反对

使用道具 举报

本版积分规则

QQ|手机版|Archiver|ORACLE SOS 技术论坛  

GMT+8, 2019-11-12 19:30 , Processed in 0.117374 second(s), 28 queries .

Powered by Discuz! X3.2

© 2001-2013 Comsenz Inc.

快速回复 返回顶部 返回列表