RE: Microsoft VS Oracle (again)

Rich,  

> So, what's the case for code changes?

TAF (Transparent Application Failover) will provide both SESSION failover as well as SELECT failover. In the former case, the session aborts on the now-failed server and starts from the beginning on the new node, while the latter enables user with open cursors to continue fetching on them after failure by re-executing the cursors on the new node. The former does not require code changes, while the latter does, and requires code changes done on a limited number of executable environments (JDBC Thin and OCI come to mind) that support 'TAF Callback'. TAF *with RAC* will provide the environment for a clustered environment where the user can failover from one node to another node accessing the same data (as compared to TAF in a replicated environment).

Hope this answers your question. Murali Vallath [are you listening in, Murali?] may be able to add some details [Hint!]

John Kanagaraj
Oracle Applications DBA
DBSoft Inc
(W): 408-970-7002

Disappointment is inevitable, but Discouragement is optional!

• The opinions and statements above are entirely my own and not those of my employer or clients **

> -----Original Message-----
> From: Jesse, Rich [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, July 02, 2003 10:04 AM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Microsoft VS Oracle (again)
>
>
> Has anyone read the articles? One point states that failover for RAC
> requires coding changes to take advantage of it. Not from
> the demo I saw.
> HPaq (or whoever they are these days) took a circa '99 Oracle test GUI
> called Oracle Workload Generator and got failover to work
> with only changes
> to the sqlnet.ora. I've seen the demo twice, once with Unix
> servers and
> once with Windohs servers (since the app is Windohs, the
> client had to be
> Windohs), and while the Unix did the failover much faster
> (1-2 secs vs.
> 20-30 secs), both worked seamlessly. As an aside, the load balancing
> queries worked flawlessly, too.
>
> So, what's the case for code changes?
>
> Makes me want to read the articles further...
>
> Rich
> Rich Jesse System/Database Administrator
> [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA
>
>
> -----Original Message-----
> Sent: Tuesday, July 01, 2003 1:00 PM
> To: Multiple recipients of list ORACLE-L
>
>
> FYI
> One of my friends at Microsoft, (yes I must to
> confess, I have friends at MS) gave me a "present",
> it's a 4 cd's kit called "SQL Server 2000 for the
> Oracle Customer", the kit consist in 4 cd's with
> demos, docs, presentations, videos and a lot of stuff
> showing why sql server is a better option as a DB
> instead oracle, contains price lists, performance
> evaluation and many other "information", maybe you'd
> like to spend some of your time giving Billy a chance
> to defend his product. The 4 cd's are available
> (almost completely) as links in:
> http://www.microsoft.com/sql/oraclekit
> Any comments?
> Gabriel
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Jesse, Rich
> 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: John Kanagaraj
  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).