无法使用数据泵从映射的网络驱动器导入转储 [英] Can't import dump from mapped net drive using data pump

问题描述

我正在尝试从网络驱动器中的.dmp文件导入少量用户.不幸的是，自从我获得批准以来，我似乎缺乏一些这样做的权利

I'm trying to import few users from .dmp file from a net drive. Unofrtunately it seems that I lack some rights to do so since I get

ORA-39001: invalid argument value
ORA-39000: bad dump file specification
ORA-31640: unable to open dump file "\\net\drive\directory\placeholder\my_dump.dmp" for read
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 5) Access is denied.

我不确定为什么，因为我既可以访问该目录，又可以在其中保存一个txt文件.

I'm not sure why, because I can both access that directory, and for example save a txt file there.

目录在数据库中另存为'\ net \ drive \ directory \ placeholder'.日志文件指定了其他目录(不在网络驱动器上).

Directory is saved on database as '\net\drive\directory\placeholder'. Log file has other directory specified (not on net drive).

是否有任何解决方法来导入此转储而不实际将其移至本地驱动器?转储确实很大，而且我没有足够的空间(甚至没有关闭空间)，而且(也可能)我也不能更改我在此映射驱动器上的权限.

Is there any workaround to import this dump without actually moving it to local drive? Dump is really big, and I don't have space for it (not even close) and neither can I (probably) change my rights on this mapped drive.

我也无法真正减小转储的大小.

Also I can't really make dump smaller.

我在一个站点上找到了此建议-记住，您的OS用户ID可能不是在UNIX，Linux或Windows操作系统中运行提交的RMAN作业的ID. 解决方案是"

On one site I've found this advice - " Remember, your OS user ID may not be the ID that is running a submitted RMAN job, in an operating system, UNIX, Linux or Windows." The solution was to "

In the ControlPanel services:  
Right click on service
Select ?properties?
Select ?logon?
Change the default user ID to an Oracle user with Windows administrator privileges"

但是我不确定更改对服务器/数据库的实际影响，并且我正在客户端的服务器上工作，所以我不想轻举妄动.我也不想重置数据库或服务器本身.

But I'm not sure what changing this would actually do to server/database, and I'm working on client's server so I don't want to act rashly. I also don't want to reset database or server itself.

我该怎么办?

推荐答案

问题是您的Oracle实例在无法访问网络驱动器的其他用户帐户下运行. 除非您不想以其他帐户运行Oracle，否则可以将对当前Oracle实例用户帐户(通常为Windows平台的LocalSystem)的读取访问权限授予网络共享.另一种选择是通过dblink从源数据库导入数据(在这种情况下，您根本不需要转储文件)

The problem is that your Oracle instance is running under different user account which doesn't have an access to the network drive. Unless you don't want to run Oracle under different account, you can give the read access to the current Oracle's instance user account (usually LocalSystem for Windows platform) to your network share. Another option could be to import data from the source database via dblink (you won't need dump file in this case at all)

这篇关于无法使用数据泵从映射的网络驱动器导入转储的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！