2 instances, same machine

[Beantree]

I am upgrading to 9i, and intend on establishing a 9i instance on the same machine as 8i (windows 2k server).

I planned on establishing the 9i instance and moving the data via transportable tablespaces, manually re-establishing the schemas, and replacing everything else with scripts.

I want the 9i DB to have the same name and sid.

I don't think I can have both DB's on the same machine, with the same SID.

How can I do this? Temporary SID on 9i until 8i shut down, then change?

Thanks

 

[alexhu]

You can't have 2 instances of the same name on the same machine.

I would go for the tempoary name and then rename by recreating the controlfiles

Alex