Yeah! Put it in Oracle*Names. > -----Original Message----- > From: Jeremiah Wilton [mailto:[EMAIL PROTECTED]] > 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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).