I would consolidate and migrate at the same time. It makes your job a little more complicated (you will want to test your applications on 9i before you mograte your production instances at some point), but you will be solving the migration to 9i sooner rather than later.
Tom Mercadante Oracle Certified Professional -----Original Message----- Sent: Wednesday, August 06, 2003 2:29 PM To: Multiple recipients of list ORACLE-L Just got out of a meeting with my manager. He had just finished meeting with our Oracle rep and has finally figured out that we don't have enough licenses (I've always asked him what we have and he's never shared it with me, always just "I've gotten it taken care of"). We have 80 and with our current/potential configuration we are going to need 300. Anyways, to save money he decides that we need to take our databases and consolidate them to two or three servers (from 7). Most of the database are fairly small (100-300Meg) so shouldn't be too bad. Actually it should be pretty fun (if I didn't already have 5 full-time jobs to do). Anyone had to do the same thing? What are some concerns? Should I shoot for the moon and upgrade them all to 9i at the same time or have several versions (7.3, 8.0, 8.1.7) on the same server? Any comments would be greatly appreciated. Thanks, Jeff -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Eberhard, Jeff INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).