Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to increase MAX number of connections for Oracle DB server?
"gazzag" <gareth_at_jamms.org> wrote in message
news:1170428948.496209.81020_at_h3g2000cwc.googlegroups.com...
> On 2 Feb, 15:01, "jshen...._at_gmail.com" <jshen...._at_gmail.com> wrote:
>> Hi,
>>
>> I'm new to system tuning of Oracle DB. Our Oracle DB seems to only
>> allow 128 connections,
>> while the DB connection requirement has exceed 250. How could I
>> increase the max number of connection allowed for this server? should
>> I tune any other parameter ?
>>
>> Joe
>>
>> ps. there are 16 CPUs with 8GB DRAM and Disk arrays installed . The OS
>> is HP-UX 11i.
>
> Lots of information regarding the server configuration but, sadly, no
> Oracle version ;-)
>
> Anyway, check out the SESSIONS initialisation parameter:
>
> http://download-uk.oracle.com/docs/cd/B19306_01/server.102/b14237/initparams190.htm#sthref785
>
> HTH
>
> -g
I'm guessing that you have license_max_sessions set in the init.ora
-- Terry DykstraReceived on Fri Feb 02 2007 - 09:48:39 CST