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