timallen
Well Known Member
We are moving our Enterprise/Data server from one NT machine to another. I've seen several previous posts about this, but none that combined exactly what I'm doing.
The server name will change (let's say OLD_SERVER -> NEW_SERVER). Here is how we have thought to do it: (This is OneWorld Xe, no service packs or updates (it's a long story), Oracle 8.1.7 database)
1) Create an identical database on the new server: Copy the Oracle DBF files from OLD_SERVER to NEW_SERVER, create a new database with the same name as the old database, and direct it to use the copied DBF files.
2) Change data sources to point at NEW_SERVER. Turn off the OLD_SERVER to make sure we aren't accidentally using it.
3) Shake a chicken.
4) Create an installation plan (Add Server) with the parameters of the NEW_SERVER. Run it.
5) Install the Enterprise Server software on NEW_SERVER from the CD.
6) Test by running some UBEs on NEW_SERVER
7) Deinstall server software and drop JDE tablespaces on OLD_SERVER.
8) Test again.
9) Do victory dance.
Does this look correct? Is there a good KG document on how to do this?
Thanks in advance.
The server name will change (let's say OLD_SERVER -> NEW_SERVER). Here is how we have thought to do it: (This is OneWorld Xe, no service packs or updates (it's a long story), Oracle 8.1.7 database)
1) Create an identical database on the new server: Copy the Oracle DBF files from OLD_SERVER to NEW_SERVER, create a new database with the same name as the old database, and direct it to use the copied DBF files.
2) Change data sources to point at NEW_SERVER. Turn off the OLD_SERVER to make sure we aren't accidentally using it.
3) Shake a chicken.
4) Create an installation plan (Add Server) with the parameters of the NEW_SERVER. Run it.
5) Install the Enterprise Server software on NEW_SERVER from the CD.
6) Test by running some UBEs on NEW_SERVER
7) Deinstall server software and drop JDE tablespaces on OLD_SERVER.
8) Test again.
9) Do victory dance.
Does this look correct? Is there a good KG document on how to do this?
Thanks in advance.