| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.misc -> Re: Net8 Listener Load Balancing
toneczar_at_erols.com wrote:
> I've set up two Net8 Listeners, on ports 1721 and 1726. I've tested both and
> they're running properly, accept connections, logging, etc. Then I set up a
> client TNSNAMES.ORA file, per Oracle support. I can connect and tnsping to
> the individual standard entries on the server just fine. But when I try to
> connect or tnsping from the client to the "load balancer" address, I get the
> error, "TNS-03507: Failure looking for ADDRESS keyword" which the docs say
> means that Net8 cannot locate the ADDRESS entry. But ... I configured it
> straight from the examples sent to me by Oracle support.
Oracle support did call back and offer an explanation. It seems that my configuration DOES work, but tnsping does not work with this configuration. The tech explained it thus: tnsping works at the network session level, while the app (say SQL*Plus) works at the network routing level. The config used to implement the load balancing doesn't make sense to tnsping, hence the error.
He's filing a bug report to make this clearer in future versions.
So if you want to implement load balancing, see my previous post for the tnsnames syntax.
Chris
-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Tue Dec 22 1998 - 17:04:31 CST
 |
 |