OraFAQ Forum: Server Administration » Migrating Database from Windows to Linux

Home » RDBMS Server » Server Administration » Migrating Database from Windows to Linux (Oracle 10 R1, Windows XP and Oracle Enterprise Linux AS 5)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Migrating Database from Windows to Linux [message #306474]

Fri, 14 March 2008 07:56

Creems
Messages: 70
Registered: July 2007
Location: Johannesburg

Member

Hi Experts,

Actually, I've gone through some topics in the forum relating to this but I am not satisfied enough.

Could you please if possible give me steps in migrating Oracle10g R1 on my Windos XP to Linux AS5 running Oracle10g R2.

Thanks in good anticipation.

Cherish

Report message to a moderator

Re: Migrating Database from Windows to Linux [message #306475 is a reply to message #306474]

Fri, 14 March 2008 08:03

ThomasG
Messages: 3212
Registered: April 2005
Location: Heilbronn, Germany

Senior Member

Three basic steps :

- Install Oracle on Linux
- Create the target database and the table spaces
- Export from source / Import on target

Report message to a moderator

Re: Migrating Database from Windows to Linux [message #306477 is a reply to message #306475]

Fri, 14 March 2008 08:11

Creems
Messages: 70
Registered: July 2007
Location: Johannesburg

Member

Thanks so much.

I already have Oracle on my Linux server. Is is that straight?

Report message to a moderator

Re: Migrating Database from Windows to Linux [message #306480 is a reply to message #306477]

Fri, 14 March 2008 08:27

ThomasG
Messages: 3212
Registered: April 2005
Location: Heilbronn, Germany

Senior Member

Then you can continue with step2, creating an empty database, with the same tablespaces as the original one.

Report message to a moderator

Re: Migrating Database from Windows to Linux [message #306570 is a reply to message #306474]

Fri, 14 March 2008 13:20

joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA

Senior Member

Additionally, you might want to look into transportable tablespace. I am not sure if it was 10g release 1 or 2 that allowed cross platform transportable tablespaces.

Report message to a moderator

Previous Topic:	Experimenting with the continous log mining
Next Topic:	'SYS' User login error

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Dec 02 03:53:22 CST 2024