Re: A move from UNIX to NT

Nigel Wingate wrote in message <3585fb84.355233832_at_news.mr.net>...
>I foresee the following jobs:
>
>Install Oracle on NT

Read the Oracle for NT guide carefully, as there are quite a number of differences in how Oracle is implemented on NT (essentially it is 'service' based). Look at oradimXX.exe in particular, as it's not a tool you will have used on UNIX based Oracle.

As someone else suggested, check the performance of your system. Make sure you re-configure Oracle (init.ora, datafile layout, etc.) to make maximum use of the *new* machine. Don't just 'go with what you already have', as it may be wrong when run against the new system. And test, test, test. And benchtest.

Look long and hard at backup and recovery, as again it's very different on NT. Look at server recovery as well as Oracle. And test long and hard.

>Export the existing database to NT

No problem. If it's big, it might take some time to import, though. Do some tests first. Oh, and make sure you copy the dump file across as 'binary' (I tend to use good old ftp).

>Re-compile all the COBOL programs for NT

Sorry, it's 10 years since I touched COBOL. :-) I take it you'll also need the COBOL pre-compiler (Pro-COBOL) as well? Again, just port and test. Allow *lots* of time for sorting out problems.

>Convert the shell scripts to Korn Shell so they can run under MKS
>Toolkit on NT. Also adjust scripts for new paths, disks, directories,
>etc

MKS scripts should work OK, as long as you use a compatible shell and no funny, non-standard extensions in your scripts. Obviously all the directory specifications will have to be changed. And look out for calls to UNIX tools that MKS might not implement.

>Test new system until it replicates old one
>Go live

Hey, you've reached the two easy bits! :-) As I said above, give yourself plenty of time.

>
>I'm sure there is more to it than this and if anyone can help, I'd
>love to hear from you. I can't be the first to do this and if there
>is any Web based documentation on how to do it, please point me in
>that direction.
>
Received on Wed Jun 17 1998 - 05:22:05 CDT