RE: Consolidating Servers

This is exactly what I am working on right now! We have to consolidate down from about 5 servers to 2 (Prod. and Test/Dev.). My approach is to just move (clone) the DBs first. That's a job in itself, considering that the production DBs need to be moved during weekend hours. Leave original DB on original server just in case something fails. Take a cold backup, move files to new server, rebuild control file from trace to create clone. Point apps at clone and test. If all is well, archive original DB to tape for a month or two to be safe.

By the way, this required me to install 4 versions of Oracle (8.1.7 to 9.2.0.3) in 4 Oracle Homes on the new Production server. Upgrading all to 9iR2 is another project.

Best regards,

David B. Wagoner
Database Administrator
Arsenal Digital Solutions

-----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: Jeff.Eberhard_at_Rolls-RoyceGS.com

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: ListGuru_at_fatcity.com (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: David Wagoner
  INET: dwagoner_at_arsenaldigital.com

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: ListGuru_at_fatcity.com (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).