Intriguing server connection problems on Windows 2000

From: Norman Dunbar <Norman.Dunbar_at_lfs.co.uk>
Date: Tue, 11 Feb 2003 11:57:05 -0000
Message-ID: <E2F6A70FE45242488C865C3BC1245DA70349FD25@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 - 05:57:05 CST