Databases
cancel
Showing results for 
Search instead for 
Did you mean: 

A system problem with orcale database Import on HP8UX machine

MALKI
Occasional Advisor

A system problem with orcale database Import on HP8UX machine

When I tru to do an oracle database import with imp command I receive thos error message:IMP-00002: failed to open /opspdata2/dump_opsp_Sat.dmp for read
IMP-00021: operating system error - error code (dec 2, hex 0x2)
Can someone help me it's very important
malki
4 REPLIES
Sridhar Bhaskarla
Honored Contributor

Re: A system problem with orcale database Import on HP8UX machine

errno 2 correspond to No such file or directory. Did you check the permissions over /opspdata2/dump_opsp_Sat.dmp to see if you have read permissions for oracle?.

-Sri
You may be disappointed if you fail, but you are doomed if you don't try
linuxfan
Honored Contributor

Re: A system problem with orcale database Import on HP8UX machine

Hi Malki,


Oracle error IMP-00002 says - "Failed to open %s for read"

Make sure the dump file /opspdata2/dump_opsp_Sat.dmp is readable by oracle. Check the permissions

-Ramesh
They think they know but don't. At least I know I don't know - Socrates
Thierry Poels_1
Honored Contributor

Re: A system problem with orcale database Import on HP8UX machine

hi,

I agree with the 2 previous answers. You (oracle?) probable has no read permissions on the export file.

sorry for the late answer: could not access ITRC in the morning, and could not reply in the afternoon (troubles with the Europe server???) :((

regards,
Thierry.
All unix flavours are exactly the same . . . . . . . . . . for end users anyway.
Brian Crabtree
Honored Contributor

Re: A system problem with orcale database Import on HP8UX machine

Something else to consider is that versions of imp for HP-UX cannot read files over 2g in size. If the file is over this size, you might want to consider piping the information into the import command:

mkdir -p imp_pipe
cat expdat.dmp > imp_pipe &
imp file=imp_pipe