We handle our fail over in the code .... and trust me users don't know. Nor it affects any scores that we put on the TV ... works just fine, but code design plays important role.
BTW talking of TAF, has anyone experimented with 'warming the lib cache' ?? Any experiences? I am referring to dbms_libcache in 9ir2.
Raj
--------------------------------------------------------------------------------
Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly personal.
QOTD: Any clod can have facts, having an opinion is an art !
-----Original Message-----
From: John Kanagaraj [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 02, 2003 2:31 PM
To: Multiple recipients of list ORACLE-L
Subject: 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).
********************************************************************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.*********************************************************************2
