469,281 Members | 2,486 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,281 developers. It's quick & easy.

Explain SID and TNS names

what do u mean by SID and TNS names.ORA in oracle.
May 10 '07 #1
9 67533
debasisdas
8,127 Expert 4TB
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.
Expand|Select|Wrap|Line Numbers
  1. MES =
  2.   (DESCRIPTION =
  3.     (ADDRESS = (PROTOCOL = TCP)(HOST = 10.35.15.1)(PORT = 1521))
  4.     (CONNECT_DATA = (SID = MES))
  5.  
  6.  
May 11 '07 #2
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.
Expand|Select|Wrap|Line Numbers
  1. MES =
  2.   (DESCRIPTION =
  3.     (ADDRESS = (PROTOCOL = TCP)(HOST = 10.35.15.1)(PORT = 1521))
  4.     (CONNECT_DATA = (SID = MES))
  5.  
  6.  
May 14 '07 #3
thanx for u information
can u tell me is there any abbrivation for SID?

It means oracle system identifier
May 14 '07 #4
It means oracle system identifier

TNS means Transparent Network Substrate (TNS)
May 14 '07 #5
debasisdas
8,127 Expert 4TB
Thanx Manju for solving question put for me .

keep it up

forum needs u like people

I really appreceate that.
May 14 '07 #6
thanx for ur information.can u tell me more about TNS?


TNS means Transparent Network Substrate (TNS)
May 16 '07 #7
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)
Dec 12 '07 #8
orcl1
4
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
Dec 12 '07 #9
@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
Feb 5 '13 #10

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

6 posts views Thread by Dale Atkin | last post: by
9 posts views Thread by Abhishek | last post: by
3 posts views Thread by Yuri | last post: by
11 posts views Thread by kartheeknagasuri | last post: by
3 posts views Thread by bsagert | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.