Re: ora-12500

Reply embedded ...

On 12 Jan 2005 03:35:39 -0800, 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

What made you think this? Did you look up what an ORA-12500 means? (btw, all ORA-12nnn messages are actually TNS-12nnn, which is what you will have to look up at tahiti.oracle.com)

>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.

Now you're really shooting in the dark. What indicated these settings are even remotely related? Why the second listener?

Go to tahiti.oracle.com. (You'll need to sign up for a free OTN account if you don't already have one. It will be the best 30 seconds you ever invest in your Oracle career.) Do an error message lookup on TNS-12500. Read it carefully. Since this seems to occur at some threshold level (instead of every time) I'd suspect the last sentence of that description is going to be the operative one for you.
>
>please help me
>
>kishore

Thanks.

• Ed Stevens

Cohn's Law: The more time you spend in reporting on what you are doing, the less time you have to do anything. Stability is achieved when you spend all your time doing nothing but reporting on the nothing you are doing. Received on Wed Jan 12 2005 - 07:33:50 CST