Re: Oracle traffic & the SP switch

Sorry, sorry, sorry.

In a moment of madness, I forgot to realise that my internal ethernet alias is exactly the same as the hostname of the node. That's why, when I put the ethernet address (hostname) in the listener.ora file, I was actually accepting connections via any interface - proved simply by putting the ethernet IP address in instead!

Woops!

"John Skyner" <jskyner_at_jtc-computing.co.uk> wrote in message news:t9b9pm7jgcjmc5_at_xo.supernews.co.uk...
> Are there any Oracle_traffic_over_the_SP_switch gurus out there?
>
> I'm having a small problem and wonder if you may have the answer:
>
> I have a two node cluster: One is a database server and the other an
> application server.
>
> Most clients access the application via the application server, which
> doesn't cause a problem.
>
> However, there are a few clients who need to access the database directly,
> via SQLNet. Here's where I have the problem:
>
> I want to listen on the switch card which, as you know, is not accessible
> outside of the SP framework. If I configure the listener to listen on the
> internal ethernet, which is the same as listening on the switch, the
> database will accept connections from any incoming request, such as the
> public tokenring network or even the switch. If I listen on the switch,
> however, only connection requests made via the switch will be honoured.
>
> Why won't Oracle accept external requests, when listening on the switch,
> when it will accept external requests when listening on the internal
> ethernet?
>
> How do I get around this?
>
> Please Cc a copy of your reply posting directly via e-mail, for speed.
>
> Many thanks in advance,
>
> John
>
>
>
>
Received on Fri Feb 23 2001 - 15:06:03 CST