Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2317
  • Last Modified:

Oracle DataPump

Hi,

I have exported 2 schemas from a Oracle Database on a Linux server and I am trying to import them into an Oracle 11G R2 database on a red hat linux server.

The Server I am trying to import it onto is new and this is the first schema I have imported.

When I run the the Command

./impdp System@<SERVERNAME> schemas="<SchemaName>" dumpfile="File.dmp" I get the following errors:

Import: Release 11.2.0.1.0 -
Production on Fri Oct 21 16:50:42 2011

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  
All rights reserved.
Password:

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 -
64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

ORA-39001: invalid argument value

ORA-39000: bad dump file specification

ORA-31640: unable to open dump file "/database/oracle/product/11.2.0/dbhome_1/rdbms/log/Entrader_Dev_2000.dmp" for read

ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory

Additional information: 3

If you have any ideas please let me know.
0
Contigo1
Asked:
Contigo1
  • 6
  • 5
4 Solutions
 
sdstuberCommented:
you must use a directory object  

that object is declared in the database and points to an operating system directory

check dba_directories.  make sure the paths you are using are defined there  and you have access to them.  read/write on the directory object


and oracle has read/write on the os paths
0
 
Contigo1Author Commented:
The Directory I am using is the directory called dpdump which is in the admin folder. Do I still need to specify the Directory if I am using this one?

0
 
sdstuberCommented:
>>> dpdump which is in the admin folder.

I don't know what you mean by that.

oracle directories are distinct objects, they don't have "folders" or any other type of container hierarchy
even though the underlying filesystems they point to might
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
Contigo1Author Commented:
The Directory called $ORACLE_HOME\admin\dpdump

It comes as standard when you install oracle.

on the previous server we used to stick the dumpfiles in this location and they would import perfectly fine. on this server I stick the dump files in there and get loads of errors.

0
 
sdstuberCommented:
$ORACLE_HOME\admin\dpdump  is an os directory

you need to use oracle directories that point to os directories.


is anything in dba_directories pointing to that directory?  


0
 
Contigo1Author Commented:
but I found a directory that points to

/database/oracle/product/11.2.0/dbhome_1/rdbms/log/
0
 
Contigo1Author Commented:
My last comment ment to say:

I found a directory by running:

SELECT directory_path FROM dba_directories WHERE directory_name = 'DATA_PUMP_DIR'

and It came back with the following loaction:

/database/oracle/product/11.2.0/dbhome_1/rdbms/log/

Should I put the dumpfile in there and use the directory="DATA_PUMP_DIR" arguement in the impdp command?
0
 
sdstuberCommented:
if you don't specify an oracle directory object  it will default to DATA_PUMP_DIR

if DATA_PUMP_DIR points to the "dpdump" directory, then it should work.
if DATA_PUMP_DIR points to the "log" directory then you need to put your dump file there.

if you don't have DATA_PUMP_DIR  you need to either create it,  or you need to specify the directory you want to use on the command line

based on this error

ORA-31640: unable to open dump file "/database/oracle/product/11.2.0/dbhome_1/rdbms/log/Entrader_Dev_2000.dmp" for read

Open in new window


it looks like you are using the default and your default is pointing to the log directory.
So, you need to either change the directory to point to where you are putting your files
OR put your files where the directory points to
0
 
sdstuberCommented:
sorry, I was typing my response to http:#37007833 while you were posting your followup

0
 
Contigo1Author Commented:
I have put the dumpfile in the directory below and run the command and it seems to be working ok

/database/oracle/product/11.2.0/dbhome_1/rdbms/log/

I will let you know how I get on.
0
 
Contigo1Author Commented:
The Problem has been solved by what you suggested.

Thanks for the help.

0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 6
  • 5
Tackle projects and never again get stuck behind a technical roadblock.
Join Now