Thanks, Raj. >> Hmmmm... it is probably not an good example ... Why not? On the contrary. I am sure damanagement here would love to here this. Besides it fully supports Oracle's statement that application can be migrated to RAC "as is" (as I think Hemant mentioned).
Wait... did you say 9i? release 2? recently? - may be it's a Christmas magic that made it happen for you? (although those sceptical might say that it had to do with your careful app "partitioning"/segmentation rather than a festive season) On a more serious note the following guidelines look interesting: http://download-west.oracle.com/docs/cd/A97630_01/rac.920/a96600/migrate.htm#1013313 "Migrate to RAC ... unless your application was specifically designed to not use cluster database processing". I wonder why would somebody do that? --- "Jamadagni, Rajendra" <[EMAIL PROTECTED]> wrote: > Hmmmm... it is probably not an good example but we > too have a (couple of) > mission critical app (affects on air production) > running on 9i RAC. One of > which has two major schema. We logically partitioned > the application such > that, for two groups of people 9accessing one schema > each) we gave them a > preference. > > Schema1 users have tns entry for db1 and fail over > to db2 > Schema2 users have a preference for db2 with a fail > over to db1 > > This effectively allows us to do load balance, they > don't share too much > data, so traffic through interconnect is manageable. > If need be, we just > shutoff listener on one side, and everyone fails > over to the other side > while we can perform maintenance. All their > applications are written in VB, > JAVA so they handle fail over from within > application. > > None of the people involved in the design worried > about which side of RAC > they will be on and how the DML activity affects etc > etc. They designed a > plain application with a good design and it is > working fine. > > Like I mentioned this is not a good example ... but > this is how we did it in > one of our major application. > Raj > ______________________________________________________ > Rajendra Jamadagni MIS, ESPN Inc. > Rajendra dot Jamadagni at ESPN dot com > Any opinion expressed here is personal and doesn't > reflect that of ESPN Inc. > > QOTD: Any clod can have facts, but having an opinion > is an art! > > *********************************************************************This > e-mail message is confidential, intended only for > the named recipient(s) above and may contain > information that is privileged, attorney work > product or exempt from disclosure under applicable > law. If you have received this message in error, or > are not the named recipient(s), please immediately > notify corporate MIS at (860) 766-2000 and delete > this e-mail message from your computer, Thank > you.*********************************************************************1 > ______________________________________________________________________ Post your free ad now! http://personals.yahoo.ca -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boris Dali 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).