Re: Database Instance

From: Barbara Baker <barbarabbaker_at_yahoo.com>
Date: Wed, 24 Dec 2003 08:39:24 -0800
Message-ID: <F001.005DB01F.20031224083924@fatcity.com>

You are (I presume) the keeper of the data, responsible for its integrity and safety

What you need to present to your manager is what risks to safety and integrity might be faced if all of the databases are rolled into one.

How closely tied are the applications for the 5 databases? If 1 application requires a patch for some reason and you've rolled all 5 apps into 1 database, all 5 will need to come down for a patch. If separate, you are able to patch up just the instance requiring the patch and leave the others running. If separate, upgrades will also be easier -- you can upgrade 1 database at a time, mimimizing down time.

All 5 apps will require exact same versions of database and patch level if rolled into a single instance. That may or may not be ok. If any of these apps require a maintenance window, all 5 must be down/restricted at the same time.

A lot of flexibility is compromised when 5 different apps are merged into a single database. Exactly how much difficulty that might cause depends on the apps.

There are a couple of benefits from folding all 5 into a single db. The big question is whether these benefits outweigh the lack of flexibility from havig all 5 in a single database.

Just some things to thing about.
Good luck!
Barb

• Kean Jacinta <jacintakean_at_yahoo.com> wrote:
  > Dear : All
  >
  > First and foremost , if i ask stupid question pls
  > forgive me coz i new to oralce. I have a question
  > here.
  >
  > I have a server, and this server contains 5 oracle
  > database. Each database contains 5 web application
  > that are running on live ( production server ). As i
  > understand abt oracle , every database that i
  > created
  > will have 1 instance. So since this server hold 5
  > database then i will have 5 instances running.
  >
  > Lately, my manager want me to remove all the
  > databases
  > and remain a single instance. I was wondering if i
  > move everything into single database then if one of
  > the application fail due to oracle error , then all
  > other four application will fail also rite ?
  >
  > Each of our web application needs to have 2 schema
  > and
  > both schema have to be transparent to each other.
  > While other application schema will be invisible to
  > each other. Since i have 5 web app then i will need
  > 10
  > schema.One major problem is all the 10 schema will
  > contain same table name. It will be a mess putting
  > so
  > much app in a single db .
  >
  > Pls correct me if i am wrong and do let me know what
  > are the pro and cons or maybe you can educate me
  > with
  > some of the best practice to setup a proper
  > production
  > server environment.
  >
  > Thank You
  >
  > Regards,
  > Jkean
  >
  >
  >
  >
  >
  > __________________________________
  > Do you Yahoo!?
  > New Yahoo! Photos - easier uploading and sharing.
  > http://photos.yahoo.com/
  > --
  > Please see the official ORACLE-L FAQ:
  > http://www.orafaq.net
  > --
  > Author: Kean Jacinta
  > INET: jacintakean_at_yahoo.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).
  

  ---

Do you Yahoo!?
Free Pop-Up Blocker - Get it now
http://companion.yahoo.com/

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

Received on Wed Dec 24 2003 - 10:39:24 CST