Re: Database Instance

Good counsel. The assumption is made though that each database has it's own ORACLE_HOME, which may not be the case.

Jared

On Wed, 2003-12-24 at 08:39, Barbara Baker wrote:
> 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).
>

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