473,397 Members | 2,084 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,397 software developers and data experts.

Explain SID and TNS names

what do u mean by SID and TNS names.ORA in oracle.
May 10 '07 #1
9 68576
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

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

Similar topics

6
by: Dale Atkin | last post by:
As part of a larger project, I need to be able to count the number of lines in a file (so I know what to expect). Anyways, I came accross the following code that seems to do the trick, the only...
4
by: gsalgado | last post by:
Hello, I´m trying to build a php program to send emails with tables with variables into thems. I explain: the body of emails contens into a table 2x2 and the first line have titles: (Name,...
10
by: Greg Stark | last post by:
This query is odd, it seems to be taking over a second according to my log_duration logs and according to psql's \timing numbers. However explain analyze says it's running in about a third of a...
10
by: Jeff Boes | last post by:
I'm hoping there's someone here with experience in building the Visual Explain tool from Red Hat. I downloaded it and the J2 SDK, but when I attempt to follow the build instructions, I get messages...
9
by: Abhishek | last post by:
Yet another option is to use pointers to arrays: int (*array4) = malloc(nrows * sizeof(*array4)); or even int (*array5) = malloc(sizeof(*array5)); Please explain the declaration of the...
3
by: Yuri | last post by:
Does anybody have a tool to store/retrieve explained sql? We're running DB2 8.2 on AIX. We would like to be able to compare old saved explains to the current ones and see if anything changed....
11
by: kartheeknagasuri | last post by:
my friend gave this code to me..... it is working fine....how come? please explain me if u can understand..... #include <stdio.h> #include <conio.h> #define _(__,___)\ ___##__
1
seshu
by: seshu | last post by:
hai every body this is seshu, I would like to learn the concept of arrays because i think it would be helpful in my program any how let me even explain you what the problem i have...
3
by: bsagert | last post by:
After a couple of weeks studying Python, I already have a few useful scripts, including one that downloads 1500 Yahoo stock quotes in 6 seconds. However, many things are puzzling to me. I keep on...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.