Home » Developer & Programmer » Forms » PLS HELP MAAHER..........
PLS HELP MAAHER.......... [message #83620] Mon, 10 November 2003 00:08 Go to next message
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
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
Previous Topic: can anybody answer...................
Next Topic: record group
Goto Forum:
  


Current Time: Fri Apr 19 13:46:00 CDT 2024