Re: TNS on Sun Solaris

From: Frank van Bortel <f.van.bortel_at_vnl.nl>
Date: Thu, 28 Oct 1999 12:42:55 -0700
Message-ID: <3818A73F.B80F76CA@vnl.nl>

Van Messner wrote:

> If you're on one machine, you may want to do everything through TCP, even
> the local connection. You'll need a line in your sqlnet.ora file that looks
> something like automatic_ipc=off (I don't have my manuals here).
>
> Van
>
> Jeff Hunter <jeffh_at_btitelecom.net> wrote in message
> news:38174a2d_at_defiant.btitelecom.net...
> >
> > Is your $TNS_ADMIN variable set correctly? It should be pointing to the
> > directory in which your tnsnames.ora and listener.ora files are located.
> >
> > Christ Follower wrote in message <7v779k$3p0$1_at_nnrp1.deja.com>...
> > >I am setting up Oracle 8.0.5 on Sun Solaris. I edited TNSNAMES.ORA. I
> > >am able to connect to the database (resides on the same machine)
> > >without giving a connection string name. I want to be able to connect
> > >to another Oracle database on another machine. It is giving me the TNS
> > >Name error (not able to resolve TNS name), although TNSNAMES.ORA is
> > >configured. Where else did I miss? Thanks.
> >
> >
> >

No you don't! TCP traffic is about 7 times slower than IPC. Use ipc for local (you can configure the listener to allow for a connect string), and tcp for remote

--
Met vriendelijke groet/kind regards,

Frank van Bortel
Technical consultant Oracle

Work:                                Home:
----------------------------------   ----------------------------
Inter Access V&L                     Hunzestraat 4
Palatijn 3, 7521 PN Enschede         7555 WB Hengelo
PoBox 545, 7500 AM Enschede          (31)074-2425046

053-4341500 Received on Thu Oct 28 1999 - 14:42:55 CDT