Yong,
That is the problem. It is not documented. I think that is the reason why
we went down that path of designing our application. I have an email from
oracle rep (RAC team member). He confirmed that with Oracle product
development.
We were running RAC on Tru 64. I was told that it is an
Hi, list friends:
I wonder if we are using XA to connect to rac database, can i still use oci to
write it? I want to try Transparent failover with rac database so that when schedule
down, i need not bring the whole site down, just reboot one db server and some
middleware, so that my
Actually, we are aware about TAF setup in the TNSNAMES.ORA
SQLPlus sessions fail-over perfectly well with the TNSNAMES.ORA
file.
It is our custom Pro*C programs [originally written against 8.1.5]
that
don't seem to be handling failover when it is doing DML.
Quoting from the 9iRAC Concepts Manual
Can anyone send me sample Pro*C code depicting how
they've handled TAF in 8iOPS or 9iRAC ?
We've got some application servers running Pro*C programs
which don't seem to able to handle failover. SQLPlus sessions
are failing over to the remaining instance but the Pro*C programs
seem
Hemant,
TAF was specific to OCI only in v8.0 of the
database. In v8.1 and upwards, it is specified for any application or
APIin the TNSNAMES entry...
This example comes straight out of the "Oracle Net8
Administration" manual, page 8-14. I'd suggest reading up on t
Tim, TAF still requires the application to be
programmed with Oracle8 OCI and greater. TAF is a
combination of OCI and net services to allow the
failover to occur. This requirement is still
documented in the Oracle9i R2 manuals.
http://otn.oracle.com/docs/products/oracle9i/doc_library/release2
Only in the sense that you must use tools that use OCI, such as OCI itself,
Pro*Precompilers, SQLJ, and JDBC OCI drivers. APIs that do not use OCI (and
thus can't use TAF) include JDBC Thin drivers...
You can use the TNS entry I sent in my email from SQL*Plus to failover
between two instances
oraora oraora,
If you want to implement TAF, you have to use OPS/RAC. and you application
must be written via OCI when connect to database. For standby to be in recover, it
take some minutes to recover the final redo log from the primary site, which maybe
need human interaction
At 02:33 AM 8/30/2002, you wrote:
oraora oraora,
If you want to implement TAF, you have to use OPS/RAC. and you
application must be written via OCI when connect to database.
Your application doesn't necessarily have to be written in OCI to use TAF,
but whatever layer eventually
Not all Oracle API's support TAF. I know that the JDBC thin driver does
not support TAF, while the JDBC OCI driver does.
Brian
--
| Brian McGraw /* DBA */ Infinity Insurance |
| mailto:[EMAIL PROTECTED
Guys ,
1# Can Standby database be configured for TAF ?
2# If so , when the Primary DB fails will the client application
be automatically failed over to Standby DB ?
3# And thereafter can the client application proceed it's process
without any manual intervention ?
I have read the Standby
Hi ,
I am configuring TAF on oracle 8.1.7 (solaris). I was just wondering if
anyone on the list has had experience on this and can give me any advice-
more specifically on the the method- preconnect and basic. Are there any
significant benefits of having the preconnect setting set?
Any input
a
bunch of PRECONNECT TAF connections are working away happily via their
first/primary connection to the primary database instance, and there is some
reason to terminate the second database instance or some/all of the
second/failover database connections to the second database instance
with PRECONNECT that I've noticed is the scenario where the
second/failover instance is terminated for some reason first. Let's say a
bunch of PRECONNECT TAF connections are working away happily via their
first/primary connection to the primary database instance, and there is some
reason to terminate
I have seen number of TAF papers on metalink and google. But wanted to get
some user experience.
This input is great.
Thanks
Murali
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Date: Tue, 05 Jun 2001 01:19:36 -0800
Yes. Search on MetaLink. Look
We are looking at using TAF (never used before) for application fail over.
First, any guidelines we should be aware of in general.
Second any specific concerns using TAF with applications using JAVA.
Any stuff on how does TAF and OPS work in harmony?
Regards
Murali Vallath
16 matches
Mail list logo