Wierd. Our primary ONAMES server is 8.0.5 on OpenVMS, with the Region DB being on the same box. Our secondary ONAMES server is 9.2.0.2 on WinTuke using the same Region DB as the primary (amazing that 9iR2 can still use an 8.0.5 Region DB). Yes, we are working on "upgrading" this config, despite it being extremely stable due to non-support by Oracle Corp.
One upon a time, a controller on the primary ONAMES / region DB server puked, causing the server to crash. While it was down, all Oracle Net connections eventually failed over to the secondary ONAMES server, which was indeed using the local checkpoint files for names resolution. It worked well with the only downside being that the clients had to wait for a TCP/IP timeout on the primary ONAMES server until it failed over to the secondary, but at least connections were able to be made. So when your primary failed the secondary/tertiary failed, too??? You stated that they wouldn't start, as though they hadn't been running. If they hadn't been running, there's probably no local checkpoint files, which I would think would prevent them from starting successfully. Were there any error messages? Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -----Original Message----- Sent: Tuesday, April 01, 2003 5:09 AM To: Multiple recipients of list ORACLE-L Hi All, Oracle 8.1.7.4 Win 2000 ONAMES with region database I have ONAMES repository on server1 I have 2 additional onames services on server2 and server3(no database/repository). I received a NNO-50 serious errors in configuration data. I do not know how it happened but I had to truncate and reload nmo_master and the 3 onrs_* tables. However this error caused a single point-of-failure. None of the oname services on all 3 servers would start. I was under the impression under these circumstances that Oracle would use CHKP* files. How can I prevent a single point-of-failure other than some type of hot standby? Can I have 2 repositories? If so where can I get doc to set this up? Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
