Re: A real screwy problem.

Hi,
I'm beginnig to wonder if it's the hardware when I look in the listener.log, it actually shows that a connection was made with the remote site.

I could really do with trying another connection from outside of our Ip hosts.

Pat Minnis <pminnis_at_indianaonline.net> wrote:

> Sorry. I wasn't reading close enough.
>
> I would do a sqlnet trace_level = admin on micro02_cn or micro03_cn and a
> listener trace on micro01_hk
> . Is it dropping your connection. I have seen live connections dropped as
> if they were dead connections before. It seems to happen more commonly if
> there is a multiprotocol interchange (TCP,IPC), if I have my term right. It
> also seems to be directly related to sqlnet.expire_time being set.
>
> This is my best stab. I've got nothing else rattling around my head.
> Hope it helps
>
> Steve A wrote in message <1dzb4zx.1nr078b39oiiuN@[201.1.1.70]>...
> >Hi,
> >Of course!!, otherwise tnspng80, would not work,
> >anyway below is an extract, of what must be the offending item.
> >
> >
> >micro01_hk.world =
> >
> > (DESCRIPTION =
> >
> > (ADDRESS_LIST =
> >
> > (ADDRESS =
> >
> > (COMMUNITY = tcp.world)
> >
> > (PROTOCOL = TCP)
> >
> > (Host = 210.176.69.163)
> >
> > (Port = 1521)
> >
> > )
> >
> > (ADDRESS =
> >
> > (COMMUNITY = tcp.world)
> >
> > (PROTOCOL = TCP)
> >
> > (Host = 210.176.69.163)
> >
> > (Port = 1526)
> >
> > )
> >
> > )
> >
> > (CONNECT_DATA =
> >
> > (SID = ORCL)
> >
> > )
> >
> > )
> >
> >Pat Minnis <pminnis_at_indianaonline.net> wrote:
> >
> >> Do you have server side tnsnames.ora set up on all servers?
> >>
> >> Steve A wrote in message <1dzarey.amx8441k74hh8N@[201.1.1.70]>...
> >> >Hi,
> >> >I have 3 oracle databases over a tcp/ip wan
> >> >
> >> >Micro01_hk 210.176.69.163
> >> >micro02_cn 202.104.30.69
> >> >micro03_cn 202.104.30.70
> >> >
> >> >i can tnspng to each one from the other.
> >> >
> >> >I can connect using SRVMGR from the console on each server:
> >> >Micro01_hk to Micro02_cn & micro03_cn
> >> >Micro02_cn to micro03_cn
> >> >micro03_cn to micro02_cn
> >> >
> >> >But I just cannot get a connection from:
> >> >micro02_cn to micro01_hk
> >> >micro03_cn to micro01_hk
> >> >
> >> >I have checked the listeners
> >> >Micro01_hk listens on 210.176.69.163
> >> >micro02_cn listens on 202.104.30.69
> >> >micro03_cn listens on 202.104.30.70
> >> >
> >> >The aliases at each site are identical
> >> >
> >> >how is it that Micro01_hk can connect to the others but not the otherway
> >> >round, for the purpose of the test no firewall was involved.
Received on Mon Oct 11 1999 - 05:22:31 CDT