Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: How can you have 2 default_domain's in sqlnet.ora
We finally realized that the problem was not with our domains but with the new domain. We are putting that as the default because all of our db's are fully qualified and somewhere in their application or tnsnames their databases are not fully qualified. But using their domain as the default we can get to their databases and ours, being fully qualified, are not affected.
Thanks for everyone's help,
Ruth
----- Original Message -----
To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
Sent: Tuesday, April 10, 2001 11:13 AM
>
>
> 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).
-- 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).Received on Tue Apr 10 2001 - 12:42:40 CDT
![]() |
![]() |