473,488 Members | 2,516 Online
Bytes | Software Development & Data Engineering Community
Create Post

Home Posts Topics Members FAQ

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 2255

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

Similar topics

3
2462
by: gbhatti | last post by:
Dear all, Our application needs a bit of database redundancy. Our application only accesses database for reading purposes.
0
2645
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
1858
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
2294
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
2541
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
21801
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
4573
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
7991
by: Vinod Sadanandan | last post by:
Fast-Start Failover An Overview In Dataguard Environment ============================================================================= This article describes the automatic fast start failover...
0
525
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
7108
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
7142
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
7181
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
4565
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
0
3078
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The...
0
3071
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
0
1383
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...
1
618
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
272
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence...

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.