Path: news.easynews.com!core-easynews!newsfeed1.easynews.com!easynews.com!easynews!newshosting.com!news-xfer2.atl.newshosting.com!diablo.voicenet.com!prodigy.com!newsmst01.news.prodigy.com!prodigy.com!postmaster.news.prodigy.com!newssvr16.news.prodigy.com.POSTED!34d3422d!not-for-mail From: Karsten Farrell Newsgroups: comp.databases.oracle.server Subject: Re: Configuring dispatching mechanism Message-ID: References: X-Newsreader: MicroPlanet Gravity v2.60 Lines: 43 NNTP-Posting-Host: 67.117.210.172 X-Complaints-To: abuse@prodigy.net X-Trace: newssvr16.news.prodigy.com 1054914260 ST000 67.117.210.172 (Fri, 06 Jun 2003 11:44:20 EDT) NNTP-Posting-Date: Fri, 06 Jun 2003 11:44:20 EDT Organization: SBC http://yahoo.sbc.com X-UserInfo1: TSU[@I_A\S@KBUT^AZNX_T\BUSXB@DTMNHWB_EYLJZ]BGIELK^RAQFW[ML\THRCKV^GGZKJMGV^^_JSCFFUA_QXFGVSCYRPILH]TRVKC^LSN@DX_HCAFX__@J\DAJBVMY\ZWZCZLPA^MVH_P@\\EOMW\YSXHG__IJQY_@M[A[[AXQ_XDSTAR]\PG]NVAQUVM Date: Fri, 06 Jun 2003 15:44:20 GMT Xref: core-easynews comp.databases.oracle.server:188882 X-Received-Date: Fri, 06 Jun 2003 08:45:40 MST (news.easynews.com) peter@nomorenewsspammin.ca said... > When I was configuring the dispatching mechanism for a shared server > setting, I got some error messages. > What is the meaning of > "ORA-00105: dispatching mechanism not configured for network > protocol"? > > > SQL> alter system set shared_servers=10; > alter system set shared_servers=10 > * > ERROR at line 1: > ORA-02097: parameter cannot be modified because specified value is > invalid > ORA-00120: dispatching mechanism not enabled or installed > > > > SQL> alter system set > dispatchers='(address=(protocol=tcp)(host=127.0.0.1))(dispatchers=2)'; > alter system set > dispatchers='(address=(protocol=tcp)(host=127.0.0.1))(dispatchers=2)' > * > ERROR at line 1: > ORA-00105: dispatching mechanism not configured for network protocol > (address=(protocol=tcp)(host=127.0.0.1)) > > shared_servers and dispatchers are supposed to dynamic so I should be > able to change it. > > Thanks > You might want to check out the tips in this document: http://www.oracleadvice.com/Tips/MTS.htm You can find other documents by doing what I did and searching Google for the following: oracle "shared server" -- /Karsten DBA > retired > DBA