Re: How to set up shared servers?

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Mon, 9 Jun 2003 21:00:48 +0200
Message-ID: <ve9qmu71ka1dc7@corp.supernews.com>

"Peter" <peter_at_nomorenewsspammin.ca> wrote in message news:bfk9ev8gnhct8mosqv02hl4hlqlu6mclhv_at_4ax.com...
> 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))(servi
ce=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.
>
>

Likely this will end up in the error above for which the description is TNS-12523 TNS:listener could not find instance appropriate for the client connection

Cause: The listener could not find any available (database) instances, that are appropriate for the client connection.

Action: Run "lsnrctl services" to ensure that the instance(s) are registered with the listener, and have READY status.

You don't have any dispatchers running, and the listener will search for dispatchers, which it won't find.
It is more customary to use (server=dedicated) for the few cases you want to have a dedicated connection despite MTS running (because you need to shut the database which won't be possible in MTS) than the other way around. You really need to
to reply remove '-verwijderdit' from my e-mail address run lsnrctl services, and maybe check to alert to find out why dispatchers aren't started, or maybe trace the listener (set trace_level=16 in lsnrctl), and then bounce the database.

Regards

-- 
Sybrand Bakker
Senior Oracle DBA

Received on Mon Jun 09 2003 - 14:00:48 CDT