hello,

sorry if this is a simple question, but is there a way to force the
oracle listener to only use TCP and *never* use IPC connections?

I have been working with 9i & 10g and it seems that the listener.ora
file parameters are not effective - I thought that perhaps by taking
out all references to PROTOCOL=IPC from my listener config, I could
force local connections (sqlplus) to use TCP, but the connections can
still fall back to IPC. is that the way it's supposed to work?

Is there a way to force all local connections to always be TCP?

thx!
richard

"Richard" <richard_p_franklin@yahoo.com> a écrit dans le message de news: 1179366887.382302.39030@w5g2000hsg.googlegroups.co m...
| hello,
|
| sorry if this is a simple question, but is there a way to force the
| oracle listener to only use TCP and *never* use IPC connections?
|
| I have been working with 9i & 10g and it seems that the listener.ora
| file parameters are not effective - I thought that perhaps by taking
| out all references to PROTOCOL=IPC from my listener config, I could
| force local connections (sqlplus) to use TCP, but the connections can
| still fall back to IPC. is that the way it's supposed to work?
|
| Is there a way to force all local connections to always be TCP?
|
| thx!
| richard
|

Why your local connections use network?
Why don't they connect directly?

Regards
Michel Cadot

On Wed, 16 May 2007 18:54:47 -0700, Richard wrote:

> Is there a way to force all local connections to always be TCP?

Make sure that your users do not have ORACLE_SID defined
but only TWO_TASK. Then you can even mandate CPIP (RFC 1149).
It would be really interesting to establish database connection
using CPIP.

--
http://www.mladen-gogala.com

On May 16, 9:54 pm, Richard <richard_p_frank...@yahoo.com> wrote:
> hello,
>
> sorry if this is a simple question, but is there a way to force the
> oracle listener to only use TCP and *never* use IPC connections?
>
> I have been working with 9i & 10g and it seems that the listener.ora
> file parameters are not effective - I thought that perhaps by taking
> out all references to PROTOCOL=IPC from my listener config, I could
> force local connections (sqlplus) to use TCP, but the connections can
> still fall back to IPC. is that the way it's supposed to work?
>
> Is there a way to force all local connections to always be TCP?
>
> thx!
> richard

IPC connections are faster than TCP connections and only available for
local sessions so why would you trying to eliminate their possible
use?

The various Oracle database background processes are going to use
Inter-Process Communications, IPC, to talk to each other. Are you
sure your monitoring is not monitoring this?

-- Mark D Powell --