Re: How to set up shared servers?

On Mon, 09 Jun 2003 13:04:15 +0200, Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl> wrote:

>On Mon, 09 Jun 2003 10:18:30 GMT, Peter <peter_at_nomorenewsspammin.ca>
>wrote:
>
>>On Fri, 06 Jun 2003 19:08:36 GMT, Peter <peter_at_nomorenewsspammin.ca>
>>wrote:
>>
>>>On Fri, 06 Jun 2003 19:19:43 +0200, Sybrand Bakker
>>><gooiditweg_at_sybrandb.demon.nl> wrote:
>>>
>>>>On Fri, 06 Jun 2003 07:37:03 GMT, Peter <peter_at_nomorenewsspammin.ca>
>>>>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) ?
>>>
>>>
>>
>>Is (server=shared) needed to set up shared server?
>>
>>Thanks
>
>
>No, not at all.
>Server =shared says: When there are shared connections possible and
>dedicated connections I *always* want a shared connection.
>If there are shared server and you don't specify anything you
>automatically get a shared connection.
>If there are shared server and you specify (server=dedicated) you get
>a dedicated connection.
>
 

Okay,
but what if there are only dedicated servers and I specify (server=shared)? Is this senario even posssible?

Thanks for your help. Received on Mon Jun 09 2003 - 13:31:53 CDT