473,325 Members | 2,712 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,325 software developers and data experts.

TAF without RAC or OPS

Is it possible to run use TAF for SELECT failover with just two
separate oracle databases which are not part of OPS or RAC cluster?

My application is read-only so I do not need clustering or shared
disk. I just want the select statements to be re-executed on the
stand-by oracle instance when the first one fails. The databases are
on different machines with different disks but they contain the same
data.

Is this possible? How would I configure TAF SELECT failover without
RAC or OPS?

Thanks,

- Jim
Jul 19 '05 #1
7 3911
Jim Dwyer wrote:
Is it possible to run use TAF for SELECT failover with just two
separate oracle databases which are not part of OPS or RAC cluster?

My application is read-only so I do not need clustering or shared
disk. I just want the select statements to be re-executed on the
stand-by oracle instance when the first one fails. The databases are
on different machines with different disks but they contain the same
data.

Is this possible? How would I configure TAF SELECT failover without
RAC or OPS?

Thanks,

- Jim


My understanding is that you can not.

However my understanding is that you anger just about everyone when you
post the exact same message to multiple usenet groups. Please don't do
that again. Lets try to ignore the postings to c.d.o. and c.d.o.misc and
just respond in c.d.o.server where the message belongs.

--
Daniel Morgan
http://www.outreach.washington.edu/e...ad/oad_crs.asp
http://www.outreach.washington.edu/e...oa/aoa_crs.asp
da******@x.washington.edu
(replace 'x' with a 'u' to reply)

Jul 19 '05 #2
On Fri, 02 Jan 2004, da******@x.washington.edu wrote:
However my understanding is that you anger just about everyone
when you post the exact same message to multiple usenet
groups. Please don't do that again. Lets try to ignore the
postings to c.d.o. and c.d.o.misc and just respond in
c.d.o.server where the message belongs.


I'd like to interject. Daniel, crossposting is fine, as long as
the multiple groups are relevant. It isn't clear that, for this
thread, all the groups are relevant but the OP did not "post the
exact same message to multiple usenet groups". He crossposted.
Posting the exact same message to multiple usenet groups is
spamming. That is, no matter what the intentions, frowned upon.
Crossposting is a way to include more than one group in the
conversation. This can be quite powerful sometimes, but in this
particular case, the OP seemingly wasn't trying to be judicious.

--
Galen Boyer
Jul 19 '05 #3
Hi

TAF is not a RAC feature at all...Please go through the following note
on nmetalink.Note:231996.1.its explains how to setup TAF sort of quick
setup guide.

regards
Hrishy
Jul 19 '05 #4
On 2 Jan 2004 20:31:07 -0600, Galen Boyer <ga********@hotpop.com>
wrote:
On Fri, 02 Jan 2004, da******@x.washington.edu wrote:
However my understanding is that you anger just about everyone
when you post the exact same message to multiple usenet
groups. Please don't do that again. Lets try to ignore the
postings to c.d.o. and c.d.o.misc and just respond in
c.d.o.server where the message belongs.


I'd like to interject. Daniel, crossposting is fine, as long as
the multiple groups are relevant. It isn't clear that, for this
thread, all the groups are relevant but the OP did not "post the
exact same message to multiple usenet groups". He crossposted.
Posting the exact same message to multiple usenet groups is
spamming. That is, no matter what the intentions, frowned upon.
Crossposting is a way to include more than one group in the
conversation. This can be quite powerful sometimes, but in this
particular case, the OP seemingly wasn't trying to be judicious.

I don't agree with you. You will have to distinguish between cross-
and multiposting. Crossposted messages will have the same messageid,
multiposted messages don't. Crossposted messages will be detected by
many newsreaders, multiposted won't. Hence in the latter case, it is
possible not to see someone already posted a valid responses.
In BOTH cases in cdo cross- and multiposting
- won't get you a bigger audience
- won't get you any better responses.

Please stop to promote cross and multiposting.
--
Sybrand Bakker, Senior Oracle DBA
Jul 19 '05 #5
Galen Boyer wrote:
On Fri, 02 Jan 2004, da******@x.washington.edu wrote:

However my understanding is that you anger just about everyone
when you post the exact same message to multiple usenet
groups. Please don't do that again. Lets try to ignore the
postings to c.d.o. and c.d.o.misc and just respond in
c.d.o.server where the message belongs.

I'd like to interject. Daniel, crossposting is fine, as long as
the multiple groups are relevant. It isn't clear that, for this
thread, all the groups are relevant but the OP did not "post the
exact same message to multiple usenet groups". He crossposted.
Posting the exact same message to multiple usenet groups is
spamming. That is, no matter what the intentions, frowned upon.
Crossposting is a way to include more than one group in the
conversation. This can be quite powerful sometimes, but in this
particular case, the OP seemingly wasn't trying to be judicious.


Sorry Galen but you are wrong. Just look at the Newsgroups in the header
of your newsreader. What the OP did is banned by both usenet etiquette
and the FAQ.

So lets stop doing it and let the c.d.o. and c.d.o.misc threads die.

Thanks.

--
Daniel Morgan
http://www.outreach.washington.edu/e...ad/oad_crs.asp
http://www.outreach.washington.edu/e...oa/aoa_crs.asp
da******@x.washington.edu
(replace 'x' with a 'u' to reply)

Jul 19 '05 #6
On Sat, 03 Jan 2004, da******@x.washington.edu wrote:
Sorry Galen but you are wrong. Just look at the Newsgroups in
the header of your newsreader. What the OP did is banned by
both usenet etiquette and the FAQ.


When is cross posting banned? Spamming is banned. If I have a
SQLServer/Oracle question both a SQLServer and Oracle newsgroup
are valid cross-posts. What the OP did wasn't a judicious use of
cross-posting but is not banned. Its just something you get all
up in arms about.

--
Galen Boyer
Jul 19 '05 #7
On Sat, 03 Jan 2004, go********@sybrandb.demon.nl wrote:
I don't agree with you. You will have to distinguish between
cross- and multiposting.
What the OP did was crossposting. Multi-posting is the
definition of spam.
Crossposted messages will have the same messageid, multiposted
messages don't. Crossposted messages will be detected by many
newsreaders, multiposted won't.
Exactly.
Hence in the latter case, it is possible not to see someone
already posted a valid responses. In BOTH cases in cdo cross-
and multiposting - won't get you a bigger audience
Huh?
- won't get you any better responses.
Completely disagree. If I have a SQLServer/Oracle question, the
both newsgroups are a valid crosspost.
Please stop to promote cross and multiposting.


I don't promote it nor do I do it.

--
Galen Boyer
Jul 19 '05 #8

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

Similar topics

19
by: Pete | last post by:
I have form/select which executes a function using onchange. No problem. However, when I validate the page with a strict HTML 4.01 doctype at http://validator.w3.org, it demands either an action or...
14
by: D. Alvarado | last post by:
Hello, I am trying to open a window containing an image and I would like the image to be flush against the window -- i.e. have no padding or border. Can I make this happen with a single call to a...
9
by: WalterR | last post by:
This is my first time here, so there may be earlier relevant threads of which I am unaware. Though my experience with DB2 is not extensive, such as it is was under OS/390 or equ. My main...
33
by: ankursinha | last post by:
Hi, Is it possible to write a C program that prints "Hello World" on screen without having a single semi-colon in the entire program? The extra constraint here is that u r not allowed to use...
4
by: Dawn Minnis | last post by:
Hi When I compile my files I get the following: driver.c: In function `main': driver.c:49: warning: assignment makes integer from pointer without a cast driver.c:50: warning: assignment...
4
by: Wal Turner | last post by:
Consider the following simple class: public class ClassA { public static string VAR = "hello"; } public void MethodA() { while(true)
5
by: Pascal Cloup | last post by:
Hello, I just want to send an e-mail from my windows form application without specifying SmtpServer. On my computer, when i specify my smtpserver, SmtpMail.Send( aMail ) works fine, but...
7
by: Ralf Gedrat | last post by:
Hello! I have some Vb.Net applications, which are terminated at indefinite times without message. If I call in the program regulated system.GC.Collect, then the program is terminated here...
5
by: mmcd79 | last post by:
I built a VB.net application that makes use of a machine level DB connection string setting, and a user level starting location setting. The machine level setting and the default user based...
5
by: Jonathan Kay | last post by:
Hi, I'd like to my WCF webservice to work both on SSL and without. Unfortunately searching has led to dead ends, references to changes that only work on the old previous beta versions and I...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

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.