Re: ora-12500

jskishor_at_yahoo.co.in wrote:

> 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

Without the rest of the error message no help is possible. Post all error message with the associated text.

Also check whether is 9.0.1.1.1 certified for Win2003? There have been problems reported related to O/S swap space.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)


----== Posted via Newsfeeds.Com - Unlimited-Uncensored-Secure Usenet News==----
http://www.newsfeeds.com The #1 Newsgroup Service in the World! >100,000 Newsgroups
---= East/West-Coast Server Farms - Total Privacy via Encryption =---