Yeah! Put it in Oracle*Names.
> -----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?
>
> --
> 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).
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Gogala, Mladen
INET: MGogala_at_oxhp.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).
Received on Thu Jan 30 2003 - 09:14:15 CST
