19C database expdp impdp error:ORA-39155 ORA-48128

19C database expdp impdp error:ORA-39155 ORA-48128

1 imdp报错

导出文件是从hp unx for oracle10g的导出文件，再往19c rac for linux导入时候报错

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
Master table "SYS"."IMPDP_EXTOA" successfully loaded/unloaded
Starting "SYS"."IMPDP_EXTOA":  "/******** AS SYSDBA" SCHEMAS=SYNERGY,IDS directory=IMPDP DUMPFILE=SYNERGY_%U.dp logfile=impdp_extoa.log job_name=impdp_extoa PARALLE
L=2 
Processing object type SCHEMA_EXPORT/USER
ORA-39384: Warning: User IDS has been locked and the password expired.
ORA-39384: Warning: User SYNERGY has been locked and the password expired.
Processing object type SCHEMA_EXPORT/SYSTEM_GRANT
Processing object type SCHEMA_EXPORT/ROLE_GRANT
Processing object type SCHEMA_EXPORT/DEFAULT_ROLE
Processing object type SCHEMA_EXPORT/TABLESPACE_QUOTA
Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
Processing object type SCHEMA_EXPORT/SEQUENCE/SEQUENCE
Processing object type SCHEMA_EXPORT/SEQUENCE/GRANT/OWNER_GRANT/OBJECT_GRANT
ORA-39083: Object type OBJECT_GRANT failed to create with error:
ORA-01917: user or role 'REIM' does not exist

Failing sql is:
GRANT SELECT ON "SYNERGY"."S_MESSAGE_LOG_ID" TO "REIM"
 
Processing object type SCHEMA_EXPORT/TABLE/TABLE
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
. . imported "SYNERGY"."HS_TAKEOUT"                      197.3 MB 1935088 rows
. . imported "SYNERGY"."BAO_EVIDENCE"                    79.69 MB  546345 rows
. . imported "SYNERGY"."UG_ANDROID_LOG"                  55.06 MB  542336 rows
. . imported "SYNERGY"."UG_EMPLOYMENT_OLD"               58.09 MB  681366 rows
. . imported "SYNERGY"."HS_RECEIVELINE"                  53.22 MB 1114492 rows
ORA-31693: Table data object "SYNERGY"."HS_TAKEOUTLINE" failed to load/unload and is being skipped due to error:
ORA-39155: error expanding dump file name "/ogg/impdp/SYNERGY_01.dp"
ORA-48128: opening of a symbolic link is disallowed
ORA-19505: failed to identify file "/ogg/impdp/SYNERGY_01.dp"
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 7
. . imported "SYNERGY"."BTS_TRANSFUSIONAPPLY"            46.11 MB  278675 rows
. . imported "SYNERGY"."BAO_PERSONAL_MUTUAL_IN"          36.19 MB  438264 rows
. . imported "SYNERGY"."BTS_MEDICALRECORD"               33.68 MB  221824 rows
. . imported "SYNERGY"."HS_RECEIVE"                      31.51 MB  316848 rows
. . imported "SYNERGY"."HS_STORE_LOG"                    30.57 MB  643538 rows
. . imported "IDS"."UG_BLOODBAG_BAK"                     27.79 MB  329189 rows
. . imported "SYNERGY"."HS_STOCK_LOG"                    26.73 MB 1108032 rows
. . imported "SYNERGY"."BAO_EVIDENCE_BLOOD"              25.21 MB  767424 rows
ORA-31693: Table data object "SYNERGY"."HS_HANDOVERDETAIL" failed to load/unload and is being skipped due to error:
ORA-39155: error expanding dump file name "/ogg/impdp/SYNERGY_01.dp"
ORA-48128: opening of a symbolic link is disallowed
ORA-19505: failed to identify file "/ogg/impdp/SYNERGY_01.dp"
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 7
. . imported "SYNERGY"."HS_TAKEOUTREVERT_LINE"        

2 分析

看报错信息好像目录引用了软连接导致的，但是这边创建的是实体的目录。

看来查查mos了。再mos上找到文章，说明是一个bug

CAUSE

Error can happen at symbolic link internal check stage.

Unpublished BUG 27598040 has been created and at time of creating this document, development is working on this issue.

SOLUTION：

The following workaround has been verified by development for this issue:

ALTER SYSTEM SET “_disable_directory_link_check” =true SCOPE=SPFILE;

Restart the database.

3 再次尝试导入还是识别的报错

抽风似的有时候说找不到文件，但是现在的这个文件不在说软连接的问题了。想了想是不是因为我没有加上cluster=n呢

. . imported "SYNERGY"."HS_TAKEOUTREVERT_LINE"           23.69 MB  497051 rows
. . imported "SYNERGY"."BAO_PERSONAL_MUTUAL_OUT"         24.33 MB  237152 rows
ORA-31693: Table data object "SYNERGY"."HS_TAKEOUT" failed to load/unload and is being skipped due to error:
ORA-31640: unable to open dump file "/ogg/impdp/SYNERGY_01.dp" for read
ORA-19505: failed to identify file "/ogg/impdp/SYNERGY_01.dp"
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 7
. . imported "SYNERGY"."HS_TAKEOUTREVERT"                14.22 MB  240465 rows
. . imported "SYNERGY"."BAO_PER_MUTUAL_OUT_DETAIL"       10.15 MB  247589 rows
. . imported "SYNERGY"."HS_STORE"                        4.332 MB  120853 rows

4 cluster=n搞上去

终于正常了，继续做OGG同步把