| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Sample Pro*C code for TAF in 8iOPS/9iRAC
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))
)
)
-Tim
> > > 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).
-- 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 - 13:33:27 CDT
 |
 |