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"
<Rajendra.Jamadagni_at_espn.com> 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: boris_dali_at_yahoo.ca
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 Wed Dec 04 2002 - 20:18:44 CST
