Re: Intriguing server connection problems on Windows 2000

From: FC <flavio_at_tin.it>
Date: Tue, 11 Feb 2003 13:41:54 GMT
Message-ID: <C472a.220942$AA2.8656758@news2.tin.it>

Norman,
I am sorry to report that the error is still the same (12541). There must be something definitely wrong in the TCP configuration (somewhere), even TNSPING dev817 (or TNSPING dev817.yocoya.com) fails. I also tried replacing the "amd-k7" host name with its physical address (192.168.0.99), but it doesn't work.
If ping the address the answer is ok, also if I ping amd-k7, I get the same answer, the problem must occur after the name resolution.

Any other ideas ?

"Norman Dunbar" <Norman.Dunbar_at_lfs.co.uk> wrote in message news:E2F6A70FE45242488C865C3BC1245DA70349FD25_at_lnewton.leeds.lfs.co.uk...
> Morning Flavio,
>
> in your tnsnames.ora change 'DEV817 =' to 'DEV817.yocoya.com =', as in
>
> DEV817.yoyoca.com =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = amd-k7)(PORT = 1521))
> )
> (CONNECT_DATA = (SERVICE_NAME = dev817.yocoya.com))
> )
>
>
> Next check out sqlnet.ora and make sure that
> 'NAMES.DEFAULT_DOMAIN=yocoya.com' is in there, if not, add it.
>
> Works for me.
>
> Cheers,
> Norman.
>
> -------------------------------------
> Norman Dunbar
> Database/Unix administrator
> Lynx Financial Systems Ltd.
> mailto:Norman.Dunbar_at_LFS.co.uk
> Tel: 0113 289 6265
> Fax: 0113 289 3146
> URL: http://www.Lynx-FS.com
> -------------------------------------
>
>
>
Received on Tue Feb 11 2003 - 07:41:54 CST