David COSTE wrote:
> Thanks a lot, Chuck
>
> "Chuck" <chuckh_at_softhome.net> wrote in message
> news:Xns937969F463B71chuckhsofthomenet_at_130.133.1.4...
>
>>"David COSTE" <dco_at_compaq.com> wrote in
>>news:7XJva.660$3c7.628_at_news.cpqcorp.net:
>>
>>
>>>Hello,
>>>
>>>I would like to have 2 oracle names server
>>>The 1st one on a linux platform running oracle 8.1.7.3
>>>The 2nd one a winXP platform running oracle 8.1.7.4
>>>I'm trying to use the cache replication mechanism to avoid creating a
>>>region database.
>>>I set up my names preferred servers to specify my 2 addresses, but
>>>when I try to discover the names server on which ever machine using
>>>Net8Assistant it cant't find the server running on the other machine
>>>
>>>Has someone already make this config work ? and how ?
>>>
>>>Thanks in Advance
>>>
>>>David
>>
>>We have been using Oracle Names for about 3 years with a similar setup to
>>yours - 2 names servers, dynamic discovery, no region database. One thing
>>we discovered is that all names servers should be on the same version,
>>same patch right down to the last digit. If you deviate from this you are
>>asking for problems. The documentation doesn't say anything about this,
>>but OTS has seen the same problems over and over and recommends the same
>>thing.
>>
>>We also run into problems where Net Assistant can't discover the names
>>servers on one client, while another on the same network segment can.
>>We've attributed it to just another bug in Oracle's code. Our solution is
>>to just copy a working sdns.ora file from another client. Net Assistant
>>may not be able to discover the names servers, but has no problems
>>accessing them once you tell it where they are.
>>
>>BTW we have never gotten the cache replication to work 100% of the time.
>>Most of the time it does but sometimes it doesn't, especially after a
>>names server crashes. In that case we usually find we can't even restart
>>the server unless we first delete the cache file. When it's restarted
>>you'd think it would resync the caches but usually it does not. Whether
>>it does or not seems to be very inconsistent. If it doesn't we just dump
>>the other server's cache to a tnsnames.ora file and load that into the
>>restarted server.
>
>
>
I just got 2 names servers working as well, and it was a real pain in
the a## getting the dynamic discovery working, perhaps because as Chuck
pointed out, I was not at the same patchset on both servers, 8.1.7.3 on
one and 8.1.7.4 on the other. Both my machines are on windows, but I may
try one on SuSE or RH if I get the time.
After getting the network admin to set up the servers with oranamesrvr0
and oranamesrvr1 I could still not discover them, then inexplicably it
just started working. But I did find out that if you have the local
names server running the net8 asst will not discover the other one
unless you shut it down, then it discovers it ok and you can start the
local one again.
I found the doc's on it quite muddled and the howtos I could find on the
net not much better. Best I think to distribute a sqlnet.ora file with
preferred servers on it to all the clients, and as far as cache
replication goes, I havent got it working yet so I'll do as Chuck
suggests and dump the cache to tnsnames each time I add a server then
load it to the other names server.
hth
Received on Mon May 12 2003 - 12:31:52 CDT
