Re: TNSNAMES defines multiple connect methods, which is used?

Hi Jonathon,

If you are able to connect to the NT and run an Oracle session with your present TNS Names file you have a situation that my friends in engineering so colorfully describe with

"If it ain't broke, don't fix it."

If on the other hand if it is broken it is perfectly safe to use NET Easy to delete the entries that don't apply, but it is not a good idea to use your favorite editing program since, if you mess up, NET Easy doesn't seem able (or willing) to make further modifications to the file.

Regards

Jerry

>From: gennick_at_worldnet.att.net (Jonathan Gennick)
>
>I recently setup a new instance on an NT box, and Enterprise
>Manager generated the following entry in my TNSNAMES file:
>
>PINE.world=(DESCRIPTION=(ADDRESS_LIST =(ADDRESS=(COMMUNITY=
>NMP.world)(PROTOCOL= NMP)(SERVER= PMA0781D00)(PIPE=
>ORAPIPE))(ADDRESS=(COMMUNITY= TCP.world)(Host =
>pma0781d00)(PROTOCOL= TCP)(Port= 1521))(ADDRESS=(COMMUNITY=
>TCP.world)(Host = 127.0.0.1)(PROTOCOL= TCP)(Port=
>1521))(ADDRESS=(COMMUNITY= TCP.world)(Host =
>pma0781d00)(PROTOCOL= TCP)(Port= 1526))(ADDRESS=(COMMUNITY=
>SPX.world)(PROTOCOL= SPX)(Service=
>pma0781d00_lsnr)))(CONNECT_DATA=(SID=PINE)(SERVER=DEDICATED)))
>
>This entry contains connection information for named pipes,
>TCP/IP, and SPX. How can that work? How does Oracle choose
>between NMP, TCP/IP or SPX? I'm used to seeing much simpler
>entries, like the following:
>
>dev.world =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS =
> (PROTOCOL = SPX)
> (Service = oradetroit1)
> )
> )
> (CONNECT_DATA =
> (SID = dev)
> )
> )
>
>
>

Jerry Gitomer Since I know how to spell DBA, I became one. Received on Fri May 08 1998 - 20:42:45 CDT