RE: Making dispatchers re-read tnsnames.ora?

Jeremiah,

I have implemented an ONS service that serves the US and Asia, with one primary and one secondary, managing about 250 aliases to about 100 instances and serving about 3000 clients - mostly PCs and about 100 UNIX/NT servers. Planning to expand this to EU as well with their own primary/secondary ONS, and scripts to sync up the aliases. The Servers are DNS aliased so I can move them around during maintenance or downtimes - setting up another DNS server, loading up the TNS Names, and switching the DNS alias to the new box is a cinch. The primary serves upto about 22,000 requests per day. Cut and paste from status:

Server has been running for: 75 days 2 hours 9 minutes 59.21 seconds

Requests received:                        16528325

ONS is not without its downsides and quirks - found out that (a) both servers need to be in the same time zone (b) hard to trace timing issues (i.e. ONS response for remote clients), (c) needs some fixes to the repository when switching servers, as the server name rather than the DNS alias is stored in the table (d) ONS support within Oracle is rare/non-existent, and is not wide-spread among the Oracle community as well.

However, as Rich mentioned, it is quite failure-proof and chugs along merrily without any issues as long as it is setup correctly. Btw, I had implemenented the same method in far-away Brunei on a smaller scale. We wouldn't have been able to perform many major upgrades (server migration from Sequent to Solaris, box migrations, etc.) without ONS.

I am on 8.1.7 - not sure what 9i provides.... I did see a DUMP_LDAP command in NAMESCTL - haven't played with that though.

Hth,
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!

• The opinions and statements above are entirely my own and not those of my employer or clients **

> -----Original Message-----
> From: Jesse, Rich [mailto:Rich.Jesse_at_qtiworld.com]
> Sent: Thursday, January 30, 2003 12:56 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Making dispatchers re-read tnsnames.ora?
>
>
> Not that ONames doesn't have it's shortcomings, but I'm not
> sure how ONames
> is a single point of failure. Even in our little 35-alias
> ONames repository
> with only the root region, we have a secondary Names Server.
> With local
> checkpoint files, the repository is not required for
> continuous access, so
> there's no SPoF there.
>
> Could you expound a bit on that, Jeremiah?
>
> Thanks,
> Rich
>
>
> Rich Jesse System/Database Administrator
> rjesse_at_qtiworld.com Quad/Tech International,
> Sussex, WI USA
>
>
> -----Original Message-----
> Sent: Thursday, January 30, 2003 10:10 AM
> To: Multiple recipients of list ORACLE-L
>
>
> On Thu, 30 Jan 2003, Gogala, Mladen wrote:
>
> > Yeah! Put it in Oracle*Names.
>
> Will it make a difference? Does a dispatcher really re-query Names
> every time it tries to make a connection? No caching of service
> addresses? You promise?
>
> Off I go to convert my 300-instance organization to rely on a single
> point of failure and make a bunch more calls for every connect...
>
> YEEHAW! Oh wait. Names can't handle multiple interface and or
> distinct allocation of certain clients to certain
> listeners/interfaces. Oh well, and I thought I was going to have an
> exciting weekend. Guess its back to that Rubik's cube.
>
> --
> Jeremiah Wilton
> http://www.speakeasy.net/~jwilton
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Jesse, Rich
> INET: Rich.Jesse_at_qtiworld.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: 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).