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"
<thomas.mercadante_at_labor.state.ny.us> 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.
>
> Stephen.Lee_at_DTAG.Com 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: Stephen.Lee_at_DTAG.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
>
<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: 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).
Received on Fri Dec 26 2003 - 00:59:25 CST
