RE: db domain being appended to db links when global

From: Troiano, Paul (CAP, GEFA) <Paul.Troiano_at_gecapital.com>
Date: Tue, 10 Apr 2001 10:43:04 -0700
Message-ID: <F001.002E6496.20010410102046@fatcity.com>

I actually fixed this one. The db_domain and global_names parameters had changed since the other instances were actually created. They were created with global_names=true and no db_domain specified. In this case the global_name of the db was set to xxx.world (ver. 8.05.2.1).
Later the global_names was set to false and a db_domain was set. The new database was created with these new parameters.

I just recreated the control files with the new settings and new name.

Thanks,
- Paul

                -----Original Message-----
                From:   Troiano, Paul (CAP, GEFA) 
                Sent:   Tuesday, April 10, 2001 10:56 AM
                To:     Multiple recipients of list ORACLE-L
                Subject:        db domain being appended to db links when global_names

= false

                What am I missing?

                When I create a database link, the db_domain is appended to the 
db_name even 
                though global_names is false. 



                - This database(dev4) was created using another (awt1) as a model.

                - The new dev4 database has the problem whereas awt1 does not. 

                - I did a diff on the two init.ora files and found only path and 

comment differences.


                - They also share the same tnsnames.ora/sqlnet.ora file (same 

ORACLE_HOME).


                - I have 6 instances using the same binaries with dev4 being the only 

one (and newest) that has the issue.


                - I commented out the db_domain parameter in the init.ora with no

effect (I did bounce the DB).

                I am using the simple version of the create database statement:

                create public database link dev4 using 'dev4';

                Thanks in advance,


                - Paul


                -- 
                Please see the official ORACLE-L FAQ: http://www.orafaq.com
                -- 
                Author: Troiano, Paul (CAP, GEFA)
                  INET: Paul.Troiano_at_gecapital.com

                Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
                San Diego, California        -- Public Internet access / Mailing Lists
                --------------------------------------------------------------------
                To REMOVE yourself from this mailing list, send an E-Mail message
                to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
                the message BODY, include a line containing: UNSUB ORACLE-L
                (or the name of mailing list you want to be removed from).  You may
                also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Troiano, Paul (CAP, GEFA)
  INET: Paul.Troiano_at_gecapital.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Tue Apr 10 2001 - 12:43:04 CDT

RE: db domain being appended to db links when global_names = fals