重庆思庄Oracle、Redhat认证学习论坛

标题: Ora-12805 After Oracle 19 Upgrade [打印本页]

作者: 刘泽宇 时间: 2023-5-28 12:30
标题: Ora-12805 After Oracle 19 Upgrade
SYMPTOMS
query is failing with ora-12805

the px worker trace file shows

Exception [type: SIGFPE, Integer divide by zero] [ADDR:0x12909AC4] [PC:0x12909AC4, lnxdiv()+1428] [flags: 0x0, count: 1]
DDE: Problem Key 'ORA 7445 [lnxdiv]' was flood controlled (0x6) (incident: 2660900

ORA-07445: exception encountered: core dump [lnxdiv()+1428] [SIGFPE] [ADDR:0x12909AC4] [PC:0x12909AC4] [Integer divide by zero] []
..

CAUSE
zero or unprintable characters in the column

SOLUTION
correct the data in the column

欢迎光临重庆思庄Oracle、Redhat认证学习论坛 (http://bbs.cqsztech.com/)