Results 1 to 2 of 2

Thread: ORA-03137: malformed TTC packet from client rejected: [kpoal8Check-3] [32768] [0] [0x

  1. #1
    srinath is offline Junior Member
    Join Date
    Oct 2017
    Posts
    9
    Rep Power
    0

    ORA-03137: malformed TTC packet from client rejected: [kpoal8Check-3] [32768] [0] [0x

    hi ,
    i am getting below error when i start the process, please advise

    ORA-03137: malformed TTC packet from client rejected: [kpoal8Check-3] [32768] [0] [0x000000000] [789544] [] [] [] [1022307]

    00008040: 2018-08-01T04:35:18 [AT_GLOBAL ]I: Task Server Log (V5.5.0.283 amil-db.com Microsoft Windows Server 2012 (build 9200) 64-bit, PID: 3416) started at Wed Aug 01 04:35:18 2018 (at_logger.c:2426)
    00008040: 2018-08-01T04:35:18 [AT_GLOBAL ]I: Licensed to Attunity Replicate Express users (software license acceptance implied)Express license: You are running the Express Edition with reduced functionality (0 days remaining) (at_logger.c:2429)
    00008040: 2018-08-01T04:35:18 [SERVER ]I: Client session (ID 18557) allocated (dispatcher.c:274)
    00008040: 2018-08-01T04:35:18 [TASK_MANAGER ]I: Task 'SIT_LOAD_ENTITY' running CDC only in fresh start mode (replicationtask.c:1048)
    00008852: 2018-08-01T04:35:18 [TASK_MANAGER ]I: Task Id: ef7bd421-5295-444d-a7b2-aac16f27e676 (replicationtask.c:2578)
    00008852: 2018-08-01T04:35:18 [METADATA_MANAGE ]I: Going to connect to Oracle server (description=(address=(protocol=tcp)(host=22.X.X.X )(port=1521))(connect_data=(sid=XXX))) with username QQ_XXX (oracle_endpoint_imp.c:958)
    00008852: 2018-08-01T04:35:19 [METADATA_MANAGE ]I: Source endpoint 'Oracle' is using provider syntax 'Oracle' (provider_syntax_manager.c:579)
    00008852: 2018-08-01T04:35:19 [METADATA_MANAGE ]I: Target endpoint 'Oracle' is using provider syntax 'Oracle' (provider_syntax_manager.c:585)
    00008852: 2018-08-01T04:35:19 [TASK_MANAGER ]I: Creating threads for all components (replicationtask.c:1590)
    00008852: 2018-08-01T04:35:20 [TASK_MANAGER ]I: Threads for all components were created (replicationtask.c:1738)
    00008852: 2018-08-01T04:35:20 [TASK_MANAGER ]I: Task initialization completed successfully (replicationtask.c:2637)
    00006680: 2018-08-01T04:35:20 [SOURCE_CAPTURE ]I: Use any Oracle Archived Log Destination (oracle_endpoint_imp.c:723)
    00006680: 2018-08-01T04:35:20 [SOURCE_CAPTURE ]I: Oracle CDC uses LogMiner access mode (oracle_endpoint_imp.c:732)
    00006680: 2018-08-01T04:35:20 [SOURCE_CAPTURE ]I: retry timeout is '120' minutes (oracle_endpoint_imp.c:879)
    00006680: 2018-08-01T04:35:20 [SOURCE_CAPTURE ]I: Scale is set to 10 for NUMBER Datatype (oracle_endpoint_imp.c:901)
    00006680: 2018-08-01T04:35:20 [SOURCE_CAPTURE ]I: Retry interval is set to 5 (oracle_endpoint_imp.c:909)
    00006680: 2018-08-01T04:35:20 [SOURCE_CAPTURE ]I: Oracle database version is 12.1.0.2.0 (oracle_endpoint_conn.c:546)
    00006680: 2018-08-01T04:35:20 [SOURCE_CAPTURE ]I: Oracle compatibility version is 12.1.0.2.0 (oracle_endpoint_conn.c:86)
    00006680: 2018-08-01T04:35:21 [SOURCE_CAPTURE ]I: Standby database role is used. (oracle_endpoint_conn.c:136)
    00006680: 2018-08-01T04:35:21 [SOURCE_CAPTURE ]I: SUPPLEMENTAL_LOG_DATA_PK is set (oracle_endpoint_conn.c:146)
    00004764: 2018-08-01T04:35:21 [TARGET_APPLY ]I: Target endpoint 'Oracle' is using provider syntax 'Oracle' (provider_syntax_manager.c:585)
    00004764: 2018-08-01T04:35:21 [TARGET_APPLY ]I: Restore bulk state. Last bulk last record id - '0', last applied record id - '0', target confirmed record id - '0' (endpointshell.c:1413)
    00004764: 2018-08-01T04:35:21 [TARGET_APPLY ]I: Working in bulk apply mode (endpointshell.c:1420)
    00004764: 2018-08-01T04:35:22 [SOURCE_CAPTURE ]I: Source endpoint 'Oracle' is using provider syntax 'Oracle' (provider_syntax_manager.c:579)
    00008852: 2018-08-01T04:35:22 [TASK_MANAGER ]I: All stream components were initialized (replicationtask.c:2444)
    00006680: 2018-08-01T04:35:22 [SOURCE_CAPTURE ]I: Oracle capture start time: now (oracle_endpoint_capture.c:638)
    00008852: 2018-08-01T04:35:22 [TASK_MANAGER ]I: Starting subtask #1 (replicationtask_util.c:874)
    00008852: 2018-08-01T04:35:22 [TASK_MANAGER ]I: Starting subtask #2 (replicationtask_util.c:874)
    00008852: 2018-08-01T04:35:22 [TASK_MANAGER ]I: Starting subtask #3 (replicationtask_util.c:874)
    00008852: 2018-08-01T04:35:22 [TASK_MANAGER ]I: Starting subtask #4 (replicationtask_util.c:874)
    00008852: 2018-08-01T04:35:22 [TASK_MANAGER ]I: Starting subtask #5 (replicationtask_util.c:874)
    00006680: 2018-08-01T04:35:23 [SOURCE_CAPTURE ]I: Used Oracle archived Redo log destination id is '1' (oracdc_merger.c:543)
    00007816: 2018-08-01T04:35:23 [SOURCE_UNLOAD ]I: Standby database role is used. (oracle_endpoint_conn.c:136)
    00007816: 2018-08-01T04:35:23 [SOURCE_UNLOAD ]I: SUPPLEMENTAL_LOG_DATA_PK is set (oracle_endpoint_conn.c:146)
    00004072: 2018-08-01T04:35:23 [TARGET_LOAD ]I: Target endpoint 'Oracle' is using provider syntax 'Oracle' (provider_syntax_manager.c:585)
    00006680: 2018-08-01T04:35:23 [SOURCE_CAPTURE ]I: No opened transactions (oracle_endpoint_capture.c:852)
    00008444: 2018-08-01T04:35:23 [SORTER ]I: Transaction consistency reached (sorter_transaction.c:262)
    00008852: 2018-08-01T04:35:23 [TASK_MANAGER ]I: Starting replication now (replicationtask.c:2193)
    00004072: 2018-08-01T04:35:24 [SOURCE_CAPTURE ]I: Source endpoint 'Oracle' is using provider syntax 'Oracle' (provider_syntax_manager.c:579)
    00008444: 2018-08-01T04:35:24 [SORTER ]I: Start collecting changes for table id = 1 (sorter_transaction.c:1881)
    00008852: 2018-08-01T04:35:24 [TASK_MANAGER ]I: Start loading table 'SS'.'INST' (Id = 1) by subtask 1. Start load timestamp 0005725D407CD0C0 (replicationtask_util.c:1040)
    00006680: 2018-08-01T04:35:24 [SOURCE_CAPTURE ]I: New Log Miner boundaries in thread '1' : First REDO Sequence is '175', Last REDO Sequence is '175' (oracdc_reader.c:633)
    00008852: 2018-08-01T04:35:24 [TASK_MANAGER ]E: Task error notification received from subtask 0, thread 1 [1020401] (replicationtask.c:2272)
    00008852: 2018-08-01T04:35:24 [TASK_MANAGER ]W: Task 'SIT_LOAD_ENTITY' encountered a fatal error (repository.c:4773)
    00004764: 2018-08-01T04:35:24 [TARGET_APPLY ]E: ORA-03137: malformed TTC packet from client rejected: [kpoal8Check-3] [32768] [0] [0x000000000] [789544] [] [] [] [1022307] (oracle_endpoint_apply.c:2256)
    00008444: 2018-08-01T04:35:24 [SORTER ]I: Final saved task state. Stream position timestamp:2018-08-01T10:34:33, Source id 1, next Target id 1, confirmed Target id 0 (sorter.c:652)
    00004764: 2018-08-01T04:35:24 [TARGET_APPLY ]E: Cannot create Special table [1022307] (endpointshell.c:2282)
    00004764: 2018-08-01T04:35:24 [TARGET_APPLY ]E: Cannot create Exception table [1022307] (endpointshell.c:2467)
    00004764: 2018-08-01T04:35:24 [TARGET_APPLY ]E: Error executing command [1020401] (streamcomponent.c:1644)
    00004764: 2018-08-01T04:35:24 [TASK_MANAGER ]E: Stream component failed at subtask 0, component st_0_QQSIT [1020401] (subtask.c:1350)
    00004764: 2018-08-01T04:35:24 [TARGET_APPLY ]E: Stream component 'st_0_QQSIT' terminated [1020401] (subtask.c:1513)
    00004956: 2018-08-01T04:35:25 [SOURCE_UNLOAD ]I: Standby database role is used. (oracle_endpoint_conn.c:136)
    00004956: 2018-08-01T04:35:25 [SOURCE_UNLOAD ]I: SUPPLEMENTAL_LOG_DATA_PK is set (oracle_endpoint_conn.c:146)
    00003796: 2018-08-01T04:35:26 [TARGET_LOAD ]I: Target endpoint 'Oracle' is using provider syntax 'Oracle' (provider_syntax_manager.c:585)
    00003796: 2018-08-01T04:35:27 [SOURCE_CAPTURE ]I: Source endpoint 'Oracle' is using provider syntax 'Oracle' (provider_syntax_manager.c:579)
    00008040: 2018-08-01T04:35:27 [SERVER ]E: GEN-E-MESSAGE, Unexpected EOF detected: requested to read 16 bytes, actually read 0 bytes [1020601] (ar_net.c:734)
    00008120: 2018-08-01T04:35:28 [SOURCE_UNLOAD ]I: Standby database role is used. (oracle_endpoint_conn.c:136)
    00008120: 2018-08-01T04:35:28 [SOURCE_UNLOAD ]I: SUPPLEMENTAL_LOG_DATA_PK is set (oracle_endpoint_conn.c:146)
    00006016: 2018-08-01T04:35:28 [TARGET_LOAD ]I: Target endpoint 'Oracle' is using provider syntax 'Oracle' (provider_syntax_manager.c:585)
    00006016: 2018-08-01T04:35:28 [SOURCE_CAPTURE ]I: Source endpoint 'Oracle' is using provider syntax 'Oracle' (provider_syntax_manager.c:579)
    00006704: 2018-08-01T04:35:29 [SOURCE_UNLOAD ]I: Standby database role is used. (oracle_endpoint_conn.c:136)
    00006704: 2018-08-01T04:35:29 [SOURCE_UNLOAD ]I: SUPPLEMENTAL_LOG_DATA_PK is set (oracle_endpoint_conn.c:146)
    00009148: 2018-08-01T04:35:29 [TARGET_LOAD ]I: Target endpoint 'Oracle' is using provider syntax 'Oracle' (provider_syntax_manager.c:585)
    00009148: 2018-08-01T04:35:30 [SOURCE_CAPTURE ]I: Source endpoint 'Oracle' is using provider syntax 'Oracle' (provider_syntax_manager.c:579)
    00006084: 2018-08-01T04:35:31 [SOURCE_UNLOAD ]I: Standby database role is used. (oracle_endpoint_conn.c:136)
    00006084: 2018-08-01T04:35:31 [SOURCE_UNLOAD ]I: SUPPLEMENTAL_LOG_DATA_PK is set (oracle_endpoint_conn.c:146)
    00009144: 2018-08-01T04:35:31 [TARGET_LOAD ]I: Target endpoint 'Oracle' is using provider syntax 'Oracle' (provider_syntax_manager.c:585)
    00009144: 2018-08-01T04:35:32 [SOURCE_CAPTURE ]I: Source endpoint 'Oracle' is using provider syntax 'Oracle' (provider_syntax_manager.c:579)
    00008852: 2018-08-01T04:35:32 [TASK_MANAGER ]I: Subtask #0 ended (replicationtask_util.c:937)
    00008852: 2018-08-01T04:35:32 [TASK_MANAGER ]I: Subtask #1 ended (replicationtask_util.c:937)
    00008852: 2018-08-01T04:35:32 [TASK_MANAGER ]I: Subtask #2 ended (replicationtask_util.c:937)
    00008852: 2018-08-01T04:35:32 [TASK_MANAGER ]I: Subtask #3 ended (replicationtask_util.c:937)
    00008852: 2018-08-01T04:35:32 [TASK_MANAGER ]I: Subtask #4 ended (replicationtask_util.c:937)
    00008852: 2018-08-01T04:35:32 [TASK_MANAGER ]I: Subtask #5 ended (replicationtask_util.c:937)
    00008852: 2018-08-01T04:35:32 [SERVER ]I: Stop server request received internally (server.c:2956)
    00008852: 2018-08-01T04:35:32 [TASK_MANAGER ]I: Task management thread terminated (replicationtask.c:3089)
    00008040: 2018-08-01T04:35:32 [SERVER ]I: Client session (ID 18557) closed (dispatcher.c:200)
    00008040: 2018-08-01T04:35:32 [UTILITIES ]I: The last state is saved to file 'C:\Program Files\Attunity\Replicate\data\tasks\SIT_LOAD_ENTIT Y/StateManager/ars_saved_state_000001.sts' at Wed, 01 Aug 2018 10:35:27 GMT (1533119727024017) (statemanager.c:601)
    00004360: 2018-08-01T04:35:32 [SERVER ]I: The process stopped (server.c:3079)
    00004360: 2018-08-01T04:35:32 [AT_GLOBAL ]I: Closing log file at Wed Aug 01 04:35:32 2018 (at_logger.c:2288)

  2. #2
    Hein is offline Senior Member
    Join Date
    Dec 2007
    Location
    Nashua, NH - USA.
    Posts
    165
    Rep Power
    13
    >> 24 [TARGET_APPLY ]E: ORA-03137: malformed TTC packet from client rejected: [kpoal8Check-3] 24 [TARGET_APPLY ]E: ORA-03137: malformed TTC packet from client rejected: [kpoal8Check-3]

    This is 99% sure to be an Oracle configuration error between client and server.
    Be sure to check the Oracle support site for client version and source version compatibilty.
    Since you have Oracle both as source as target, and just one client in the middle I suppose this could be a challenge.

    If you just use SQLplus to do a CREATE TABLE <any table really, but maybe 'SS'.'INST'. Now add some rows, maybe directly from the source (CTAS)
    Does it work,or does it give the same message?
    If it also fails using SQLplus, clearly there is nothing Replicate can do.

    If SQLplus works, then is it time to look at the details of the failing statements.
    Go to task-setting, logging, set TARGET_APPLY to TRACE to get to see the SQL which is executed.
    (Sometimes VERBOSE setting is needed, but first try TRACE).

    Now execute that exact query with SQLplus...

    Good luck!
    Hein

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •