Explain SID and TNS names

[vedapriya]

what do u mean by SID and TNS names.ORA in oracle.

[debasisdas]

SID---is the name of the database.
TNSNAMES.ORA-----This files contains the information which is used by the system to connect to oracle database.

This file is usually located at the following path.

.....\oracle\product\10.2.0\db_1\NETWORK\ADMIN

It contains several informations like

PROTOCOL
HOST IP ADDRESS
PORTNO
SID
etc


A typical entry in this file looks like this.

MES =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 10.35.15.1)(PORT = 1521))
    (CONNECT_DATA = (SID = MES))
 
 

[vedapriya]

thanx for u information
can u tell me is there any abbrivation for SID?

SID---is the name of the database.
TNSNAMES.ORA-----This files contains the information which is used by the system to connect to oracle database.

This file is usually located at the following path.

.....\oracle\product\10.2.0\db_1\NETWORK\ADMIN

It contains several informations like

PROTOCOL
HOST IP ADDRESS
PORTNO
SID
etc


A typical entry in this file looks like this.

MES =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 10.35.15.1)(PORT = 1521))
    (CONNECT_DATA = (SID = MES))
 
 

[ManjunathRG]

thanx for u information
can u tell me is there any abbrivation for SID?

It means oracle system identifier

[ManjunathRG]

It means oracle system identifier

TNS means Transparent Network Substrate (TNS)

[debasisdas]

Thanx Manju for solving question put for me .

keep it up

forum needs u like people

I really appreceate that.

[vedapriya]

thanx for ur information.can u tell me more about TNS?

TNS means Transparent Network Substrate (TNS)

[monicay]

SID is the name of the Database to which we are connecting to
The full form of SID is SystemIdentifier which should be unquie in the TNS.ora file
TNS file contains info , through which the System connects to Oracle Database.

TNS file contains

1)PROTOCOL ( Mostly TCP..TransmissionControlProtocol)
2)HOST IP ADDRESS (Where the Database is resided ..Generally we call it as Server.Even the DSCP number acts as substitute)
3)PORTNUMBER ( 1521..Widely used by oracle)
4)SID (the name we provide for DataBase)
5)SERVER (Dedicated/Shared Which is defined at DB CREATION LEVEL)

[orcl1]

Guys,

For Oracle DBA related issues [link removed] would be the best place . I heard that lots of dazzling techie authors are around there .Those authors had played with the planets most critical databases .

-orcl1

[Devenda Jha]

@vedapriya
1. Actually; SID refers to the SYSTEM ID (System Identifier).
Now say, if system S has one or more databases, then each database has given the unique ID and where SID comes.

2. TNS works as transparent layer i.e. if there r heterogeneous collection of protocols in the network, TNS will resolve into one homogeneous layer