Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: tnsnames.ora - Windows client uses "SID.WORLD = " but Unix uses "SID = "
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
![]() |
![]() |