Re: Urgent, 2 instances on same server, instance failover scenario..

Mark D Powell wrote:
> Daniel, I am pretty sure I am not incorrect. In order to be able to
> make full use of TAF you must make OCI calls in your application. You
> cannot just take the code you run today and have it fail over. We run
> on RAC and when an instance dies all running applications on that
> instance die. The other instance performs backup and new connection go
> to the remaining instance. But running code is not automatically
> switched over. To get that feature to work you have to code for it.
>
> Improvements with this feature are bound to be provided with new
> releases but on 9.2 there is very little that is automatic about this
> feature and I do not think 10g has changed much.
>
> HTH -- Mark D Powell --

I understand, I think, what you are thinking but failover is part of Net Services and not part of an application.

Source:
http://www.oracle.com/technology/pub/articles/hunter_rac10g_3.html

"One important note is that TAF happens automatically within the OCI libraries. Thus your application (client) code does not need to change in order to take advantage of TAF. Certain configuration steps, however, will need to be done on the Oracle TNS file tnsnames.ora. (Keep in mind that as of this writing, the Java thin client will not be able to participate in TAF because it never reads tnsnames.ora.)"

Keep in mind that TAF has nothing to do with applications running on RAC clusters though that is often our focus. TAF also works with DataGuard too.

Check out this link: http://www.akadia.com/services/ora_net8_taf.html which goes all the way back to Oracle 8i.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)