Re: question about database domains

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Sun, 25 Apr 1999 22:15:02 +0200
Message-ID: <925071451.20160.0.muttley.d4ee154e@news.demon.nl>

Hi Jonathan
Not only distributed databases IMHO. Consider a large worldwide firm, where it would be impractical to have one worldwide database (usually in the US, because many Americans think there's not much outside America). In this case you would setup two 'mirror-sites', with a database having the same structure and the same name. The only thing that differentiates them is the domain. Example, assume there is an instance for Oracle Financials within several Oracle offices.
In this case you would get
fin_at_nl.oracle.com
fin_at_us.oracle.com
and so on. I have been using this setup, works fine. This is what they call a hierarchical networking in the 'Understanding Sqlnet' manual.

Hth,

Sybrand Bakker, Oracle DBA
Jonathan Gennick wrote in message
<37265b48.12348663_at_netnews.worldnet.att.net>...
>I'm doing some research for a course that I'm writing. Can
>anyone give me a practical example of why the db_domain
>parameter matters? I gather that it has meaning for
>distributed databases, but I was unable to find a good
>explanation in the Oracle Distributed Database Systems
>manual.
>
>thanks,
>
>Jonathan
>
>
>
Received on Sun Apr 25 1999 - 15:15:02 CDT