Oracle 11g 数据库导入工具impdp使用Windows的网络驱动器

Oracle 11g 数据库导入工具impdp使用Windows的网络驱动器 ORA-31640

 

 执行imppd命令报出如下错误

连接到: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - Production

With the Partitioning, OLAP and Data Mining options

ORA-39001: 参数值无效

ORA-39000: 转储文件说明错误

ORA-31640: 无法打开要读取的转储文件

ORA-27041: 无法打开文件

OSD-04002: 无法打开文件

O/S-Error: (OS 3) 系统找不到指定的路径。 

 

是windows2008企业版数据库测试成功，Oracle 11g 数据库导入工具impdp使用网络驱动器，网络共享路径或映射远程驱动器

 按照以下步步骤进行设置 

1. Use UNC naming convention (\\\) on CREATE DIRECTORY command.

For example: CREATE DIRECTORY dump_dir AS '\\192.168.1.66\dump\crm';

2. Shut down the database.

3. Stop the listener.

4. Modify the instance service (OracleService) to run as OS account that has the appropriate privileges to access the mapped network disk.

5. Modify the listener service to run as the same account.

6. Start the instance service and the database.

7. Start the listener service.

If after 7, the DB or the listener didn't start appropriately, then Reboot the machine.

 

To identify that the OS account has the appropriate privileges to access the mapped network disk, copy a file to that directory from the command prompt:

copy

 

主要修改在windows服务修改OracleService，Oracle listener 以Administrator用户运行，并设置登录密码

注意：目标服务器与源服务器密码要一致。

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

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/28373936/viewspace-1983831/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/28373936/viewspace-1983831/