Path: news.easynews.com!core-easynews!newsfeed1.easynews.com!easynews.com!easynews!newsfeed-east.nntpserver.com!nntpserver.com!chi1.webusenet.com!news.webusenet.com!pd2nf1so.cg.shawcable.net!residential.shaw.ca!news3.calgary.shaw.ca.POSTED!not-for-mail X-Trace-PostClient-IP: 24.80.236.234 From: Peter Newsgroups: comp.databases.oracle.server Subject: Re: How to set up shared servers? Organization: Bright Message-ID: References: <4vg0evggms720g50nqikk4ohck0i3vjnjr@4ax.com> X-Newsreader: Forte Agent 1.93/32.576 English (American) MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Lines: 107 Date: Fri, 06 Jun 2003 22:30:34 GMT NNTP-Posting-Host: 24.69.255.232 X-Complaints-To: abuse@shaw.ca X-Trace: news3.calgary.shaw.ca 1054938634 24.69.255.232 (Fri, 06 Jun 2003 16:30:34 MDT) NNTP-Posting-Date: Fri, 06 Jun 2003 16:30:34 MDT Xref: core-easynews comp.databases.oracle.server:188936 X-Received-Date: Fri, 06 Jun 2003 15:29:52 MST (news.easynews.com) On Fri, 6 Jun 2003 22:46:46 +0200, "Sybrand Bakker" wrote: >Comments embedded > >"Peter" wrote in message >news:jom1ev4h0f3mql1jqbdkt6n1ehd3ipuhnf@4ax.com... >> On Fri, 06 Jun 2003 19:19:43 +0200, Sybrand Bakker >> wrote: >> >> >On Fri, 06 Jun 2003 07:37:03 GMT, Peter >> >wrote: >> > >> >>If I included the dispatchers and shared_servers parameters in my init >> >>file and then restart my instance and then run >> >> >> >>On Oracle9i: >> >>>dispatchers=="(address=(protocol=tcp)(host=127.0.0.1)(port=1623))(service= >ser.db)" >> >>shared_servers=10 >> >> >> >> >> >>show parameter dispatchers >> >> >> >>and >> >> >> >>show parameter shared_servers >> >> >> >>it showed that both of these parameters were not even set. Why is >> >>that? How do I set them properly? did I miss something? I followed the >> >>the manuals already. >> >> >> >>Thanks >> >> >> >> >> >As I explained to you before, setting up the local loopback as host in >> >your dispatcher parameter doesn't make any sense. >> >> >> Now I have this parameter >> >> dispatchers="(address=(protocol=tcp)(host=127.0.0.1)(port=1721))" >> shared_servers=16 >> >> >> SQL> select * from v$dispatcher where name='D000'; >> >> NAME >> ---- >> NETWORK >> -------------------------------------------------------------------------- >------ >> PADDR STATUS ACC MESSAGES BYTES BREAKS >> OWNED >> -------- ---------------- --- ---------- ---------- ---------- >> ---------- >> CREATED IDLE BUSY LISTENER CONF_INDX >> ---------- ---------- ---------- ---------- ---------- >> D000 >> (address=(protocol=tcp)(host=127.0.0.1)(port=1721)) >> 798DC77C WAIT YES 0 0 0 >> 0 >> 0 57344 0 0 0 >> >> >> >> The loopback is not the problem when I did this on the test machine. >> It is when I included the (server=shared) to my (connect_data) >> in the tnsname.ora file that caused the problem. >> >> When I tried to connect: >> >> ORA-12523: TNS:listener could not find instance appropriate for the >> client connection >> >> >> What's wrong with (server=shared) ? > > >Without the tnsnames.ora, who can say? Please note however you can NOT use >127.0.0.1 from a client pc. 127.0.0.1 by design refers to the system itself >only. Yes, I know, that's why I am testing on a server machine which is not in live production at all. Here is the relevant tnsname.ora: # TNSNAMES.ORA Network Configuration File: C:\oracle\ora92\NETWORK\ADMIN\tnsnames.ora # Generated by Oracle configuration tools. mydb = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = mydb.domain)(SERVER = SHARED) ) )