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 <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED] > > > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
