ora-12500

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 - 05:35:39 CST