Home » RDBMS Server » Server Administration » Oracle Export Import Utility Different Versions (AIX 6.1 64bit - Oracle 10gR2 (10.2.0.5.0))
Oracle Export Import Utility Different Versions [message #554056] Thu, 10 May 2012 03:36 Go to next message
Rektanocrit
Messages: 24
Registered: September 2011
Location: Philippines
Junior Member

We are migrating
from [IBM P5 - AIX 5.3 - Oracle DB 10.2.0.1 64bit]
to [IBM P7 - AIX 6.1 - Oracle DB 10.2.0.5 64bit]

The new database is already up and running, our next step now is the following:
1. Create Tablespaces (done)
2. Export the Database from P5
3. Import the dump to P7.

We have this following options:

I. Use a Windows XP workstation 32bit with Oracle 10.2.0.1 Database software to export from P5, then import the dump to P7. (Export/Import Utility 10.2.0.1 Windows 32bit)

II. Use the Export Utility of the P7 (10.2.0.5 AIX 64bit) to do the export and import.

III. Use the Export Utility of P5 (10.2.0.1 AIX 64bit) then use the Import Utility of P7 (10.2.0.5 AIX 64bit)

Can someone give me an advice what to do? And what problem might I encounter?

BTW, our colleague tried to do the following:
A. Use Windows - Export Utility 10.1.0.2.0 - 32bit to make a dump of our database (Oracle 10.2.0.1.0 AIX 64bit)
B. Use Windows - Import Utility 10.1.0.2.0 - 32bit to import the dump file from step A to our new database (Oracle 10.2.0.1.0 AIX 64bit)

But after issuing
imp system/password@NEWDB file=(a.dmp, b.dmp... c.dmp) full=y ignore=y statistics=none

The import seems to hang here...
importing SYSTEM's objects into SYSTEM
Re: Oracle Export Import Utility Different Versions [message #554059 is a reply to message #554056] Thu, 10 May 2012 03:44 Go to previous messageGo to next message
Michel Cadot
Messages: 67809
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
If possible, Use import Data Pump in P7 to directly import the custom objects through network (db link), no export needed.
Do not use old export/import utilities for this.

Regards
Michel
Re: Oracle Export Import Utility Different Versions [message #554063 is a reply to message #554059] Thu, 10 May 2012 03:56 Go to previous messageGo to next message
John Watson
Messages: 8531
Registered: January 2010
Location: Global Village
Senior Member
@Michel, I would be interested to know if you have found the network mode to perform well for large operations, such as this. The last time I tried it, network mode was actually slower than an export then an import. I never found out why. I was changing several things: 11.1.0.6 to 11.2.0.2, Sun v490 to Sun T3-2, UFS to ZFS, EE to SE.
Is it possible that network mode always uses the external table path, not the direct path?
Re: Oracle Export Import Utility Different Versions [message #554065 is a reply to message #554063] Thu, 10 May 2012 04:20 Go to previous messageGo to next message
Michel Cadot
Messages: 67809
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
I would be interested to know if you have found the network mode to perform well for large operations, such as this


The problem is that you can't really use parallelism with network import.
It is indeed less performant than an export/import but it has the advantage to be easy to use.
If time is an issue then it is better to export in parallel then import, I always use this mode when operation is large.

Quote:
Is it possible that network mode always uses the external table path, not the direct path?


I have to admit I don't know (and didn't search for till now).

Regards
Michel
Re: Oracle Export Import Utility Different Versions [message #554125 is a reply to message #554065] Thu, 10 May 2012 08:32 Go to previous messageGo to next message
John Watson
Messages: 8531
Registered: January 2010
Location: Global Village
Senior Member
Thank you for sharing your experience, it is nice to know that it isn't just me.

And back to the original question, the easiest way to see if Data Pump is hanging or working is to query v$session_longops.
Re: Oracle Export Import Utility Different Versions [message #554126 is a reply to message #554125] Thu, 10 May 2012 08:54 Go to previous message
Michel Cadot
Messages: 67809
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Note that OP didn't use Data Pump but old export/import, the first to do for him is to use Data Pump (in parallel mode).

Regards
Michel
Previous Topic: Cannot start listener (/tmp related)
Next Topic: Cause of invalid objects
Goto Forum:
  


Current Time: Sun Apr 11 04:23:40 CDT 2021