RE: Reducing the number of databases

Here we have 3 environments for most applications (dev, QA and prod) and all Oracle version are the same (8173 now). It works fine. And to save Oracle license costs, we also consolidated some db servers by putting multiple instances on one server machine. No problem so far.

Guang
  -----Original Message-----
  From: ml-errors_at_fatcity.com [mailto:ml-errors_at_fatcity.com]On Behalf Of AK   Sent: Friday, September 19, 2003 12:50 PM   To: Multiple recipients of list ORACLE-L   Subject: Re: Reducing the number of databases

  I have seen more requirement for individual development databases ( where ind schema is not possible ) due to complexity of application . Developers step on each other if they work of same database . A pl/sql developer is invalidating procedure while a java developer is trying to make his program work.

  -ak

• Original Message ----- From: Stephane Paquette To: Multiple recipients of list ORACLE-L Sent: Friday, September 19, 2003 8:59 AM Subject: Reducing the number of databases

    Hi,

    We have around 120 databases. Most applications have 5 environments
(dev, test, integrated test, acceptance, prod) some applications have more.
The applications are a mix of home developped and bought application
(peoplesoft, harvest, compass,...)

    New applications are coming in.
    New databases will appear soon with DB2UDB.

    All servers are unix/aix, there are 15 production server and around 10 servers for the dev, test, integrated test and acceptance databases.

    All databases are at 8172 except 6-7 databases and planning to go to 9i in 2004. Off course we see the migration like a pain.

    We want to reduce the number of databases and instances.     To obtain a significative gain I think we must reduced to around 60 databases.

    Anybody has done the task to consolidate on less servers and les databases ?

    One way to do it would be to go with

        2 instances of dev
        2 instances of test
        2 instances of integrated test
        2 instances of acceptance
        all prod instances are standalone.

    Food for thought
        backup
        Oracle version
        availability
        naming convention of objects
        security
        ...

    All feedback is welcome.

    Stephane Paquette
    Administrateur de bases de donnees

    Database Administrator

    Standard Life

    www.standardlife.ca

    Tel. (514) 499-7999 poste 7470 et (514) 925-7187

    stephane.paquette_at_standardlife.ca

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Guang Mei
  INET: gmei_at_incyte.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).