Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: ora-12500

Re: ora-12500

From: Luc Gyselinck <Luc.Gyselinck_at_nospampandora.be>
Date: Wed, 12 Jan 2005 21:03:09 GMT
Message-ID: <hggFd.29076$rx.2759708@phobos.telenet-ops.be>


Verify your licences on Windows (Control Panel -> Licencing). How many connections to Windows are allowed ? A 'Per server' maximum number, or a (unlimited) 'Per seat' number of maximum connections ?

<jskishor_at_yahoo.co.in> wrote in message
news:1105529739.037123.163960_at_c13g2000cwb.googlegroups.com...
> hi all, this is my first mail to this group , i have a peculiar problem
> of ora-12500. My database is on oracle 9.0.1.1.1 and have dedicated
> server.my operating system is windows 2003 server.
>
> the problem arises at 337 connections, i set my process to 500, my RAM
> is 2gb, job_queue_process=5.
> initially i thought,this error could be because of low physical memory
> and made it 4gb RAM, the change here is the problem arises at 454
> connections while i set my processes to 700,job_queue_process=20.
>
> so, i changed the
> shared_pool_size=100m,db_cache_size=704m,sga_max_size=1200m, i started
> up the second listener also but of no avail.
>
> please help me
>
> kishore
>
Received on Wed Jan 12 2005 - 15:03:09 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US