Re: How can you have 2 default_domain's in sqlnet.ora

Ruth,
You probably have an answer by now.
I had the same problem, and took the names.default_domain parameter out of the sqlnet.ora file, and also removed the domain portion of the net service name
(in the tnsnames.ora file) . This worked for us but on the other hand, the
servers here are all reachable from each other (even without appending the specific domain names)

I've never hear of having more than one names.default.domain. Did that really work?

chaim

"Ruth Gramolini" <rgramolini_at_tax.state.vt.us> on 04/09/2001 02:15:32 PM

Please respond to ORACLE-L_at_fatcity.com

To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> cc: (bcc: Chaim Katz/Completions/Bombardier)

Dear Guru's,

We have to have some of our users also be users on another system. The folks who are running this system said we should add another NAMES.DEFAULT_DOMAIN= NEW_DOMAIN
 to our sqlnet.ora for these users.

The default_domain is already specified in their sqlnet.ora as the domain for our databases. How can we point to both domains?

Any help will be greatly appreciated.

Ruth B. Gramolini
ORACLE & DB2 DBA
VT Dept. of Taxes
ph# 802.828.5708
fax# 802.828..3754
rgramolini_at_tax.state.vt.us

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Ruth Gramolini
  INET: rgramolini_at_tax.state.vt.us

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: 
  INET: Chaim.Katz_at_Completions.Bombardier.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).