开发者

Oracle Golden Gate Replicat : GGS ERROR 171 Unknown data type received <0x54 49>

开发者 https://www.devze.com 2023-02-25 08:50 出处:网络
I am trying to run an initial load as shown in the tutorial at http://www.oracle.com/webfolder/technetwork/tutorials/obe/fmw/goldengate/11g/GGS_Sect_Config_WinUX_ORA_to_WinUX_ORA.pdf and I am seeing t

I am trying to run an initial load as shown in the tutorial at http://www.oracle.com/webfolder/technetwork/tutorials/obe/fmw/goldengate/11g/GGS_Sect_Config_WinUX_ORA_to_WinUX_ORA.pdf and I am seeing this error in the REPLICAT process.

I have tried using the SOURCEDEFS clause as well (Even though the source and Target structures are exactly similar), but I run into the same issue.


** Run Time Messages **


2011-04-14 12:02:15 GGS ERROR 171 Unknown data type received <0x54 49>.

The only other Indication that I see in the report file is the following Warning message

2011-04-14 12:02:15 GGS WARNING 201 
Rounding up LOBWRITESIZE 32528 to be a multiple of LOB chunk size (16324).
    LOBWRITESIZE = 32648 bytes.

Here are the other details. If you need any more information, please let me know

***********************************************************************
GoldenGate Delivery for Oracle
Version v9.5.1.31 Build 003
HP-UX 11.23 (optimized 64-bit), Oracle 10g on Jun 24 2008 13:43:23
Copyright GoldenGate Software, Inc. 1995-2008

Starting at 2011-04-14 12:02:09
***********************************************************************

Database Version:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi
PL/SQL Release 10.2.0.4.0 - Production
CORE 10.2.0.4.0 Production
TNS for HPUX: Version 10.2.0.4.0 - Production
NLSRTL Version 10.2.0.4.0 - Production

These are the tables structures that I have created on the Source and Target, as given in the guide..

goldenga@:goldenga/>cat demo_ora_create.sql
-- Copyright (C) 2002, 2009, Oracle and/or its affiliates. All rights reserved.
--
-- demo_ora_create.sql
--
-- Oracle Tutorial
--
-- Description:
-- Create the TCUSTMER and TCUSTORD tables.
--
-- Note: execute this script from the command line as 
--"sqlplus userid/password @demo_ora_create.sql".
--

DROP TABLE tcustmer;
CREATE TABLE tcustmer
(
    cust_code        VARCHAR2(4),
    name             VARCHAR2(30),
    city             VARCHAR2(20),
    state     开发者_高级运维       CHAR(2),
    PRIMARY KEY (cust_code)
        USING INDEX
);

DROP TABLE tcustord;
CREATE TABLE tcustord
(
    cust_code        VARCHAR2(4),
    order_date       DATE,
    product_code     VARCHAR2(8),
    order_id         NUMBER,
    product_price    NUMBER(8,2),
    product_amount   NUMBER(6),
    transaction_id   NUMBER,
    PRIMARY KEY (cust_code, order_date, product_code, order_id)
        USING INDEX
);
goldenga@:goldenga/>cat demo_ora_insert.sql
-- Copyright (C) 2002, 2009, Oracle and/or its affiliates. All rights reserved.
--
-- demo_ora_insert.sql
--
-- Oracle Tutorial
--
-- Description:
-- Insert initial data into the TCUSTMER and TCUSTORD tables.
--
-- Note: execute this script from the command line as 
--"sqlplus userid/password @demo_ora_insert.sql"
--

INSERT INTO tcustmer
VALUES
(
    'WILL',
    'BG SOFTWARE CO.',
    'SEATTLE',
    'WA'
);

INSERT INTO tcustmer
VALUES
(
    'JANE',
    'ROCKY FLYER INC.',
    'DENVER',
    'CO'
);

INSERT INTO tcustord
VALUES
(
    'WILL',
    TO_DATE ('1994-09-30 15:33:00','YYYY-MM-DD HH24:MI:SS'),
    'CAR',
    144,
    17520,
    3,
    100
);

INSERT INTO tcustord
VALUES
(
    'JANE',
    TO_DATE ('1995-11-11 13:52:00','YYYY-MM-DD HH24:MI:SS'),
    'PLANE',
    256,
    133300,
    1,
    100
);

COMMIT;

I'd appreciate any advice on fixing this issue.

Thanks, Rajesh.


Looks like the error is because we have ASM set up at our place.. and I ignored this part of the tutorial Guide..

Note: When Oracle Automatic Storage Management (ASM) is in use, the TRANLOGOPTIONS ASMUSER and ASMPASSWORD must be set in the Extract parameter file. For more information refer to the GoldenGate for Windows & UNIX Administrator and Reference manuals.

Posting the reply here so that It'd be useful for anyone running into the same "issue" later.

Thanks for all the advice so far.!


check the initial load method of file to replicat from administrator guide of oracle golden gate. I hope this will solve your problem.

0

精彩评论

暂无评论...
验证码 换一张
取 消