Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Help needed in SQLnet configuration
Michael;
I agree with you about the need to avoid SPF. But the only way I know to route a TNS connection is using connection manager. I'll be interested to hear if there are viable options. I have to admit, I didn't get the thing about exporting a directory.
Best!
Randall
Michael Austin <miaustin_at_bellsouth.net> wrote in message
news:3B0C6FF1.E2F0C82A_at_bellsouth.net...
>
>
> Randall Roberts wrote:
>
> > You need to install Connection Manager on the intermediate system. Then
you
> > make a change to your TNSNAMES.ora to reflect that the connection is
being
> > routed through Connection Manager. In order to install Connection
Manager
> > you have to do a Custom install using the Oracle Installer. Connection
> > Manager isn't installed by default even on a server installation.
> >
>
> I am still not sold on a single system running CM... If all of your "name
> resolution"is through this one box, what happens when it dies... and
believe
> me.. it will die at the most inopportune time. NFS mounted filesystems
have the
> same inherent flaw - SPOF (Although I am doing some investigations of the
SAN
> solutions which is making things really interesting in configuring a data
> center.. and some of these use NFS) That is usually why you have more
than one
> DNS server and usually on different segments. Avoid SPOF (single point of
> failure) Which is also why I like to use an OpenVMS Cluster, with
mirrored
> disk-subsystems...
>
> Although, since my customers mostly use the U*** word, I am stuck working
with
> it as well.
>
> Michael Austin
> DBA Consultant
>
> > Best!
> >
> > Randall Roberts
> >
> > GĂ©rard EDMOND <vikram_at_wanadoo.fr> wrote in message
> > news:9efstu$qlu$1_at_reader1.fr.uu.net...
> > > Thanks in advance for U'r reply or tips.
> > >
> > > I had installed Orcle Client in my local system. (Win2000)
> > > I need to access a base on the machine yyy.yy.yy.yy (port 1526). The
> > > porblem is that I dont have direct access to that machine from my
local
> > > system. Rather I can access the machine yyy.yy.yy.yy (system Unix)
thru
> > > the machine xxx.xx.xx.xx (system Unix) where I have access to that
machine.
> > > What will be my config. in TNSNAMES.ora
> > > Is it possible to access a base thru an intermerdiate system?
> > >
> > >
> > >
> > >
>
Received on Wed May 23 2001 - 22:51:45 CDT