Home » RDBMS Server » Server Utilities » Databaseimport error (Centos 6, Oracle11g)
Databaseimport error [message #583959] Tue, 07 May 2013 06:40 Go to next message
abbymurali
Messages: 14
Registered: April 2013
Junior Member
Hi all,

I'm unable to do an import of a *.dmp file. Please find the console logs below.


[oracle@oracledbserver ASG1]$ cd /media/volume-01/u01/app/oracle/product/
[oracle@oracledbserver product]$ ls
11.2.0 20-04-2013full_backup.dmp full01-03-2013_backup.dmp new.dmp today.dmp
[oracle@oracledbserver product]$
[oracle@oracledbserver product]$
[oracle@oracledbserver product]$

[oracle@oracledbserver product]$ impdp full=Y directory=agge_dir dumpfile=/media/volume-01/u01/app/oracle/product/new.dmp NOLOGFILE=y;

Import: Release 11.2.0.1.0 - Production on Tue May 7 16:51:47 2013

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

Username: sys as sysdba
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-39088: file name cannot contain a path specification


[oracle@oracledbserver product]$


This is Oracle 11g hosted on an eucalyptus cloud instance.

Please help me to resolve this issue.

Regards
Unni.
Re: Databaseimport error [message #583960 is a reply to message #583959] Tue, 07 May 2013 06:48 Go to previous messageGo to next message
ramoradba
Messages: 2456
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
No Need to specify the full path there , It reads the path from directory parameter, all you have to specify for the dump file is Its Name Only.
Re: Databaseimport error [message #583962 is a reply to message #583960] Tue, 07 May 2013 07:07 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
... which is clearly specify in the error message:
"ORA-39088: file name cannot contain a path specification"
And the error messages book:
ORA-39088: file name cannot contain a path specification
 *Cause: The name of a dump file, log file, or sql file contains a
         path specification.
 *Action: Use the name of a directory object to indicate where the file
         should be stored.

Regards
Michel

Re: Databaseimport error [message #583963 is a reply to message #583962] Tue, 07 May 2013 07:08 Go to previous messageGo to next message
abbymurali
Messages: 14
Registered: April 2013
Junior Member
even that too i tried..

[oracle@oracledbserver product]$ impdp full=Y directory=AGGE_DIR dumpfile=new.dmp NOLOGFILE=y;

Import: Release 11.2.0.1.0 - Production on Tue May 7 17:36:44 2013

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

Username: sys as sysdba
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 "/u01/app/oracle/product/new.dmp" for read
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3


[oracle@oracledbserver product]$
[oracle@oracledbserver product]$
[oracle@oracledbserver product]$
[oracle@oracledbserver product]$ ls
11.2.0 20-04-2013full_backup.dmp full01-03-2013_backup.dmp new.dmp today.dmp
[oracle@oracledbserver product]$
Re: Databaseimport error [message #583964 is a reply to message #583963] Tue, 07 May 2013 07:11 Go to previous messageGo to next message
abbymurali
Messages: 14
Registered: April 2013
Junior Member
In my case the path to the .dmp file is different from the usual one ...here the dump file path is "/media/volume-o1/u01/app/oracle/product" so I specify the whole path .
Re: Databaseimport error [message #583965 is a reply to message #583964] Tue, 07 May 2013 07:14 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
As far as I can tell, you can't do that! File must be in a directory (physically) where Oracle directory object points to. If you want to have that file elsewhere, you need to create a new directory.
Re: Databaseimport error [message #583966 is a reply to message #583963] Tue, 07 May 2013 07:17 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Michel Cadot wrote on Tue, 07 May 2013 14:07
... which is clearly specify in the error message:
"ORA-39088: file name cannot contain a path specification"
And the error messages book:
ORA-39088: file name cannot contain a path specification
 *Cause: The name of a dump file, log file, or sql file contains a
         path specification.

 *Action: Use the name of a directory object to indicate where the file
         should be stored.


Regards
Michel

Re: Databaseimport error [message #583967 is a reply to message #583965] Tue, 07 May 2013 07:18 Go to previous messageGo to next message
ramoradba
Messages: 2456
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
or Copy the file from /media/volume-01/u01/app/oracle/product/new.dmp to /u01/app/oracle/product/

and use
impdp full=Y directory=AGGE_DIR dumpfile=new.dmp NOLOGFILE=y;
Re: Databaseimport error [message #583968 is a reply to message #583966] Tue, 07 May 2013 07:20 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
C:\>impdp help=y
...
DUMPFILE
List of dump files to import from [expdat.dmp].
For example, DUMPFILE=scott1.dmp, scott2.dmp, dmpdir:scott3.dmp.
...

See the 3rd file of the example.

regards
Michel

[Updated on: Tue, 07 May 2013 07:20]

Report message to a moderator

Re: Databaseimport error [message #584036 is a reply to message #583968] Wed, 08 May 2013 03:14 Go to previous messageGo to next message
abbymurali
Messages: 14
Registered: April 2013
Junior Member
Hello orafaq mates,

I resolved the issue...just did everything from the beginning.

Thanks for the support...

Regards,
Unni.
Re: Databaseimport error [message #584037 is a reply to message #584036] Wed, 08 May 2013 03:24 Go to previous message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
So describe the solution you apply and post your final command.

Regards
Michel
Previous Topic: Error while exporting
Next Topic: Estimate FlatFile Size
Goto Forum:
  


Current Time: Thu Mar 28 08:52:44 CDT 2024