on 11-27-2008 8:18 AM
Hi there,
What could be my migration strategy in the following scenario?
ECC is running on Windows (lets say, 2000) with Oracle 9i. We have to migrate from Windows 2000 to 2003.
I have formulated the following strategies (theoritically) and I dont know which one of these will work?
Strategy 1
========
a) Shutdown the ECC and Oracle Database.
b) Upgrade from Windows 2000 to Windows 2003.
c) Start the Oracle Database.
d) Start the ECC.
My Queries Relating to Strategy 1
=========================
When you upgrade the OS (in our example, from Windows 2000 to 2003, DLLs will get updated, among many other things (several Registry Settings)? These OS DLLs are also needed at the time of Oracle Installations. Therefore, I am in doubt, if this strategy works. Am I correct in my approach?
Strategy 2
========
a) Shutdown the ECC and Oracle Database.
b) Perform a full offline backup of Oracle Database.
c) Remove Oracle Software and Database.
d) Upgrade from Windows 2000 to Windows 2003.
e) Reinstall Oracle Software.
f) Perform Homogeneous System Copy using Oracle Backup and Restore Method.
Strategy 3
========
a) Perform an export using Heterogeneous System Copy method.
b) Remove Oracle Software and Database.
c) Upgrade from Windows 2000 to Windows 2003.
d) Reinstall Oracle Software.
e) Perform an import using Heterogeneous System Copy method.
Your comments are highly appreciated.
Regards.
Herbinger.
Hi,
Best approach is to do Homogenous System copy.
Hetrogenous System copy will come into account only if you plan to change the database or operating system from windows to *nix OS.
Just give you an overview
1. Export Database from the system
2. Install Microsoft Windows 2003 Server
3. Install Database
4. Start the import with installation
5. Post import activities
Hope it helps
Regards
KT
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
> Strategy 1
> ========
>
> a) Shutdown the ECC and Oracle Database.
> b) Upgrade from Windows 2000 to Windows 2003.
> c) Start the Oracle Database.
> d) Start the ECC.
> When you upgrade the OS (in our example, from Windows 2000 to 2003, DLLs will get updated, among many other things (several Registry Settings)? These OS DLLs are also needed at the time of Oracle Installations. Therefore, I am in doubt, if this strategy works. Am I correct in my approach?
On Windows there is no "relink" process necessary - you can use that way.
I would do a backup of everything before (of course).
Markus
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
82 | |
10 | |
10 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.