unidac direct mode - ora 12.2 - tunialerter

Discussion of open issues, suggestions and bugs regarding UniDAC (Universal Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
albourgz
Posts: 160
Joined: Wed 06 May 2009 12:17
Location: belgium

unidac direct mode - ora 12.2 - tunialerter

Post by albourgz » Tue 23 Oct 2018 14:24

Hi,

Server: oracle 12.2 RAC Enterprise Edition on linux x86_64.
Client: c++ builder app / vcl /win 32 , unidac 7.1.4, direct mode.
Since upgrade from oracle 12.1 to 12.2, we get sporadic erros in alert_log concerning the client executable:
2018-10-20T16:35:40.382802+02:00
Errors in file /u01/app/oracle/diag/rdbms/giruis/GI1/trace/GI1_ora_23506.trc (incident=130463):
ORA-03137: malformed TTC packet from client rejected: [3146] [4] [] [] [] [] [] []
Incident details in: /u01/app/oracle/diag/rdbms/giruis/GI1/incident/incdir_130463/GI1_ora_23506_i130463.trc
2018-10-20T16:35:41.209922+02:00
Errors in file /u01/app/oracle/diag/rdbms/giruis/GI1/trace/GI1_ora_14266.trc (incident=130223):
ORA-03137: malformed TTC packet from client rejected: [3146] [4] [] [] [] [] [] []
Incident details in: /u01/app/oracle/diag/rdbms/giruis/GI1/incident/incdir_130223/GI1_ora_14266_i130223.trc
2018-10-20T16:35:41.379452+02:00
Errors in file /u01/app/oracle/diag/rdbms/giruis/GI1/trace/GI1_ora_3953.trc (incident=130887):
ORA-03137: malformed TTC packet from client rejected: [3146] [4] [] [] [] [] [] []
Incident details in: /u01/app/oracle/diag/rdbms/giruis/GI1/incident/incdir_130887/GI1_ora_3953_i130887.trc
2018-10-20T16:35:42.250013+02:00
Session (355,19335): Bad TTC Packet Detected: Inbound connection from client
Session (355,19335): Bad TTC Packet Detected: DB Logon User: ***, Remote Machine:***, Program: cec.exe, OS User: ***
Session (355,19335): Bad TTC Packet Detected: Client IP Address: 192.168.4.128
Errors in file /u01/app/oracle/diag/rdbms/giruis/GI1/trace/GI1_ora_23506.trc (incident=130464):
ORA-03137: malformed TTC packet from client rejected: [3146] [94] [] [] [] [] [] []
Incident details in: /u01/app/oracle/diag/rdbms/giruis/GI1/incident/incdir_130464/GI1_ora_23506_i130464.trc
2018-10-20T16:35:42.295334+02:00
Session (341,36759): Bad TTC Packet Detected: Inbound connection from client
Session (341,36759): Bad TTC Packet Detected: DB Logon User: ***, Remote Machine: ***, Program: cec.exe, OS User: ***
Session (341,36759): Bad TTC Packet Detected: Client IP Address: 192.168.3.139
2018-10-20T16:35:42.299428+02:00
Session (267,33069): Bad TTC Packet Detected: Inbound connection from client
Session (267,33069): Bad TTC Packet Detected: DB Logon User: ***, Remote Machine: ***, Program: cec.exe, OS User: ***
Session (267,33069): Bad TTC Packet Detected: Client IP Address: 192.168.4.130
Errors in file /u01/app/oracle/diag/rdbms/giruis/GI1/trace/GI1_ora_14266.trc (incident=130224):
ORA-03137: malformed TTC packet from client rejected: [3146] [94] [] [] [] [] [] []
Incident details in: /u01/app/oracle/diag/rdbms/giruis/GI1/incident/incdir_130224/GI1_ora_14266_i130224.trc
Errors in file /u01/app/oracle/diag/rdbms/giruis/GI1/trace/GI1_ora_3953.trc (incident=130888):
ORA-03137: malformed TTC packet from client rejected: [3146] [94] [] [] [] [] [] []
Session (267,33069): Bad TTC Packet Detected: Inbound connection from client
Session (267,33069): Bad TTC Packet Detected: DB Logon User: ***, Remote Machine: ***, Program: cec.exe, OS User: ***


Trace files show there is a problem with DBMS_ALERT component, used by TUniAlerter.
Any hint?

MaximG
Devart Team
Posts: 1822
Joined: Mon 06 Jul 2015 11:34

Re: unidac direct mode - ora 12.2 - tunialerter

Post by MaximG » Thu 25 Oct 2018 05:47

The provided information is not enough for investigating the issue. Please compose and us a small sample, the execution of which causes the issue. It is convenient to do it using the e-support form https://www.devart.com/company/contactform.html

Post Reply