- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: any ideas as to why i got the following error ...
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-20-2003 08:21 AM
тАО10-20-2003 08:21 AM
any ideas as to why i got the following error messages
I am miffed as to why I'm getting the following errors:
IMP-00002: failed to open /mnt12/exports/idg8_18oct2003.dmp
for read
IMP-00021: operating system error - error code (dec 16, hex 0x10)
Import file: expdat.dmp >
Below is a sample of the export and import files:
"exp_idg2.par" 7 lines, 86 characters
owner=idg2
indexes=y
grants=y
rows=y
compress=y
file=/mnt12/exports/idg2_18oct03.dmp
"imp_idg2.par" 10 lines, 125 characters
buffer=100000
commit=y
fromuser=idg2
touser=idg2
rows=y
grants=y
ignore=y
indexes=n
file=/mnt12/exports/idg2_18oct2003.dmp
The only thing that I can see that may have caused the problem is that i did the export whilst running other imports at the same time.
The exports were all under 1GB.
Basically i was recreating a tablespace so the exports were for the objects owned by the various users who use that tablespace. I dropped the tablespace, recreated it with the same sizes and was about to import when I got the above errors. Any advice?
Thanks,
Nichelle
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-20-2003 01:42 PM
тАО10-20-2003 01:42 PM
Re: any ideas as to why i got the following error messages
The error you are experiencing is nothing to do with the tablespace re-creation. The import utility (imp) is unable to open the export dump file. Check the file permissions and if the user can read the file.
Explanation:
IMP-00021: operating system error - error code (dec 16, hex 0x10), you must check your OS manual for the respective error code ├в dec 16├в . Usually IMP-00002 and IMP-00021 errors occur when you are exporting to a tape and importing from the tape and your export dump file is very large.
The operating system error(dec 2, hex 0x2)indicates that the import utility could not find the file you specified. Make sure you are using the correct name for the .dmp file and that you are in the same directory as the .dmp or at least specify the complete unix path and name for the file.
The errors you are getting are consistent with the import executable not being able to read such a large file. 2Gig is the limit on import and export files. Try creating a named pipe and cat the contents of the export file to the named pipe, then use named pipe as the input for the import command.
The export dump file may have been transferred, but was not done in binary mode. Or EXPORT DUMP FILE IS TOO LARGE FOR IMPORT UTILITY.
Solution Explanation
To use the dump file, you will need to compress it first, then use the script. With the introduction of large file support on various platforms, export dump files greater than 2 GIG can be created. However, import still cannot read a dump file that is greater than 2 GIG, so you need to compress it first to a size under 2 GIG, then do the import via a pipe and the uncompress command.
I hope this helps
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-20-2003 07:20 PM
тАО10-20-2003 07:20 PM
Re: any ideas as to why i got the following error messages
ie try "ls -l /mnt12/exports/idg2_18oct2003.dmp"
However, contrary to what was said, there is no 2Gb (or other) limit on the size of files which imp/exp can handle. Provided that the o/s has largefiles enabled, imp/exp will handle whatever you throw at them. During a recent upgrade, our largest table exported to a 118Gb file, and imported ok. Took a while though....
-- Graham
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-20-2003 10:21 PM
тАО10-20-2003 10:21 PM
Re: any ideas as to why i got the following error messages
I feel that you are right!
that should be the problem
error no.16 for OS i s
EBUSY
The export file is busy with some other import.
Thanks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-22-2003 01:16 AM
тАО10-22-2003 01:16 AM
Re: any ideas as to why i got the following error messages
1. I checked the permissions on the exports and they were fine.
2. The exports were done to disk and the imports were done from disk.
3. All the exports files were under 1GB.
The last reply from T. G Manikandan said I was right about something. Were you refering to import and export being done together and this could have been the cause of the error? Your clarification will be greatly appreciated.
Thanks
Nichelle
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-22-2003 03:03 AM
тАО10-22-2003 03:03 AM
Re: any ideas as to why i got the following error messages
That is exactly what he meant. Error 16 = EBUSY, which implies that some other process is using that file.
Try the fuser command to see what processes are using the file. ie
"fuser -u /mnt12/exports/idg8_18oct2003.dmp"
"man fuser" for a detailed explanation.
-- Graham
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-22-2003 07:02 AM
тАО10-22-2003 07:02 AM
Re: any ideas as to why i got the following error messages
Tell me something though.
1. Does this mean the export file was *corrupted* because it was done at the same time as the import?
2.The import I was trying to do was totally unrelated to the import that was done when these exports were created . When I tried doing my import nothing else was being done so I'm not sure how another process could be using that file. I asume you mean the export dump file.
3. T.G Manikandan said that the export is busy with some other import.....I think I'm missing something....maybe I need to understand export/import some more...what does this mean? Is it that the same thing(for want of a better word) that does the export does the import as well....so an import and export cannot be done at the same time? Appreciate your advise again.
Nichelle
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-22-2003 07:23 PM
тАО10-22-2003 07:23 PM
Re: any ideas as to why i got the following error messages
Can't say whether it's corrupted or whether it's in use. Have you tried the "fuser" command. Also to see if it is readable at all try "cat /mnt12/exports/idg8_18oct2003.dmp
> /dev/null" - if this gives an error then the problem is with the file. If no error then the problem is with IMP.
2.
Is it possible that some other process (eg backup) was using the file?
3.
I think he was suggesting you may have been trying to import the file whilst an export process was still writing to it. However I have tried this, and it while generates an error, (IMP-00009: abnormal end of export file), it is not the one you are seeing.
Hope this helps.
If so, maybe you'd like to assign some points...
-- Graham
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-22-2003 10:06 PM
тАО10-22-2003 10:06 PM
Re: any ideas as to why i got the following error messages
-
Please allow me to suggest you to cross-check all your scripts for Export/Import. Most probably the EXP output file is same in more than 1 script running at the same time.
-
It happened to me once.
-
hope this helps too
-
regards
Yogeeraj
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-23-2003 03:07 AM
тАО10-23-2003 03:07 AM
Re: any ideas as to why i got the following error messages
1. I ran the
"fuser -u /mnt12/exports/idg8_18oct03.dmp" command and found that the file is not in use and i also ran the "cat /mnt12/exports/idg8_18oct2003.dmp > /dev/null" command and didn't get an error message thus i can only deduce(as you suggested) that the problem is with the IMP. This baffles me even more now because how can there be a problem with IMP when we can import from other dump files but cannot import from these specific dump files that were created (being exported) at the same time we were doing other totally unrelated imports. Did you mean that there was a problem with the EXP instead?
2. Is there's some unwritten rule which states that exports and imports even though they may be totally unrelated should not be performed simultaneously ?
Nichelle