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).