千家信息网

centos 6.6下oracle使用impdp导入数据库报错!

发表于:2025-02-04 作者:千家信息网编辑
千家信息网最后更新 2025年02月04日,oracle小白一个,遇到问题,请各位大神帮忙看看环境:1、centos6.62、新安装的oracle 11gR23、使用impdp导入其他的数据库报错[oracle@BJ-BoHua-AssetsT
千家信息网最后更新 2025年02月04日centos 6.6下oracle使用impdp导入数据库报错!

oracle小白一个,遇到问题,请各位大神帮忙看看

环境:

1、centos6.6

2、新安装的oracle 11gR2

3、使用impdp导入其他的数据库报错


[oracle@BJ-BoHua-AssetsTest dbbak]$ impdp XXX/XXX123@orcl directory=dump_dir dumpfile=BTHJ_NCDB_20171020_0101.dmp logfile=BTHJ_NCDB_20171020_0101.log remap_schema=bthjzs:bhsw EXCLUDE=USER full=y cluster=N;


Import: Release 11.2.0.1.0 - Production on Mon Oct 23 16:26:27 2017


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


Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production

With the Partitioning, Oracle Label Security, OLAP, Data Mining,

Oracle Database Vault and Real Application Testing options

ORA-39002: invalid operation

ORA-39070: Unable to open the log file.

ORA-39087: directory name DUMP_DIR is invalid


下面有查询的信息:

PRIVILEGE DIRECTORY_NAME

------------------------------------------------------------

DIRECTORY_PATH

------------------------------

READ DATA_PUMP_DIR

/home/oracle/app/oracle/admin/

orcl/dpdump/

READ DATA_PUMP_DIR

/home/oracle/app/oracle/admin/

orcl/dpdump/

READ DATA_PUMP_DIR

PRIVILEGE DIRECTORY_NAME

------------------------------------------------------------

DIRECTORY_PATH

------------------------------

/home/oracle/app/oracle/admin/

orcl/dpdump/

WRITE DATA_PUMP_DIR

/home/oracle/app/oracle/admin/

PRIVILEGE DIRECTORY_NAME

------------------------------------------------------------

DIRECTORY_PATH

------------------------------

orcl/dpdump/

WRITE DATA_PUMP_DIR

/home/oracle/app/oracle/admin/

orcl/dpdump/

READ DPDATA

/data/oradata/orcl/

PRIVILEGE DIRECTORY_NAME

------------------------------------------------------------

DIRECTORY_PATH

------------------------------

WRITE DPDATA

/data/oradata/orcl/

DPUMP_DIR

/data/oradata/orcl/dpump_dir

IMPDP

/data/dbbak/

PRIVILEGE DIRECTORY_NAME

------------------------------------------------------------

DIRECTORY_PATH

------------------------------

READ ORACLE_OCM_CONFIG_DIR

/home/oracle/app/oracle/produc

t/11.2.0/dbhome_1/ccr/state

WRITE ORACLE_OCM_CONFIG_DIR

/home/oracle/app/oracle/produc

t/11.2.0/dbhome_1/ccr/state

PRIVILEGE DIRECTORY_NAME

------------------------------------------------------------

DIRECTORY_PATH

------------------------------

XMLDIR

/ade/b/2125410156/oracle/rdbms

/xml

13rows selected.


不知道具体该怎么做,哪位大神指导一下?

0