Path: news.easynews.com!core-easynews!newsfeed1.easynews.com!easynews.com!easynews!feeder.buzzardnews.com!sjc70.webusenet.com!news.webusenet.com!sn-xit-02!sn-xit-06!sn-post-01!supernews.com!corp.supernews.com!not-for-mail
From: Sybrand Bakker <gooiditweg@sybrandb.demon.nl>
Newsgroups: comp.databases.oracle.server
Subject: Re: How to set up shared servers?
Date: Fri, 06 Jun 2003 19:19:43 +0200
Organization: Posted via Supernews, http://www.supernews.com
Message-ID: <c1j1evkn2tevdgp6ptrk6d2os2rjql9gjr@4ax.com>
Reply-To: postbus@sybrandb.demon.nl
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
X-Complaints-To: abuse@supernews.com
Lines: 42
Xref: core-easynews comp.databases.oracle.server:188893
X-Received-Date: Fri, 06 Jun 2003 10:18:50 MST (news.easynews.com)

On Fri, 06 Jun 2003 07:37:03 GMT, Peter <peter@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.
If you are using non standard parameters (which you are) you also need
to setup the local_listener parameter to the net8 address of your
listener.
Finally, your listener has to be running before starting the database,
as the database needs to register itself with the listener.
If you run lsnrctl services you should be able to see the dispatchers
running.
Apparently your current dispatcher parameter is incorrect, and you
should check the alert log for any error message during startup.

And, BTW, all this info *IS* in the net8 manual.


Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address