I have one more question: When upgrading a DB from 8.1.7 to 9.2, I presume I need as much available HD space as the size of the DB to be upgraded? The migration guide says the migration assistant will check for available disk space but currently I am trying to see if my existing server has enough HD space. If not, I won't bother install Oracle 9.2 software on the server (maxed out the storage) but to build anther one.
What happen after the upgrade? I will have two set of same DB, one for 8i and the other for 9i?
I hope 8i and 9i's listeners won't both default to 1521 right after the install...
I just installed Oracle 9i software only (with no new DB installed) on a Windows 2000 system with existing 8i home. I notice there is NO 9i listener installed but the existing 8i is still there and running.
The 9i home is completed seperated from the 8i's. Does anybody know why no 9i listener is installed (thus I don't see it in Windows 2000 "Services")