ORA-03113: end-of-file on communication channel

[听雨停了]

select * from (
    select 
        case 
            when a.PROCESS_ID in ('101291','101508')then a.customer_sn
            when a.PROCESS_ID in ('101509','101510') then a.serial_number 
        end as SN,
        case 
            when a.PROCESS_ID in ('101291','101508') then b.fw_version_b
            when a.PROCESS_ID = '101509' then b.fw_version_l
            when a.PROCESS_ID = '101510' then b.fw_version_r
        end as FW
    from aa partition(P_C_202003) a
    left join bb partition(P_A_202003) b on
        (case 
            when a.PROCESS_ID in ('101291','101508')then a.customer_sn
            when a.PROCESS_ID in ('101509','101510') then a.serial_number 
        end ) = b.sn
        and (case 
            when a.PROCESS_ID in ('101291','101508') then b.fw_version_b
            when a.PROCESS_ID = '101509' then b.fw_version_l
            when a.PROCESS_ID = '101510' then b.fw_version_r
        end ) is not null
    where a.current_status=0
    and a.process_id in ('101291','101509','101510','101508')
    and a.out_process_time between to_date('2020-03-23 11:00:00','yyyy-mm-dd hh24:mi:ss')
    and to_date('2020-03-23 19:00:00','yyyy-mm-dd hh24:mi:ss')
)
where FW is null;

SQL就是上面这个SQL,不用细看SQL逻辑有没有问题（应该没问题啥问题的）。问题就是如果去掉最后一行where FW is null数据可以查询出来，加上where FW is null就会报ORA-03113: end-of-file on communication channel

[liu志坚]

看看 alert日志有没有其他错误信息