Re: How to set up shared servers?

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.

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Mon Jun 09 2003 - 06:04:15 CDT