Unanswered: Move Oracle 8.1.5/NT to Oracle 8.1.7/Win 2000
I need to move an Oracle 8.1.5 db that resides on Win NT 4 and move it to a Win 2000 platform at release 8.1.7. I am curious about how a few tasks will play out.
1. when I create the new db on Win 2000, should I use the same SID and the SID on the Win NT box? Will that cause problems for the users attaching to that SID? I'm guessing no, because you have to define the box (Win NT) in the SID definition)
2. will I need to go to each user workstation and change the SID/Machine they are connecting to so they can switch to the new db residing on Win 2000?