| The Concept of SERVICE_NAME [message #67050] |
Mon, 07 July 2003 08:33  |
Rama
Messages: 17
Registered: October 2001
|
Junior Member |
|
|
Need a clarification on the Concept of SERVICE_NAME
Oracle has introduced the concept
of SERVICE_NAME in 8i as apposed to SID
in the earlier releases. what could this feature really mean.
|
|
|
|
| Re: The Concept of SERVICE_NAME [message #67051 is a reply to message #67050] |
Mon, 07 July 2003 23:07  |
Shailesh Mishra
Messages: 1
Registered: July 2003
|
Junior Member |
|
|
I have got to share (from Ask tom ) in this regard :
It explains Global Name / SID/ SERVICE_NAME
"
global name is not related to service is not related to sid.
A global name is used to UNIQUELY identify a database in a federation of
databases. Using a global name, you can make it so the DBLINK from database
with global name A to database with global name B will only work if the database
link itself is named after "B". This ensures when using dblinks, you KNOW what
database you are connecting to. global names are for distributed databases.
A sid or site identifier, is used in conjunction with the oracle_home in order
to generate a unique key for a shared memory realm. After that, it is
meaningless really. You can use an oracle_home+oracle_sid to connect to an
oracle instance without using the network when you are on the machine that hosts
the database server.
A service is a name given to a COLLECTION (and a collection can be of size 1) of
instances. You cannot to a SERVICE and using load balancing -- Oracle will pick
an instance to connect you to. In most cases, there is a single instance in the
service and hence you always goto the same instance. Using Oracle9i RAC in a
cluster however, there maybe 2, 3, .... N instances in a service and Oracle will
load balance connections over them.
"
|
|
|
|
| Re: The Concept of SERVICE_NAME [message #67052 is a reply to message #67051] |
Mon, 07 July 2003 23:54 |
Rrama
Messages: 1
Registered: July 2003
|
Junior Member |
|
|
Shailesh,
Thanks for your answer, so the bottom line is that the concept of SERVICE_NAME is relevant only in the case of RAC evironments where we have several instances running against a single database.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
