| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Oracle Names Server 8.1.7 on HP 11
I'd also add that we had nothing but problems with names on HP prior to version 8.1.7.4. Versions 8.1.7.4 and 9.2.0.2 have worked flawlessly.
Ron Thomas
Hypercom, Inc
rthomas_at_hypercom.com
Each new user of a new system uncovers a new class of bugs. -- Kernighan
john.kanagaraj_at_hd
s.com To: ORACLE-L_at_fatcity.com
Sent by: cc:
root_at_fatcity.com Subject: RE: Oracle Names Server 8.1.7 on HP 11
02/20/2003 12:19
PM
Please respond to
ORACLE-L
Zabair,
In addition to the excellent replies you have recieved, be aware that the Name Server will keep an open connection to the Repository, but will check the local cache (in the names directory) to resolve any queries. (Performing a DB query for every name resolution can be expensive!) I have had situations where both our nameservers (no ddo, both on Solaris, 8.1.7) lost connection to the repository (due to DB going down) and the NS continued to work. if you restart them and they cannot find the repository, they will use the caches. Of course, you should build monitoring scripts that check both the repository as well as response from the NS for highly available servers.
John Kanagaraj
Oracle Applications DBA
DBSoft Inc
(W): 408-970-7002
I don't know what the future holds for me, but I do know who holds my future!
-----Original Message-----
Sent: Thursday, February 20, 2003 10:39 AM
To: Multiple recipients of list ORACLE-L
You may also want to add these 2 parameters to your sqlnet.ora. Speeds up the switch to another nameserver.
NAMES.INITIAL_RETRY_TIMEOUT = 5 # Wait num seconds before going to next
nameserver, default=15
NAMES.REQUEST_RETRIES = 2 # Number of retries for nameserver, default=5
Gene
>>> roon987_at_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.
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
<http://uk.yahoo.com/mail/tagline_xtra/?http://uk.docs.yahoo.com/mail_storag e.html> With Yahoo! Mail you can get a bigger mailbox -- choose a size that fits your needs
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: John Kanagaraj INET: john.kanagaraj_at_hds.com 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_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.net -- Author: Ron Thomas INET: rthomas_at_hypercom.com 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_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 Thu Feb 20 2003 - 17:59:29 CST
 |
 |