Re: A real screwy problem.

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.