oracle使用dblink impdp数据时报错ORA-39169

问题描述:oracle使用dblink impdp数据时报错ORA-39169,如下所示:
源 端:oracle 10.2.0.4 64位 + oel 5.11 64位
目标端:oracle 19.16 64位 + centos 7.9 64位
1、异常重现
[oracle@leo-19c-ogg ~]$ nohup impdp system/oracle_4U@SIMDB directory=EXPDP_DIR version=10.2.0.4 NETWORK_LINK=ORCL_LINK flashback_scn=2478277 exclude=statistics parallel=4 schemas=SCOTT logfile=impdp_scott.log logtime=ALL TRANSFORM=DISABLE_ARCHIVE_LOGGING:Y &

[oracle@leo-19c-ogg ~]$ tail -5000f nohup.out

Import: Release 19.0.0.0.0 - Production on Sat Dec 10 18:30:04 2022
Version 19.16.0.0.0

Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.

Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
ORA-39001: invalid argument value
ORA-39169: Local version of 19.16.0.0.0 cannot work with remote version of 10.2.0.4.0.
2、异常原因
oracle 10.2.0.4通过dblink无法与oracle 19.16进行远程通讯.
3、解决方案
采用直接导入导出的方式.
3.1、源端操作
[oracle@leo-10g-ogg ogg]$ export NLS_LANG=AMERICAN_AMERICA.AL32UTF8
[oracle@leo-10g-ogg ogg]$ exp scott/tiger@orcl file=/home/oracle/scott.dmp tables=dept,emp rows=y log=/home/oracle/exp.log

Export: Release 10.2.0.4.0 - Production on Sun Dec 10 18:48:24 2022

Copyright (c) 1982, 2007, Oracle. All rights reserved.


Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Export done in AL32UTF8 character set and AL16UTF16 NCHAR character set

About to export specified tables via Conventional Path ...
. . exporting table DEPT 4 rows exported
. . exporting table EMP 14 rows exported
Export terminated successfully without warnings.

将源端dmp文件scp到目标端.
[oracle@leo-10g-ogg ~]$ scp scott.dmp oracle@192.168.133.109:/home/oracle/
3.2、目标端操作
--创建用户并授予权限
sys@SIMDB 2022-12-10 19:28:54> create user scott identified by tiger;

User created.

sys@SIMDB 2022-12-10 19:35:11> grant connect,resource to scott;

Grant succeeded.

sys@SIMDB 2022-12-10 19:37:28> alter user scott quota unlimited on users;

User altered.
--导入测试数据
[oracle@leo-19c-ogg ~]$ export NLS_LANG=AMERICAN_AMERICA.AL32UTF8
[oracle@leo-19c-ogg ~]$ imp scott/tiger file=/home/oracle/scott.dmp full=y

Import: Release 19.0.0.0.0 - Production on Sat Dec 10 19:40:01 2022
Version 19.16.0.0.0

Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.


Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.16.0.0.0

Export file created by EXPORT:V10.02.01 via conventional path
import done in AL32UTF8 character set and UTF8 NCHAR character set
export server uses AL16UTF16 NCHAR character set (possible ncharset conversion)
. importing SCOTT's objects into SCOTT
. importing SCOTT's objects into SCOTT
. . importing table "DEPT" 4 rows imported
. . importing table "EMP" 14 rows imported
About to enable constraints...
Import terminated successfully without warnings.