Path: news.easynews.com!core-easynews!newsfeed1.easynews.com!easynews.com!easynews!news.he.net!news-hog.berkeley.edu!ucberkeley!newsfeed.stanford.edu!postnews1.google.com!not-for-mail
From: drak0nian@yahoo.com (Paul Drake)
Newsgroups: comp.databases.oracle.server
Subject: Re: How to set up shared servers?
Date: 6 Jun 2003 15:22:58 -0700
Organization: http://groups.google.com/
Lines: 25
Message-ID: <1ac7c7b3.0306061422.338ee954@posting.google.com>
References: <4vg0evggms720g50nqikk4ohck0i3vjnjr@4ax.com>
NNTP-Posting-Host: 156.43.4.1
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Trace: posting.google.com 1054938179 11400 127.0.0.1 (6 Jun 2003 22:22:59 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: 6 Jun 2003 22:22:59 GMT
Xref: core-easynews comp.databases.oracle.server:188934
X-Received-Date: Fri, 06 Jun 2003 15:22:16 MST (news.easynews.com)

Peter <peter@nomorenewsspammin.ca> wrote in message news:<4vg0evggms720g50nqikk4ohck0i3vjnjr@4ax.com>...
> 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


any chance that you're actually using a stored parameter file (spfile)?

Pd