Making dispatchers re-read tnsnames.ora?

From: Jeremiah Wilton <jwilton_at_speakeasy.net>
Date: Thu, 30 Jan 2003 04:49:00 -0800
Message-ID: <F001.0053E585.20030130044900@fatcity.com>

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?

--

Jeremiah Wilton
http://www.speakeasy.net/~jwilton

--

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). Received on Thu Jan 30 2003 - 06:49:00 CST