Re: A real screwy problem.

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 Fri Oct 08 1999 - 22:56:13 CDT