RE: Consolidating Servers

Agree. The fewer variables you change the easier it is to figure out what is going wrong. Now depending on the OS that your migrating to you may well have to change block sizes.

Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA

-----Original Message-----
Sent: Wednesday, August 06, 2003 3:10 PM To: Multiple recipients of list ORACLE-L

Jeff,

Don't mix missions. Consolidating to the same server is one thing. Consolidating to the same version of software is another thing entirely.

Your boss's goal is to reduce the number of CPUs, not the number of databases or ORACLE_HOMEs. Get his/her primary mission done first (i.e. Reduce number of CPUs to license), then consider consolidating databases or versions. So, I'd recommend copying entire directory structures to the remaining servers, each under different OS accounts/groups.

My $0.02...

-Tim

on 8/6/03 11:29 AM, Eberhard, Jeff at Jeff.Eberhard_at_Rolls-RoyceGS.com wrote:

> 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: Tim Gorman
  INET: tim_at_sagelogix.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: Goulet, Dick
  INET: DGoulet_at_vicr.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).