Return-Path: Received: from ensim.rackshack.net (root@localhost) by orafaq.net (8.11.6/8.11.6) with ESMTP id h1KMK3R04348 for ; Thu, 20 Feb 2003 16:20:03 -0600 X-ClientAddr: 209.68.248.164 Received: from newsfeed.cts.com (newsfeed.cts.com [209.68.248.164]) by ensim.rackshack.net (8.11.6/8.11.6) with ESMTP id h1KMK3Q04343 for ; Thu, 20 Feb 2003 16:20:03 -0600 Received: from fatcity.UUCP (uucp@localhost) by newsfeed.cts.com (8.9.3/8.9.3) with UUCP id LAA22346; Thu, 20 Feb 2003 11:03:43 -0800 (PST) Received: by fatcity.com (26-Feb-2001/v1.0g-b72/bab) via UUCP id 0055333B; Thu, 20 Feb 2003 10:39:12 -0800 Message-ID: Date: Thu, 20 Feb 2003 10:39:12 -0800 To: Multiple recipients of list ORACLE-L X-Comment: Oracle RDBMS Community Forum X-Sender: "Gene Sais" Sender: root@fatcity.com Reply-To: ORACLE-L@fatcity.com Errors-To: ML-ERRORS@fatcity.com From: "Gene Sais" Subject: Re: Oracle Names Server 8.1.7 on HP 11 Organization: Fat City Network Services, San Diego, California X-ListServer: v1.0g, build 72; ListGuru (c) 1996-2001 Bruce A. Bergman Precedence: bulk Mime-Version: 1.0 Content-Type: multipart/alternative; boundary="=_B5EAD3A9.91F0E082" --=_B5EAD3A9.91F0E082 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable You may also want to add these 2 parameters to your sqlnet.ora. Speeds up = the switch to another nameserver. NAMES.INITIAL_RETRY_TIMEOUT =3D 5 # Wait num seconds before going to next = nameserver, default=3D15 NAMES.REQUEST_RETRIES =3D 2 # Number of retries for nameserver, default=3D= 5 Gene >>> roon987@yahoo.co.uk 02/20/03 12:19PM >>> We've currently got Names Server running on 4 host boxes. If one Names = server is down, the client is configured to automatically attempt to = connect to the next one in the list. We had a problem recently were, if we = issued a tnsping from any of the clients we got the following message. TNS-03505 * Failed to resolve name This implies that our client PC is unable to resolve the name and hence = was not able to connect to the database. Usually this implies that = something is wrong with all our Oracle Names servers.=20 Inorder to resolve this problem, I had to kill the Names Server on each of = the 4 boxes and restart it. The Names servers had somehow lost connection to the Oracle Names = repository database, although the servers appear to be attached to the = database. I reckon we can reduce the chances of this problem occuring again, by = adding a second Oracle Names database repository in our database cluster. = This means, that if the NAMES servers lose connection to one repository, = they can fall back on the second database without any loss of service. What have other people done with their Names Server and respository and do = they see any draw backs with the above. Sorry for the long email. TIA With Yahoo! Mail you can get a bigger mailbox -- choose a size that fits = your needs --=_B5EAD3A9.91F0E082 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Description: HTML

You may also want to add these 2 parameters to your sqlnet.ora. = =20 Speeds up the switch to another nameserver.

NAMES.INITIAL_RETRY_TIMEOUT =3D 5 # Wait = num=20 seconds before going to next nameserver,=20 default=3D15
NAMES.REQUEST_RETRIES =3D 2 # = Number of=20 retries for nameserver, default=3D5

Gene

>>> roon987@yahoo.co.uk 02/20/03 12:19PM=20 >>>

We've currently got Names Server running on 4 host boxes. If one Names = server=20 is down, the client is configured to automatically attempt to connect to = the=20 next one in the list. We had a problem recently were, if we issued a = tnsping=20 from any of the clients we got the following message.

TNS-03505 =96 Failed to resolve name

This implies that our client PC is unable to resolve the name and hence = was=20 not able to connect to the database. Usually this implies that something = is=20 wrong with all our Oracle Names servers.

Inorder to resolve this problem, I had to kill the Names Server on each = of=20 the 4 boxes and restart it.

The Names servers had somehow lost connection to the Oracle Names = repository=20 database, although the servers appear to be attached to the database.

I reckon we can reduce the chances of this problem occuring again, = by=20 adding a second Oracle Names database repository in our database cluster. = This=20 means, that if the NAMES servers lose connection to one repository, they = can=20 fall back on the second database without any loss of service.

What have other people done with their Names Server and respository and = do=20 they see any draw backs with the above.

Sorry for the long email.

TIA

With Yahoo! Mail you can get a bigger mailbox -- = choose a size=20 that fits your needs
--=_B5EAD3A9.91F0E082-- -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gene Sais INET: Gsais@co.palm-beach.fl.us Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru@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).