OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » Move to new Server (Oracle 10 R2 XE, Win2k3)

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

Move to new Server [message #660750]

Sun, 26 February 2017 04:44

chris2018
Messages: 16
Registered: February 2017

Junior Member

All,

haven't used any Oracle Database yet. We have no DBA, but I have to move Oracle 10 R2 XE on Windows 2003 SP2 to a new virtual machine. Given that I have no experience with Oracle I would just image the system partition and copy the data partition to the new machine. Windows is shutdown of course. Database is << 1 GB. Downtime shouldn't be a problem. That is I keep the existing directory structure and everything, except the hardware. Will there be any issues?

Just for curiosity: Is there a step by step manual howto re-install and import dumps created with expdp.exe?

- Chris

Report message to a moderator

Re: Move to new Server [message #660752 is a reply to message #660750]

Sun, 26 February 2017 05:02

Michel Cadot
Messages: 68757
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Database Installation Guide for Microsoft Windows x64
Database Utilities, Part I Oracle Data Pump
Database Backup and Recovery Basics

Report message to a moderator

Re: Move to new Server [message #660754 is a reply to message #660752]

Sun, 26 February 2017 05:12

chris2018
Messages: 16
Registered: February 2017

Junior Member

Thank you. I'll have a look at the manuals, but it's too complicated at first glance for a beginner.

Thus: is there anything against my described "imaging" approach?

Report message to a moderator

Re: Move to new Server [message #660756 is a reply to message #660754]

Sun, 26 February 2017 05:28

Michel Cadot
Messages: 68757
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

I know nothing about virtualization so can't help you on this point.
What I know is that Oracle put information in several places when installing itself: its home directory (you gave it), %SYSTEMDRIVE%\Program Files, registry...

Report message to a moderator

Re: Move to new Server [message #660758 is a reply to message #660750]

Sun, 26 February 2017 05:44

John Watson
Messages: 8976
Registered: January 2010
Location: Global Village

Senior Member

You didn't say what VM environment you are moving to, but if you follow whatever its method is for converting a physical machine to a VM I would think that the software installation and the database will survive. You may have an issue with networking if IP addresses change, the database listener might need reconfiguration.

Report message to a moderator

Re: Move to new Server [message #660759 is a reply to message #660758]

Sun, 26 February 2017 06:17

chris2018
Messages: 16
Registered: February 2017

Junior Member

Thank you! I will try that and report if it worked. Fortunately, I don't have to change anything on the existing machine so I could go back in worst-case.

Report message to a moderator