數據庫升級到19后，大量的 ORA

數據庫從11G升級到19C后,報警日志中不停的報這個ORA-3137的錯誤，

如下：

。。。

ORA-03137: TC : [kpoal8Check-5] [0] [0x000000000] [0x000000000] [0] [0] [265512] []Session (886,4908): Bad TTC Packet Detected: Inbound connection from DBID: (DESCRIPTION =(A GLOBAL_DB_NAME: (DESCRIPTION =(ASession (886,4908): Bad TTC Packet Detected: DB Logon User: CHIS, Remote Machine: WORKGROUP\WIN-3UVLE0V53JO, Program: w3wp.exe, OS User: DRGs????Session (886,4908): Bad TTC Packet Detected: Client IP Address: 192.168.10.10。。。

TRACE文件中，包含：ksedst1,ksedst,dbkedDefDump,ksedmp,dbgexPhaseII,dbgexProcessError,dbgePostErrorKGE,dbkePostKGE_kgsf,kgeade,kgerelv,opiierr,kpoal8Check ,kpoal8,opiodr,ttcpip,opitsk,opiino,opiodr,opidrv,sou2o,opimai_real,ssthrdmain,main,libc_start_main

這個主要是客戶端版本和數據庫服務器版本不匹配導致的，有些客戶端版本還是8I,9I，

解決辦法：升級客戶端到11.2.0.4以上版本即可.

參見官方文檔：

2296523.1

ORA-3137[kpoal8Check-5] from Incompatible Client Version Connecting to a 12.2 Database (文檔 ID 2296523.1)

In this Document

Symptoms

Changes

Cause

Solution

References

APPLIES TO:

Oracle Database Backup Service - Version N/A and later

Oracle Database Exadata Express Cloud Service - Version N/A and later

Oracle Database Cloud Exadata Service - Version N/A and later

Oracle Database Cloud Service - Version N/A and later

Oracle Database - Enterprise Edition - Version 12.2.0.1 and later

Information in this document applies to any platform.

SYMPTOMS

The following errors occur in the alert log:

ORA-03137 : [kpoal8Check-5] [0] [0x000000000] [0x000000000] [0] [0] [2080] []

2017-07-27T16:34:55.075221+03:00

Session (491,42000): Bad TTC Packet Detected: Inbound connection from client

Session (491,42000): Bad TTC Packet Detected: DB Logon User: , Remote Machine: , Program: , OS User:

Session (491,42000): Bad TTC Packet Detected: Client IP Address:

2017-07-27T16:34:56.506362+03:00

Errors in file /diag/rdbms///trace/_ora_27281.trc (incident=128688):

ORA-03137: [kpoal8Check-5] [0] [0x000000000] [0x000000000] [0] [0] [2080] []

2017-07-27T16:34:56.508811+03:00

Session (491,42000): Bad TTC Packet Detected: Inbound connection from client

Session (491,42000): Bad TTC Packet Detected: DB Logon User: , Remote Machine: , Program: , OS User:

Session (491,42000): Bad TTC Packet Detected: Client IP Address:

Errors in file /diag/rdbms///trace/_ora_27281.trc (incident=132001):

ORA-03137: [kpoal8Check-5] [0] [0x000000000] [0x000000000] [0] [0] [2080] []

Session (491,42000): Bad TTC Packet Detected: Inbound connection from client

Session (491,42000): Bad TTC Packet Detected: DB Logon User: , Remote Machine: , Program: , OS User:

Session (491,42000): Bad TTC Packet Detected: Client IP Address:

The Call Stack Trace in the associated incident trace file shows:

opiierr <- kpoal8Check <- kpoal8 <- opiodr <- ttcpip <- opitsk <- opiino <- opiodr <- opidrv <- sou2o

CHANGES

The database was upgraded to 12.2.

CAUSE

This issue is caused by the client version not being compatible with 12.2 RDBMS server version. Unlike previous versions, Oracle has added some strict checks in 12.2.0.1 and client applications must comply with these checks.

This issue was investigated in unpublished Bug 26092744 which was closed as Not a Bug.

SOLUTION

Upgrade the client to a compatible level.

REFERENCES