Path: newssvr20.news.prodigy.com!newsmst01a.news.prodigy.com!prodigy.com!news.glorb.com!postnews1.google.com!not-for-mail From: sschoch1@nycap.rr.com (Sue) Newsgroups: comp.databases.oracle.server Subject: jdbc failover to standby question Date: 5 May 2004 10:50:02 -0700 Organization: http://groups.google.com Lines: 14 Message-ID: NNTP-Posting-Host: 24.194.6.35 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit X-Trace: posting.google.com 1083779402 24951 127.0.0.1 (5 May 2004 17:50:02 GMT) X-Complaints-To: groups-abuse@google.com NNTP-Posting-Date: Wed, 5 May 2004 17:50:02 +0000 (UTC) Xref: newssvr20.news.prodigy.com comp.databases.oracle.server:260878 I'm having a problem understanding how TAF to a standby database in jdbc would work. I currently have a production database with a standby database. I understand that I need to set some failover settings in the tnsnames.ora file and use the thick java jar files. What I don't understand is exactly how this would work. Suppose I have database on machine A and standby on machine B with TAF set up in the tnsnames files on both machines. Now suppose I have a jdbc app running on machine C. If machine A fails, how does my jdbc app access the tnsnames failover information? How does it know to go to machine C? Does this only work if machine A stays up with the listener running? Can anybody shed some light on how this works? Sue