it's valid.
if there is no response on the first port, Oracle tries the next etc
etc etc. It's a means of failover or allowing for continuity of
connections while doing maintenance on a listener or server
--- Bob Metelsky [EMAIL PROTECTED] wrote:
Is having multiple addresses valid for a tns
I think this is used in Parallel server environments. I have seen something
similar (maybe not exactly) so it could well be valid. My understanding is
that it should be working it's way down the list or pick a random address
depending on (not much experience with OPS/RAC)
Jack
-Original
Add FAILOVER=ON and it will check the next address if the previous
one has failed. Alternatively, use SOURCE_ROUTE=ON and it will check
every single one of them if the previous one fails.
Mladen Gogala
Oracle DBA
Phone:(203) 459-6855
Email:[EMAIL PROTECTED]
-Original Message-
Sent:
Thanks Rachael
Getting some more feedback on this
What this appears to be is a cluster configuration with a middle ware
capability ( like Oracle FailSafe) to fail a database over from one node
to its backup. This would be the reason each IP is configured with two
ports.
That sounds
Works for me. I just did a the test on Oracle 8.1.7. Here is the trace
file. Note the nsopen: unable to open transport after trying to find host
fleming. Then it goes on to try host altair which succeeds. One thing
though. The host must not exist or be unreachable. If the host is reachable
but
Is he trying to do failover or load balancing?
Bob Metelsky
I don't know, thats what Im trying to figgure out. Non the less the
connection works, It looked weird to me (on the first impression)
I suppose I could ask, I was just wondering if this was an easily
identifiable entry
Thanks
bob
Is he trying to do failover or load balancing?
--