If a database named LOC is created on the HQ.MYCORP.COM server, its entries will be
DB_NAME = loc
DB_DOMAIN = hq.mycorp.com
NOTE
In a RAC environment, the INSTANCE_NAME cannot be the same
as the DB_NAME. Typically, a sequential number is appended to the
DB_NAME for each instance. See Chapter 10 for more information
on configuring a RAC database.
To enable the usage of the database domain name, you must set the GLOBAL_NAMES
parameter to TRUE in your SPFILE or initialization parameter file, as in this example:
GLOBAL_NAMES = true
NOTE
GLOBAL_NAMES is set to FALSE by default in Oracle Database 10g
and 11g.
608 Oracle Database 11g DBA Handbook
Once you have set these parameters, the database must be shut down and restarted for
changes to DB_NAME or DB_DOMAIN.
NOTE
If you set GLOBAL_NAMES to TRUE, all your database link names
must follow the rules described in this section; in other words,
GLOBAL_NAMES ensures that database links have the same name
as the database to which you connect using the link.
When you use this method of creating global database names, the names of the database links
are the same as the databases to which they point. Therefore, a database link that points to the LOC
database instance listed earlier would be named LOC.HQ.MYCORP.COM. Here is an example:
CREATE PUBLIC DATABASE LINK loc.hq.mycorp.com
USING 'LOCSVC';
LOCSVC is the service name in tnsnames.ora. Oracle will append the local database??™s DB_
DOMAIN value to the name of the database link.
Pages:
868
869
870
871
872
873
874
875
876
877
878
879
880
881
882
883
884
885
886
887
888
889
890
891
892