Oracle-L: Re: Sample Pro*C code for TAF in 8iOPS/9iRAC

From: Tim Gorman <Tim_at_SageLogix.com>
Date: Wed, 02 Oct 2002 20:08:20 -0800
Message-ID: <F001.004DEE04.20021002200820@fatcity.com>

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 in 8i OPS, 9i RAC, and certain flavors of 9i Data Guard. You don't need to program in OCI, just use an OCI-based network driver...

The distinction I was making was that in Oracle8 v8.0, you had to actually program the failover code in "C" code in OCI only...

Original Message ----- To: <ORACLE-L_at_fatcity.com> Cc: <Tim_at_SageLogix.com> Sent: Wednesday, October 02, 2002 8:29 PM

> 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/rac.920/a9 6597/pshavdtl.htm#20180
>
> Scott
>
> --- Tim Gorman <Tim_at_SageLogix.com> wrote:
> > 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 API in the TNSNAMES entry...
> >
> > This example comes straight out of the
> "Oracle Net8
> > Administration" manual, page 8-14. I'd
> suggest
> > reading up on the meaning of the FAILOVER_MODE
> > settings, specifically TYPE= and METHOD=. Also,
> if
> > you have your OPS/RAC instances in a pure
> > "active/passive" arrangement, then the
> TNS entry
> > below should work (i.e. LOAD_BALANCE=OFF). If
> you
> > have both instances equally available for user
> > connections (i.e. "active/active"
> failover
> > arrangement), then you might consider changing
> > LOAD_BALANCE=ON to distribute the connections
> > randomly. However, you'll want to think
> carefully
> > about using that mechanism... :-)
> >
> > sales.us.acme.com=
> > (description=
> > (load_balance=off)
> > (failover=on)
> > (address_list=
> > (address=
> > (protocol=tcp)
> > (host=sales1-server)
> > (port=1521)
> > )
> > (address=
> > (protocol=tcp)
> > (host=sales2-server)
> > (port=1521)
> > )
> > )
> > (connect_data=
> > (service_name = sales.us.acme.com)
> > (failover_mode =
> > (type=select)(method=basic))
> > )
> > )
> > Hope this helps...
> >
> > -Tim
> >
> > ----- Original Message -----
> > To: "Multiple recipients of list
> ORACLE-L"
> > <ORACLE-L_at_fatcity.com>
> > Sent: Wednesday, October 02, 2002 10:13 AM
> >
> >
> > >
> > >
> > > 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 to be "hanging", without
> returning any error,
> > when
> > > a transaction is "in-flight" We do
> know that
> > Insert/Update/Deletes
> > > do not really failover but are wondering how
> the
> > Pro*C programs
> > > could be written to handle the oracle error
> on
> > session failover
> > > and resubmit the transaction.
> > >
> > >
> > > Hemant K Chitale
> > > My web site page is :
> http://hkchital.tripod.com
> > >
> > >
> > > --
> > > Please see the official ORACLE-L FAQ:
> > http://www.orafaq.com
> > > --
> > > Author: Hemant K Chitale
> > > INET: hkchital_at_singnet.com.sg
> > >
> > > 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: ListGuru_at_fatcity.com (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).
> >
>
>
> __________________________________________________
> Do you Yahoo!?
> New DSL Internet Access from SBC & Yahoo!
> http://sbc.yahoo.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Tim Gorman
  INET: Tim_at_SageLogix.com

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: ListGuru_at_fatcity.com (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).

Received on Wed Oct 02 2002 - 23:08:20 CDT