oracle 错误 22303,Oracle 12c ADG备库执行sql报错ORA-22303、ORA-16000、ORA-06508、ORA-06512

一、背景介绍

某客户数据库备库执行sql失败，数据库环境：主库(12.2.0.1 RAC)，备库(12.2.0.1 单机)RAC到单机搭建了ADG，数据是从12.1.0.2通过erp导入的，报错信息：ORA-22303、ORA-16000、ORA-06508、ORA-06512，具体报错内容见下文。

二、问题描述

1、执行SQL&报错

2020-03-03 15:34:32.830 [job-81740957] INFO SingleTableSplitUtil - split pk [sql=SELECT * FROM ( SELECT xxx FROM xxx.xxx SAMPLE (0.1) WHERE (xxx IS NOT NULL) ORDER BY DBMS_RANDOM.VALUE) WHERE ROWNUM <= 15 ORDER by xxx ASC] is running...

2020-03-03 15:34:32.969 [job-81740957] ERROR JobContainer - Exception when job run

com.alibaba.datax.common.exception.DataXException: Code:[DBUtilErrorCode-07], Description:[读取数据库数据失败. 请检查您的配置的 column/table/where/querySql或者向 DBA 寻求帮助.]. - 执行的SQL为:SELECT * FROM ( SELECT xxx FROM xxx.xxx SAMPLE (0.1) WHERE (xxx IS NOT NULL) ORDER BY DBMS_RANDOM.VALUE) WHERE ROWNUM <= 15 ORDER by xxx ASC 具体错误信息为：ORA-22303: 未找到类型 "SYS".