473,395 Members | 1,608 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,395 software developers and data experts.

jdbc failover to standby question

Sue
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?
Jul 19 '05 #1
0 2252

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: gbhatti | last post by:
Dear all, Our application needs a bit of database redundancy. Our application only accesses database for reading purposes.
0
by: Shane | last post by:
I have a readonly DB2 database and its standby on another box. My CLI applications normally work with the primary DB. If there are communication errors or instance corruption, the applications...
3
by: paul | last post by:
Hi, i'd like to know how to implement an automatic failover with HADR. I've configured 2 databases, one primary and the other standby. Everything works ok (replciation and takeover). But if i...
6
by: kavallin | last post by:
2 servers with solaris,veritas cluster and DB2 UDB ESE v8.1 with fixp10. ON the primary db2 server did I create 2 db2 instances and the admin instance. It is possible to start both db2 instances...
1
by: theSpinel | last post by:
Is it possible to failover a single or a selected number of databases onto a standby server? We're currently log shipping about 12 databases to a standby and I was wondering if it was possible to...
6
by: shorti | last post by:
db2 8.1 fix pack 12 on AIX 5.3 This is a newly configured HADR machine. The HADR was up and running. I was 'playing' around some on the standby and did a db2 deactivate and things sort of went...
3
by: afreema | last post by:
I am interested in failover for DB2 Version 9 on an AIX environment. Can you give me any recommendations?
0
by: Vinod Sadanandan | last post by:
Fast-Start Failover An Overview In Dataguard Environment ============================================================================= This article describes the automatic fast start failover...
0
by: Sue | last post by:
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...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.