Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: TNS on Sun Solaris
Hi Frank,
Do you have any proof of that? My initial guess is the same as your recommendation but my recent experiments showed that using bequeath (a variant of IPC) tnsping was up to 8 times slower (around 1000 secs).
Regards,
--
Sybrand Bakker, Oracle DBA
Frank van Bortel <f.van.bortel_at_vnl.nl> wrote in message
news:3818A73F.B80F76CA_at_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 - 07:00:35 CDT