Dear :All Well we did not buy any application packages. Currently we are using open source product ...which is Apache and Tomcat.
By the way, have anyone ever have more than 5 database under a single server ? I heard that the best practice is to have 1 database n 1 application in a single server. Is that true ? Thank JKean --- "Mercadante, Thomas F" <[EMAIL PROTECTED]> wrote: > I would be very careful about doing this if you have > purchased application > packages. Sooner or later, you will want to upgrade > one of the packages, > and it will require a different release of Oracle - > and you will be stuck. > > > Tom Mercadante > Oracle Certified Professional > > -----Original Message----- > Sent: Wednesday, December 24, 2003 11:24 AM > To: Multiple recipients of list ORACLE-L > > > One other disadvantage of putting all instances > together is if you need to > say bounce the database (for parameter change or > other maintenance etc) > then all other applications will get affected. > Whereas with separate > instances other applications will not get affected. > > To some extent one application failing will not > affect other applications. > Except if one application does not close its > connections then it could lead > to maximum connections (sessions) being reached and > affecting other > applications. > > If the nature of the applications is different : > OLTP, warehousing then you > cannot really tune the parameters. > > On the positive side I think putting instances > together will lead to some > memory savings. > > I would suggest : Do not worry about who wants to > put the instances together > just list the advantages, disadvantages and make the > decision. > > [EMAIL PROTECTED] wrote: > > > It is not necessarily true that an error in one > application will affect all > applications. If there is a problem with oracle > instance or the database, > then all applications might be affected. > > Multiple schemas which have the same table names can > be a problem. If your > applications uses public synonyms, then you might > have a big problem. > > If everything is working fine now, it seems > pointless to move things around. > But this is philosophy. I do believe that isolating > applications from each > other as much as possible is usually a good thing. > "Good fences make good neighbors." (usually) > > But, if your manager insists on it, you have no > choice. Just do your best > to keep the old stuff around in case it becomes > apparent that the new way > will not work and you must go back to the old way. > > > -----Original Message----- > > Lately, m! y 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 > > > > > > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.net > -- > Author: > 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 > <http://us.rd.yahoo.com/slv/mailtag/*http://companion.yahoo.com/> > Pop-Up Blocker - Get it now > > __________________________________ 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).
