Re: How to set up shared servers?

On Fri, 6 Jun 2003 22:46:46 +0200, "Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote:

>Comments embedded
>
>"Peter" <peter_at_nomorenewsspammin.ca> wrote in message
>news:jom1ev4h0f3mql1jqbdkt6n1ehd3ipuhnf_at_4ax.com...
>> 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) ?
>
>
>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)     )
  )   Received on Fri Jun 06 2003 - 17:30:34 CDT