Re: force oracle to use tcp connections

On 17 May 2007 04:51:50 -0700, Richard <richard_p_franklin_at_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

Any reason why you have posted this for the third time today? Didn't you read the responses?
Why would you force all connections to use a routable protocol instead of a nonroutable protocol?
Is there any sanity in this idea?
and yes, the listener will listen on the IPC protocol by default, by connections don't fall back on IPC since 8i. Not sure where you got that nonsense from.
But actually: IPC is definitely faster, so is preferred over TCP/IP. Also: DBAs need a mechanism to connect to the database when the listener is down.

-- 
Sybrand Bakker
Senior Oracle DBA