Hi All,
We have oracle 19.3 on source and target. The oracle client 19 is installed on aws replication instance ( intermediate server )
We are migrating data from on-prem ( oracle ) to aws ec2 ( oracle ) by AWS DMS.
We got the below end of commination errors on source db while connecting from aws replication instance ( intermediate server ).
-------------------------------error from application side-----------------------------------------------------------------
OCI error 'ORA-03113: end-of-file on communication channel Process ID: 20099 Session ID: 266 Serial number: 933' [1022307] (oradcdc_io.c:1112)
Failed to read from ASM file with thread id '1' from block number '77459', size '32256' OCI Thread Id '3' [20014] (oradcdc_io.c:1115)
OCI error 'ORA-03113: end-of-file on communication channel Process ID: 20077 Session ID: 183 Serial number: 43080' [1022307] (oradcdc_io.c:1112)
Failed to read from ASM file with thread id '1' from block number '27270', size '32256' OCI Thread Id '1' [20014] (oradcdc_io.c:1115)
OCI error 'ORA-03113: end-of-file on communication channel Process ID: 20113 Session ID: 90 Serial number: 50676' [1022307] (oradcdc_io.c:1112)
Failed to read from ASM file with thread id '1' from block number '126451', size '32256' OCI Thread Id '5' [20014] (oradcdc_io.c:11
---------------------------------------------------------------------------------------------------
------------------------------error from aleter log------------------------------------------------
Current log# 5 seq# 233733 mem# 0: +DATA1/PRODDB1/ONLINELOG/group_5.1173.1087124251
Current log# 5 seq# 233733 mem# 1: +FRA1/PRODDB1/ONLINELOG/group_5.408.1087124251
2021-11-17T05:13:52.789221-05:00
Deleted Oracle managed file +FRA1/PRODDB1/ARCHIVELOG/2021_11_12/thread_1_seq_224976.4876.1088465027
Deleted Oracle managed file +FRA1/PRODDB1/ARCHIVELOG/2021_11_12/thread_1_seq_224977.4875.1088465041
2021-11-17T05:13:53.377468-05:00
ARC2 (PID:8217): Archived Log entry 232502 added for T-1.S-233732 ID 0xe1aab7f5 LAD:1
2021-11-17T05:13:54.975687-05:00
Errors in file /u01/app/oracle/diag/rdbms/PRODDB1/PRODDB1/trace/PRODDB1_ora_19184.trc (incident=169863) (PDBNAME=ABCDW):
ORA-03137: malformed TTC packet from client rejected: [kpoal8Check-5] [32768] [0x000000000] [0x000000000] [0] [1] [34864] []
ABCDW(4):Incident details in: /u01/app/oracle/diag/rdbms/PRODDB1/PRODDB1/incident/incdir_169863/PRODDB1_ora_19184_i169863.trc
2021-11-17T05:13:55.054239-05:00
Errors in file /u01/app/oracle/diag/rdbms/PRODDB1/PRODDB1/trace/PRODDB1_ora_19222.trc (incident=170466) (PDBNAME=ABCDW):
ORA-03137: malformed TTC packet from client rejected: [kpoal8Check-5] [32768] [0x000000000] [0x000000000] [0] [1] [34864] []
ABCDW(4):Incident details in: /u01/app/oracle/diag/rdbms/PRODDB1/PRODDB1/incident/incdir_170466/PRODDB1_ora_19222_i170466.trc
2021-11-17T05:13:55.371726-05:00
Thread 1 cannot allocate new log, sequence 233734
Checkpoint not complete
Current log# 5 seq# 233733 mem# 0: +DATA1/PRODDB1/ONLINELOG/group_5.1173.1087124251
Current log# 5 seq# 233733 mem# 1: +FRA1/PRODDB1/ONLINELOG/group_5.408.1087124251
and
2021-11-17T05:14:44.279260-05:00
CDBW(4):Session (1098,40139): Bad TTC Packet Detected: Inbound connection from client
CDBW(4):Session (1098,40139): Bad TTC Packet Detected: DB Logon User: AWS_ROLE, Remote Machine: ip-10-5-5-57, Program: repctl@ip-ip-10-5-5-57 (TNS V1-V3), OS User: rdsdb
CDBW(4):Session (1098,40139): Bad TTC Packet Detected: Client IP Address: 172.21.11.14
2021-11-17T05:14:44.899210-05:00
------------------------------------------------------------------------------------------------------
We often got this error while migrating.
There is no huge data load on source during the time. Network team said that there is no issue in network.
How to find why it was failed.
How to find whether the issue is db or network
Please share your suggestions,
Thanks,