Oracle migration from Windows to Linux [message #328046] |
Wed, 18 June 2008 12:56  |
|
Hi All,
I want to migrate my database from wndows 2003 to Linux OS. So could you please provide me step by step guide if you have any document related to this As i am new to this technology.
Please provide documentation for testing databases.
Thanks,
Satya
|
|
|
|
|
|
|
Re: Oracle migration from Windows to Linux [message #328053 is a reply to message #328052] |
Wed, 18 June 2008 13:21   |
|
I am not familiar with Rman process and hence doing with export and import using data pump.
Following are the steps I am implementing and suggest if I need to execute any script to verify etc.
1. Complete export of the source database from Windows m/c using expdp
2. Creating the tablesspaces on target database i.e. on Linux
3. Import the data using impdp
But, while creating the tablespaces, after adding few datafiles by linux database is responding very slow. Any suggestions to improve the performance.
Thanks
Satya
[Updated on: Wed, 18 June 2008 13:24] Report message to a moderator
|
|
|
|
Re: Oracle migration from Windows to Linux [message #328061 is a reply to message #328046] |
Wed, 18 June 2008 14:05  |
 |
BlackSwan
Messages: 26763 Registered: January 2009 Location: SoCal
|
Senior Member |
|
|
in case this might apply....
From Note:119119.1
IMPORTANT:
* For the moment, do NOT use Expdp/Impdp when going to UTF8 or a other multibyte
characterset on ALL 10g versions including 10.1.0.5 and 10.2.0.3.
Also 11.1.0.6 is affected.
It will provoke data corruption unless you applied Patch 5874989!
This is caused by the impdp Bug 5874989.
The "old" exp/imp work fine. This problem is fixed in the upcoming
10.2.0.4 and 11.1.0.7 patch set.
All existing patches for this bug are found here:
http://updates.oracle.com/download/5874989.html
For 10.1.0.5, 10.2.0.2, 10.2.0.3 and 11.1.0.6 you can ask a backport
for Bug 5874989 if there is not yet a patch for your version/platform
|
|
|