Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: How can you have 2 default_domain's in sqlnet.ora

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

From: Lord David <dlord_at_haysits.co.uk>
Date: Wed, 11 Apr 2001 01:03:17 -0700
Message-ID: <F001.002E6CFF.20010411005523@fatcity.com>

What we do is to take out the NAMES.DEFAULT_DOMAIN altogether. Instead, I have set up aliases on the names server so that each d/b can be accessed by its db_name alone, as well as by the full global_name. Not sure that this fully covers your problem, but it works for us.

David Lord
Senior DBA, Hays Commercial Services, IT Solutions

-----Original Message-----
Sent: 09 April 2001 19:16
To: Multiple recipients of list ORACLE-L

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).

This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager.

This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses.

www.mimesweeper.com



--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Lord David
  INET: dlord_at_haysits.co.uk
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 Wed Apr 11 2001 - 03:03:17 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US