Re: Re: SQL*Net & loopback connector

From: Jared Still <jkstill_at_cybcon.com>
Date: Fri, 02 Jul 2004 07:25:44 -0700
Message-Id: <1088778344.2159.474.camel@poirot>

>
> At the risk of showing my ignorance, exactly how does one
> use IPC between instances on the same system?
>

It is easily setup via the net config tool.

Or if your java is not working quite right, ( a not too unusual situation, no? ) you can tnsnames.ora by hand.

The IPC connect string needs to appear before the TPC string in tnsnames.ora. Here is an example.

TS02 =
(DESCRIPTION =
(ADDRESS_LIST =

      (ADDRESS = (PROTOCOL = IPC)(Key = ts02))
      (ADDRESS = (PROTOCOL = TCP)(HOST = poirot)(PORT = 1521))

)
(CONNECT_DATA =

      (SERVER = DEDICATED)
      (SERVICE_NAME = ts02)

)
)

Confirm that IPC is being used by using tnsping. The output displays whether TPC or IPC is being used.

Jared

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Fri Jul 02 2004 - 09:19:41 CDT