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

From: joseph Li <lijoecyn_at_netspace.net.au>
Date: 7 May 1998 13:56:29 GMT
Message-ID: <6iseid$6sl$3@otis.netspace.net.au>

All the different protocols would work because SQL*Net would try to use them one by one until a connection is made. But in reality you would have only one working protocol, say TCP then it is better to delete the other protocols from TNSNAMES.ora . I believe your TNSNAMES.ora was modified by your remote Oracle Intelligent agent.

Regards
Joe

In article <6iqu5s$9up_at_bgtnsc03.worldnet.att.net>, gennick_at_worldnet.att.net (Jonathan Gennick) says:
>
>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:
>
Received on Thu May 07 1998 - 08:56:29 CDT