Re: Global Database Name, Database Name, and SID

You really don't want to name these differently. About the only case I can think of having the global database name different than the rest is in the case of Oracle Parallel Server where you have two databases with the same Database Name. Giving one of them a different global database name makes it look like they are two different instances.

But I'd name them all the same!

HTH,
Brian

Dan Alexander wrote:
>
> It seems that for the most part, the Oracle Global Database Name, Database
> Name, and SID should follow the same naming convention.
>
> Example:
> Global Database Name = foo.bar.com
> Database Name = foo
> SID = foo
>
> However, there isn't anything to stop someone from naming these things
> differently. It seems that Oracle provides the granularity to do so.
>
> Example:
> Global Database Name = pollywog.pond.com
> Database Name = frog
> SID = toad
>
> My question is:
> Why would someone want to name each of these differently? What's the benefit?
> What's a good, "real-world" example.
>
> tia,
> dalex
> dalex_at_owt.com
 

-- 
========================================
Brian Peasland
Raytheons Systems at
  USGS EROS Data Center
These opinions are my own and do not
necessarily reflect the opinions of my 
company!
========================================