ORA-00600 (17183、729)
2014-03-17 19:54:13ERROR OGG-02028Oracle 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:13ERROR OGG-01668Oracle GoldenGate Capture for Oracle, lin.prm:PROCESS ABENDING.
2014-03-17 19:54:19ERROR OGG-00664Oracle GoldenGate Capture for Oracle, lin.prm:OCI Error end oci session (status = 600-ORA-00600: internal error code, arguments: , , [], [], [], [], [], [], [], [], [], []
ORA-00600: internal error code, arguments: , , , [], [], [], [], [], [], [], [], []).
信息不全！说明 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
$ ./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-02028Oracle 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操作引起的异常？求解。 从新配置吧 :D 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:01INFO OGG-00992Oracle GoldenGate Capture for Oracle, lin.prm:EXTRACT LIN starting.
2014-03-17 22:44:01INFO OGG-03059Oracle GoldenGate Capture for Oracle, lin.prm:Operating system character set identified as UTF-8.
2014-03-17 22:44:01INFO OGG-02695Oracle GoldenGate Capture for Oracle, lin.prm:ANSI SQL parameter syntax is used for parameter parsing.
2014-03-17 22:44:01INFO OGG-02095Oracle GoldenGate Capture for Oracle, lin.prm:Successfully set environment variable NLS_LANG=AMERICAN_AMERICA.ZHS16GBK.
2014-03-17 22:44:06INFO OGG-03522Oracle GoldenGate Capture for Oracle, lin.prm:Setting session time zone to source database time zone 'GMT'.
2014-03-17 22:44:06INFO OGG-02623Oracle 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:06INFO OGG-02623Oracle 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:06INFO OGG-01815Oracle 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:06INFO OGG-01851Oracle GoldenGate Capture for Oracle, lin.prm:filecaching started: thread ID: 140584356452096.
2014-03-17 22:44:06INFO OGG-01815Oracle 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:06INFO OGG-06495Oracle GoldenGate Capture for Oracle, lin.prm:OGG created a session pool with SESSIONPOOLMAX 10, SESSIONPOOLMIN 2 and SESSIONPOOLINCR 2.
2014-03-17 22:44:06WARNING OGG-01423Oracle GoldenGate Capture for Oracle, lin.prm:No valid default archive log destination directory found for thread 1.
2014-03-17 22:44:06INFO OGG-02089Oracle GoldenGate Capture for Oracle, lin.prm:Source redo compatibility version is: 12.1.0.0.
2014-03-17 22:44:23WARNING OGG-02045Oracle GoldenGate Capture for Oracle, lin.prm:Database does not have streams_pool_size initialization parameter configured.
2014-03-17 22:44:36INFO OGG-02068Oracle GoldenGate Capture for Oracle, lin.prm:Integrated capture successfully attached to logmining server OGG$CAP_LIN using OGGCapture API.
2014-03-17 22:44:37INFO OGG-02086Oracle GoldenGate Capture for Oracle, lin.prm:Integrated Dictionary will be used.
2014-03-17 22:44:37INFO OGG-00993Oracle GoldenGate Capture for Oracle, lin.prm:EXTRACT LIN started.
2014-03-17 22:44:39INFO OGG-01055Oracle GoldenGate Capture for Oracle, lin.prm:Recovery initialization completed for target file ./dirdat/zi000003, at RBA 1463.
2014-03-17 22:45:27WARNING OGG-01223Oracle GoldenGate Capture for Oracle, lin.prm:TCP/IP error 111 (Connection refused), endpoint: goldengate2:7809.
2014-03-17 22:46:14INFO OGG-01226Oracle GoldenGate Capture for Oracle, lin.prm:Socket buffer size set to 27985 (flush size 27985).
2014-03-17 22:46:15INFO OGG-01230Oracle GoldenGate Capture for Oracle, lin.prm:Recovered from TCP error, host goldengate2, port 7820.
2014-03-17 22:46:16INFO OGG-01055Oracle GoldenGate Capture for Oracle, lin.prm:Recovery initialization completed for target file ./dirdat/zq000003, at RBA 1463.
2014-03-17 22:46:17INFO OGG-01478Oracle GoldenGate Capture for Oracle, lin.prm:Output file ./dirdat/zi is using format RELEASE 12.1.
2014-03-17 22:46:17INFO OGG-01478Oracle GoldenGate Capture for Oracle, lin.prm:Output file ./dirdat/zq is using format RELEASE 12.1.
2014-03-17 22:46:18INFO OGG-01026Oracle GoldenGate Capture for Oracle, lin.prm:Rolling over remote file ./dirdat/zi000003.
2014-03-17 22:46:28INFO OGG-01053Oracle GoldenGate Capture for Oracle, lin.prm:Recovery completed for target file ./dirdat/zi000004, at RBA 1463.
2014-03-17 22:46:28INFO OGG-01026Oracle GoldenGate Capture for Oracle, lin.prm:Rolling over remote file ./dirdat/zq000004.
2014-03-17 22:46:28INFO OGG-01053Oracle GoldenGate Capture for Oracle, lin.prm:Recovery completed for target file ./dirdat/zq000004, at RBA 1405.
2014-03-17 22:46:28INFO OGG-01057Oracle GoldenGate Capture for Oracle, lin.prm:Recovery completed for all targets.
2014-03-17 22:46:37INFO OGG-03522Oracle GoldenGate Capture for Oracle, lin.prm:Setting session time zone to source database time zone 'GMT' :(
页:
[1]