ORA-39002: invalid operation ORA-39070: Unable to open the log file. ORA-29283: invalid file operati

[oracle@ol7 dmpdir]$ impdp BDC_WORKFLOW/salis@orcl schemas=BDC_WORKFLOW directory=DMPDIR dumpfile=BDC_WORKFLOW.DMP logfile=BDC_WORKFLOW.logImport: Release 11.2.0.4.0 - Production on Thu Apr 8 14:17:28

yaocsu

7165人浏览 · 2021-04-08 14:28:02

yaocsu · 2021-04-08 14:28:02 发布

[oracle@ol7 dmpdir]$ impdp BDC_WORKFLOW/salis@orcl schemas=BDC_WORKFLOW directory=DMPDIR dumpfile=BDC_WORKFLOW.DMP logfile=BDC_WORKFLOW.log

Import: Release 11.2.0.4.0 - Production on Thu Apr 8 14:17:28 2021

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

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORA-39002: invalid operation
ORA-39070: Unable to open the log file.
ORA-29283: invalid file operation
ORA-06512: at "SYS.UTL_FILE", line 536
ORA-29283: invalid file operation


[oracle@ol7 dmpdir]$ sqlplus '/ as sysdba'

SQL*Plus: Release 11.2.0.4.0 Production on Thu Apr 8 14:18:42 2021

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


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> select * from dba_directories where DIRECTORY_NAME = 'DMPDIR';           

OWNER			       DIRECTORY_NAME
------------------------------ ------------------------------
DIRECTORY_PATH
--------------------------------------------------------------------------------
SYS			       DMPDIR
/u01/dmpdir


SQL> drop directory dmpdir
  2  ;

Directory dropped.

SQL> create directory dmpdir as '/u01/dmpdir';

Directory created.

SQL> grant read, write on directory dmpdir to BDC_WORKFLOW;

Grant succeeded.

SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[oracle@ol7 dmpdir]$ impdp BDC_WORKFLOW/salis@orcl schemas=BDC_WORKFLOW directory=DMPDIR dumpfile=BDC_WORKFLOW.DMP logfile=BDC_WORKFLOW.log

Import: Release 11.2.0.4.0 - Production on Thu Apr 8 14:22:02 2021

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

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Master table "BDC_WORKFLOW"."SYS_IMPORT_SCHEMA_01" successfully loaded/unloaded
Starting "BDC_WORKFLOW"."SYS_IMPORT_SCHEMA_01":  BDC_WORKFLOW/********@orcl schemas=BDC_WORKFLOW directory=DMPDIR dumpfile=BDC_WORKFLOW.DMP logfile=BDC_WORKFLOW.log 
Processing object type SCHEMA_EXPORT/USER
ORA-31684: Object type USER:"BDC_WORKFLOW" already exists
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/PRE_SCHEMA/PROCACT_SCHEMA
Processing object type SCHEMA_EXPORT/SEQUENCE/SEQUENCE
Processing object type SCHEMA_EXPORT/TABLE/TABLE
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
. . imported "BDC_WORKFLOW"."WFI_MATERDATA"              26.18 MB    3454 rows
. . imported "BDC_WORKFLOW"."WFD_TR_ACTTOMOD"            2.710 MB   18991 rows
. . imported "BDC_WORKFLOW"."WFI_TR_ACTDEFTOSPDY"        1.565 MB   10242 rows
. . imported "BDC_WORKFLOW"."WFD_PASS_CONDITION"         711.8 KB    3544 rows
. . imported "BDC_WORKFLOW"."WFD_ACTDEF"                 594.8 KB    1943 rows
. . imported "BDC_WORKFLOW"."WFD_ROUTE"                  465.5 KB    1682 rows
. . imported "BDC_WORKFLOW"."WFI_ACTINST"                463.6 KB    1101 rows
. . imported "BDC_WORKFLOW"."WFI_ROUTE"                  478.7 KB     986 rows
. . imported "BDC_WORKFLOW"."WFD_PROMATER"               299.1 KB    1707 rows
. . imported "BDC_WORKFLOW"."WFI_PROMATER"               281.4 KB     998 rows
. . imported "BDC_WORKFLOW"."WFI_ACTINSTSTAFF"           243.2 KB    1218 rows
. . imported "BDC_WORKFLOW"."WFI_SPYJ"                   150.3 KB     411 rows
. . imported "BDC_WORKFLOW"."SYS_EXPORT_SCHEMA_01"       129.2 KB    1092 rows
. . imported "BDC_WORKFLOW"."SYS_EXPORT_SCHEMA_02"       129.4 KB    1093 rows
. . imported "BDC_WORKFLOW"."WFD_MATER"                  145.0 KB     786 rows
. . imported "BDC_WORKFLOW"."WFD_MAXID"                  35.75 KB     485 rows
. . imported "BDC_WORKFLOW"."WFD_PRODEF"                 47.45 KB     250 rows
. . imported "BDC_WORKFLOW"."WFD_SPMB"                   47.99 KB     161 rows
. . imported "BDC_WORKFLOW"."WFI_ABNORMAL"               82.92 KB     426 rows
. . imported "BDC_WORKFLOW"."WFI_NOWACTINST"             43.65 KB      95 rows
. . imported "BDC_WORKFLOW"."WFI_PROINST"                54.26 KB     115 rows
. . imported "BDC_WORKFLOW"."STAFF"                      5.031 KB       1 rows
. . imported "BDC_WORKFLOW"."WFD_ACTTYPE"                6.328 KB       1 rows
. . imported "BDC_WORKFLOW"."WFD_CONST"                  7.320 KB       7 rows
. . imported "BDC_WORKFLOW"."WFD_CONST_VALUE"            7.640 KB      31 rows
. . imported "BDC_WORKFLOW"."WFD_HOLIDAY"                17.61 KB      98 rows
. . imported "BDC_WORKFLOW"."WFD_MAPPING"                31.46 KB     161 rows
. . imported "BDC_WORKFLOW"."WFD_MATERCLASS"             14.31 KB      74 rows
. . imported "BDC_WORKFLOW"."WFD_MODCLASS"               6.835 KB       2 rows
. . imported "BDC_WORKFLOW"."WFD_PROCLASS"               12.32 KB      74 rows
. . imported "BDC_WORKFLOW"."WFD_ROLE"                   8.906 KB       7 rows
. . imported "BDC_WORKFLOW"."WFD_ROLECLASS"              7.125 KB       6 rows
. . imported "BDC_WORKFLOW"."WFD_STAFFTOROLE"            6.367 KB       4 rows
. . imported "BDC_WORKFLOW"."WFD_SYSMOD"                 10.50 KB      18 rows
. . imported "BDC_WORKFLOW"."WFI_DOSSIERTRANSFER"        13.53 KB       9 rows
. . imported "BDC_WORKFLOW"."WFI_SPDY"                   7.476 KB      10 rows
. . imported "BDC_WORKFLOW"."WFI_TRANSFERLIST"           20.56 KB      38 rows
. . imported "BDC_WORKFLOW"."ANSWER"                         0 KB       0 rows
. . imported "BDC_WORKFLOW"."BANK_TRUSTBOOK"                 0 KB       0 rows
. . imported "BDC_WORKFLOW"."BANK_TRUSTBOOKPAGE"             0 KB       0 rows
. . imported "BDC_WORKFLOW"."QUESTION"                       0 KB       0 rows
. . imported "BDC_WORKFLOW"."WFD_MODTMP"                     0 KB       0 rows
. . imported "BDC_WORKFLOW"."WFD_PRODEFMAIN"                 0 KB       0 rows
. . imported "BDC_WORKFLOW"."WFD_TR_ACTTOCONDITION"          0 KB       0 rows
. . imported "BDC_WORKFLOW"."WFI_MATERCLASS"                 0 KB       0 rows
. . imported "BDC_WORKFLOW"."WFI_PASSWORK"                   0 KB       0 rows
. . imported "BDC_WORKFLOW"."WFI_SUPERVISE"                  0 KB       0 rows
Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Processing object type SCHEMA_EXPORT/TABLE/COMMENT
Processing object type SCHEMA_EXPORT/FUNCTION/FUNCTION
Processing object type SCHEMA_EXPORT/PROCEDURE/PROCEDURE
Processing object type SCHEMA_EXPORT/FUNCTION/ALTER_FUNCTION
ORA-39082: Object type ALTER_FUNCTION:"BDC_WORKFLOW"."FUNC_GTTMAXID" created with compilation warnings
Processing object type SCHEMA_EXPORT/PROCEDURE/ALTER_PROCEDURE
Processing object type SCHEMA_EXPORT/VIEW/VIEW
Processing object type SCHEMA_EXPORT/VIEW/COMMENT
Processing object type SCHEMA_EXPORT/TABLE/TRIGGER
Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
Job "BDC_WORKFLOW"."SYS_IMPORT_SCHEMA_01" completed with 2 error(s) at Thu Apr 8 14:22:08 2021 elapsed 0 00:00:06

[oracle@ol7 dmpdir]$