Ora-39001 Ora-39000 Ora-31640 Ora-27041 Osd-04002 O/s-error
Contents |
friend data pump import error [message #476762] Sat, 25 September 2010 13:28 avbowdenverizonnet Messages: 2Registered: September 2010 Location: Exton Junior Member Hi, I am new to data pump utilities, I haven't really found the answers on osd-04002 unable to open file line or in the Oracle documentation so far. So here goes. We have a
Ora-27041: Unable To Open File
QA database on a VM server with Windows 2003 operating system and oracle 10.2.0.1 installed along with limited disk space. We received an expdp file from a client that is large enough that we had to copy it to a network drive (40GB). I created a new directory called IMPDMP with the directory path (using UNC pathing) to \\server\share\folder\subfolder\ (our network mapped P drive, yes I included the backslash, but I have tried without it also). I also included the parfile here. I checked the grants and they seem to be fine SQL> select * from session_roles where role like '%DATABASE' or role like 'DBA'; ROLE ------------------------------ DBA EXP_FULL_DATABASE IMP_FULL_DATABASE SQL> select * from session_privs where privilege like '%DICT%'; PRIVILEGE ---------------------------------------- SELECT ANY DICTIONARY ANALYZE ANY DICTIONARY this is the parfile DIRECTORY=impdmp FULL=N SCHEMAS=expschema REMAP_SCHEMA=impschema DUMPFILE=impdmp:expdp_1020.DMP NOLOGFILE=Y and then when running import datapump with this command: impdp ********/******** parfile p:\folder\subfolder\impdmp.txt and I get this error Import: Release 10.2.0.1.0 - Production on Saturday, 25 September, 2010 14:07:07 Copyright (c) 2003, 2005, Oracle. All rights reserved. Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Produc tion With the Partitioning, OLAP and Data Mining options ORA-39001: invalid argument value ORA-39000: bad dump file specification ORA-31640: unable to open dump file "\\server\share\folder\subfolder\expdp_1020.DMP" for read ORA-27041: unable to open file OSD-04002: unable to open file O/S-Error: (OS 5) Access is denied. notes: 1) I get this also when removing the last slash in dba_directories 2) When trying with mapped drive P, instead of UNC, I get different OS error about not being able to read the file 3)I had to set the nologfile parameter because I was also having problems with writing the log file also. 4) I am able to write to the drive (hence the parfile existing there, and I am able to see the directory in windows explorer) 5) Our company does not have a Metalink account. 6) when trying to run impdp interactively I get this error Connected to
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 6.2 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up Can't import dump from mapped net drive using data pump up vote 0 down vote favorite I'm trying to import few users from http://www.orafaq.com/forum/t/161865/ .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. I'm not sure why, because I can both access that directory, and for example save a txt file there. Directory http://stackoverflow.com/questions/34384553/cant-import-dump-from-mapped-net-drive-using-data-pump 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. 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. Any help with what should I do? oracle import network-drive datapump impdp share|improve this question asked Dec 20 '15 at 18:51 Hisu 456 add a comment| 1 Answer 1 active oldest votes up vote 1 down vote accepted The problem is that your Oracle instance is running under different user account which doesn't have an access to the netwo
Pages ... options ORA-39002: invalid operation ORA-39000: bad dump file specification ORA-31640: unable to open dump ... http://www.orasites.net/q/40/ORA-31640%20unable%20to%20open%20dump%20file%20for%20read dump file "/prod/backup/oracle/export/qcap/qcap1.dmp0430_0121" for read ORA-27037: unable to obtain file ... Simulate "ORA-01152: file was not restored from a sufficiently old backup" EXPDP failed http://speed.m.baidu.com/pu=sz@1325_1325/s?st=111061_2&word=ora+31640&rq=ora+00202+27037&sa=brs_2&rsf=6&pqid=9572729834615706895 with ORA-39125: ... Oracle Apps DBA: March 2014 http://mtalmasri.blogspot.de/2014_03_01_archive.html Similar Pages ... specification ORA-31640: unable to open dump file "/mksysb/dumps/HILALB_30032014.dmp" for read ORA-27041: unable unable to ... mount: ORA-39000: bad dump file specification ORA-39001: invalid argument value ORA-39000: bad dump file ... unable to open file IBM AIX RISC System/6000 Error: 13: Permission denied Additional information: 2 Solution: ... Oracle: May 2012 http://chandu208.blogspot.de/2012_05_01_archive.html Similar Pages ... due to error: ORA-31640: unable to open unable to open dump file "/var/backup/omega/SYSFM_05.dmp" for read ORA-19505: ... widget? (More info) Tuesday, May 15, 2012 ORA-31693,ORA-31640,ORA-19505..... vi tabledata_impdp.par DIRE ... (4) ► July (7) ► June (1) ▼ May (1) ORA-31693,ORA-31640,ORA-19505..... ► April (2) ► March (3) ► ... Re[2]: Oracle impdp parallel issues - oracle-l - FreeLists http://www.freelists.org/post/oracle-l/Re2-Oracle-impdp-parallel-issues Similar Pages ... callout >>>ORA-31640: unable to open dump file >>>"/oraarchive101/exp/expdp_meter_y10_04.dmp" for read >>> ... due to error: >>>ORA-29913: error in executing ODCIEXTTABLEFETCH callout >>>ORA-31640: unable to open ... open dump file >>>"/oraarchive101/exp/expdp_meter_y10_05.dmp" for read >>>ORA-19505: failed to identify ... Windows Scripts | Shadab Mohammad http://easyoradba.com/scripts/windows-scripts/?replytocom%3D490%26replytocom%3D490%26replytocom%3D490%26replytocom%3D490#content Similar Pages ... options ORA-39001: invalid argument value ORA-39000: bad dump file specification ORA-31640: unable to open ... open dump file “E:\DATA_PUMP_DIR\backup.dmp;” for read ORA-27041: unable to open file OSD-04002: unable to ... to open file O/S-Error: (OS 2) The system cannot find the file specified. R