RE: Making dispatchers re-read tnsnames.ora?

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



> > -----Original Message-----

> > From: Jeremiah Wilton [mailto:jwilton_at_speakeasy.net]

> > Sent: Thursday, January 30, 2003 7:49 AM

> > To: Multiple recipients of list ORACLE-L

> > Subject: Making dispatchers re-read tnsnames.ora?

> > 

> > 

> > Dispatchers and job queue processes read tnsnames.ora on process

> > startup in case they need to make an outound database link on behalf

> > of one of he sessions using that dispatcher.

> > 

> > If you make a change to the tnsnames.ora, dispatchers and job queue

> > processes won't register it unless you restart them.  For job queue

> > processes this is simple (alter syste set job_queue_processes = 0;

> > wait for jobs to complete, then set them back to the orig. value).

> > 

> > For dispatchers, you have to "shutdown dispatcher" (alter system

> > shutdown 'Dnnn').  Then, to get it to restart, you have to run "alter

> > system set dispatchers = '<foobar>';" with the COMPLETE dispatcher

> > specification for the parameter index you eliminated the dispatcher

> > from.

> > 

> > This is annoyingly complex.  When using multiple interfaces, multiple

> > dispatcher parameter indexes and a variety of listener attributes

> > within the dispatcher parameters, it can be difficult to get it right.

> > 

> > Also, you have to do the dispatchers ONE AT A TIME so you don't block

> > everyone out while you are waiting for the dispatchers to exit.  TIME

> > CONSUMING!

> > 

> > Is there a way to make the dispatcher just reread the tnsnames.ora

> > file without all this rigamaroll?


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jeremiah Wilton
  INET: jwilton_at_speakeasy.net

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).