Home » Infrastructure » Linux » Oracle migration from Windows to Linux (Windows 2003 and Linux)
Oracle migration from Windows to Linux [message #328046] Wed, 18 June 2008 12:56 Go to next message
j_satya
Messages: 5
Registered: June 2001
Location: India
Junior Member

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 #328048 is a reply to message #328046] Wed, 18 June 2008 12:58 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
What is your Oracle version?
With certain versions, you can use RMAN to do cross-platform migration.
If the volume of data is small, simple export import will do.
Re: Oracle migration from Windows to Linux [message #328050 is a reply to message #328048] Wed, 18 June 2008 13:04 Go to previous messageGo to next message
j_satya
Messages: 5
Registered: June 2001
Location: India
Junior Member

My oralce version is Oracle 10g R2

and DB size is around 80GB
Re: Oracle migration from Windows to Linux [message #328051 is a reply to message #328050] Wed, 18 June 2008 13:09 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Easiest option is to export from 10g windows database and import into the 10g linux database.
If you are time pressed or would be doing it multiple times,
look into (google/search) "RMAN cross platform migration".
Re: Oracle migration from Windows to Linux [message #328052 is a reply to message #328046] Wed, 18 June 2008 13:09 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Database Backup and Recovery Advanced User's Guide
Chapter 15 RMAN Cross-Platform Transportable Databases and Tablespaces
Section Cross-Platform Transportable Database: RMAN CONVERT DATABASE

Regards
Michel
Re: Oracle migration from Windows to Linux [message #328053 is a reply to message #328052] Wed, 18 June 2008 13:21 Go to previous messageGo to next message
j_satya
Messages: 5
Registered: June 2001
Location: India
Junior Member

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 #328054 is a reply to message #328053] Wed, 18 June 2008 13:27 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>>after adding few datafiles by linux database is responding very slow. Any suggestions to improve the performance.
With the information provided, it is black box for us also.
We have no idea on what is happening.
May be your "server" is slow.
May be your "disks" are bad. It could be anything.
Post some valuable information to start with. Someone might help.
Re: Oracle migration from Windows to Linux [message #328061 is a reply to message #328046] Wed, 18 June 2008 14:05 Go to previous message
BlackSwan
Messages: 26766
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
Previous Topic: segmentation fault
Next Topic: Problem to Install Oraclce 11g on Linux
Goto Forum:
  


Current Time: Thu Mar 28 07:53:15 CDT 2024