Re: A real screwy problem.(SOLVED)

HI,
tracing did it.
I have 2 NICs for each server for security one does the internal network
one the internet.

Tcp_micro01_int_cn is internal
tcp_micro01_cn is external.

The listener is working perfectly.
the client connects using tcp_micro01_cn, the database starts negotiating the connection, then for some stupid reason tells the client the address of the INTERNAL network, from that point on it's doomed. but why such a stupid problem, or can I only have 1 tcp listener?

After looking thru the net configs, nowhere does the internal network refer to the external ip address or visa versa, the only thing I an think of is that the listener is asking the server (not looking in tnsnames.ora) who is the HOST, which would do it.

steve.
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 Tue Oct 12 1999 - 00:52:35 CDT