Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: tnsnames.ora - Windows client uses "SID.WORLD = " but Unix uses "SID = "

Re: tnsnames.ora - Windows client uses "SID.WORLD = " but Unix uses "SID = "

From: MMK Productions <nospammmkprod_at_bellatlantic.net>
Date: Mon, 13 Jul 1998 21:29:59 -0400
Message-ID: <6oechj$44d@world6.bellatlantic.net>


The ".world" is used if the "...default.name..." sqlnet.ora parameter is set. It is the same for all Oracle ports. Check the sqlnet.ora in your host and client network admin directory (/etc, $ORACLE_HOME/network/admin, ...) and look at the paramter settings (forget the actual parm name)

>Why do I need ".WORLD" in Windows tnsnames.ora but not in Unix
>tnsnames.ora?
>
>The tnsnames.ora on Windows needs to have .WORLD appended onto the SID
>DBP1.WORLD =
> (DESCRIPTION =
> (ADDRESS = (PROTOCOL= TCP)(Host= 10.1.140.205)(Port = 1522))
> (CONNECT_DATA = (SID = DBP1))
> )
Received on Mon Jul 13 1998 - 20:29:59 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US