Home » RDBMS Server » Server Utilities » IMPDP (ORA-31619: Invalid dump file) (Oracle 10.2.0.5 AIX 64bit & Oracle 10.1.0.2 Windows 32bit)
IMPDP (ORA-31619: Invalid dump file) [message #555809] Tue, 29 May 2012 02:07 Go to next message
Rektanocrit
Messages: 24
Registered: September 2011
Location: Philippines
Junior Member

I need to recreate/ clone my database to a new machine. The two machine are not connected in the network.

Step 1. (Oracle 10.2.0.5 AIX 64-bit)
expdp username/password@db1 full=y dumpfile=dp:fpac052912_dp%U.dmp logfile=dp:fpac052912_expdp.log job_name=full_exp

Step 2.
FTP dump files to Windows

Step 3. (Oracle 10.1.0.2 Windows 32-bit)
impdp username/password@db1 dumpfile=dp:fpac052912_dp%U.dmp logfile=dp:fpac052912_impdp.log full=y

I got:
ORA-39001: invalid argument value
ORA-39000: bad dump file specification
ORA-31619: invalid dump file "C:\P7DB\fpac052912_dp01.dmp"


Done in AIX:
create directory dp as '/bak'
grant read, write on directory dp to public;
grant exp_full_database to username;

Done in Windows:
create directory dp as 'C:\P7DB\';
grant read, write on directory dp to public;
grant exp_full_database to username;
grant imp_full_database to username;
Re: IMPDP (ORA-31619: Invalid dump file) [message #555811 is a reply to message #555809] Tue, 29 May 2012 02:23 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
1/ The directory must be located in the database server
2/ Do not tell what you did and saw: SHOW US.
3/ Are you sure you did your ftp in BINARY mode?

Regards
Michel
Re: IMPDP (ORA-31619: Invalid dump file) [message #555818 is a reply to message #555811] Tue, 29 May 2012 02:49 Go to previous messageGo to next message
Rektanocrit
Messages: 24
Registered: September 2011
Location: Philippines
Junior Member

1/ The directory must be located in the database server
2/ Do not tell what you did and saw: SHOW US.
3/ Are you sure you did your ftp in BINARY mode?

1. The directory is located in the database server
2. Go to X;
3. I used fireFTP to transfer my dumps. How can I be sure that it was in binary mode?

X:
On the AIX Machine (Oracle 10.2.0.5 AIX 64bit):
I have a database named fpac2, then I performed the following:
0. su - oracle
1. mkdir /bak/dp
2. chown -R oracle:oinstall /bak/dp
3. chmod -R 775 /bak/dp
4. sqlplus sys@fpac2 as sysdba
4.1 create user cpi identified by xxx;
4.2 grant dba to cpi;
4.3 create directory dp as '/bak/dp';
4.4 grant read, write on directory dp to public;
4.5 grant exp_full_database to cpi;
4.6 exit
5. expdp cpi/xxx@fpac2 full=y dumpfile=dp:fpac052912_dp%U.dmp logfile=dp:fpac052912_expdp.log job_name=full_exp

This made 11 dump files. After that I use fireFTP to copy those dump files to my Windows machine.
Then I copy those dump files to my external hdd and paste it on the other machine that is not connected in the network.

On my Windows machine (Oracle 10.1.0.2 Windows 32bit):
I created a database named p7db, then create and run a script for tablespaces (based on the fpac2 database).
1. mkdir C:\p7db
2. sqlplus sys@p7db as sysdba
2.1 create user cpi identified by xxx;
2.2 grant dba to cpi;
2.3 create directory dp as 'C:\p7db';
2.4 grant read, write on directory dp to public;
2.5 grant exp_full_database to cpi;
2.6 grant imp_full_database to cpi;
2.7 exit
3. impdp cpi/xxx@p7db dumpfile=dp:fpac052912_dp%U.dmp logfile=dp:fpac052912_impdp.log full=y

ORA-39001: invalid argument value
ORA-39000: bad dump file specification
ORA-31619: invalid dump file "C:\P7DB\fpac052912_dp01.dmp"

I saw some discussion related to the ora errors I encountered and some of them are saying "typically exp is higher version than imp", I am now planning to upgrade my oracle software on windows. This is my first time to actually performed data pump so please bear with me. Thanks! Smile

[Updated on: Tue, 29 May 2012 02:51]

Report message to a moderator

Re: IMPDP (ORA-31619: Invalid dump file) [message #555822 is a reply to message #555818] Tue, 29 May 2012 02:56 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
I used fireFTP to transfer my dumps. How can I be sure that it was in binary mode?

I don't know fireFTP. is it a GUI or a command line program?

Regards
Michel
Re: IMPDP (ORA-31619: Invalid dump file) [message #555824 is a reply to message #555822] Tue, 29 May 2012 02:57 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
I saw some discussion related to the ora errors I encountered and some of them are saying "typically exp is higher version than imp",


The first reason is not binary transfer, the second one is indeed that the target database is lower than the source. Ih this later case, you have to export (and import) using the utility of the lowest version.

Regards
Michel
Re: IMPDP (ORA-31619: Invalid dump file) [message #555828 is a reply to message #555824] Tue, 29 May 2012 03:14 Go to previous messageGo to next message
Rektanocrit
Messages: 24
Registered: September 2011
Location: Philippines
Junior Member

Thanks Michel Cadot! I am now upgrading to Oracle 10.2.0.5.0 for windows. I'll reply if it is really the solution. BTW, the fireFTP was already here when I got here.. It is opened in the browser. GUI it is! Very Happy
Re: IMPDP (ORA-31619: Invalid dump file) [message #555829 is a reply to message #555828] Tue, 29 May 2012 03:33 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Generally speaking, you should use ASCII mode for pure text documents. Everything else is BINARY (images, executables, MS Word documents, blabla, Oracle export files, ...). If it is a GUI, then there must be some option (toolbar button, checkbox, radio button, whatever) which sets the mode. If you did that from the command prompt, you'd specify binary mode by the same keyword:
M:\>ftp my_ftp_site
Connected to my_ftp_site.
220 my_ftp_site FTP Server (Version 4.2) Ready.
User (my_ftp_site:(none)): system
331 Username SYSTEM requires a Password
Password:
230 User logged in.
ftp> binary
200 TYPE set to IMAGE.
ftp> ascii
200 TYPE set to ASCII.
ftp> ?
Commands may be abbreviated.  Commands are:

!               delete          literal         prompt          send
?               debug           ls              put             status
append          dir             mdelete         pwd             trace
ascii           disconnect      mdir            quit            type
bell            get             mget            quote           user
binary          glob            mkdir           recv            verbose
bye             hash            mls             remotehelp
cd              help            mput            rename
close           lcd             open            rmdir
ftp>
Re: IMPDP (ORA-31619: Invalid dump file) [message #556215 is a reply to message #555809] Thu, 31 May 2012 22:40 Go to previous messageGo to next message
Rektanocrit
Messages: 24
Registered: September 2011
Location: Philippines
Junior Member

This solved my problem:

Solution A:
I upgraded my oracle software on my target machine/DB to 10.2.0.5 then performed impdp, import successful.

Solution B:
In my expdp script on Oracle version 10.2.0.5, I added VERSION=10.1.0.2
Re: IMPDP (ORA-31619: Invalid dump file) [message #556229 is a reply to message #556215] Fri, 01 June 2012 01:02 Go to previous message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Thanks to let us know these solutions.

Regards
Michel
Previous Topic: How to backup?
Next Topic: Transport Tablespace with database link
Goto Forum:
  


Current Time: Thu Mar 28 06:30:54 CDT 2024