PLS HELP MAAHER.......... [message #83620] |
Mon, 10 November 2003 00:08 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
ishita
Messages: 15 Registered: April 2003
|
Junior Member |
|
|
hi
can u pls tell me the full form of TNS and i would like to know something more about TNS....
thanks
|
|
|
Re: PLS HELP MAAHER.......... [message #83625 is a reply to message #83620] |
Mon, 10 November 2003 04:21 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](/forum/images/custom_avatars/43055.jpg) |
Maaher
Messages: 7065 Registered: December 2001
|
Senior Member |
|
|
TNS = TRANSPARENT NETWORK SUBSTRATE
Look here.
The TNSNAMES.ORA file is a file that describes what connections are available to your client. It consists of machine name/IP, Protocol used, Port used, database SID and an alias.
yourconnection.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = ip_address)(PORT = some_port_usually_1521))
)
(CONNECT_DATA =
(SID = your_database)
)
) I can't give you any more info, I'm not a DBA at all. But look at the TNS as a translation mechanism for the listener and Net8.
MHE
|
|
|