Swap, memory, kernal config? - ORA-12500 error

[Anand_31]

Hi there,

I think you need to investigate this further before you add any RAM. It is good that you can add RAM but maybe the problem is elsewhere!

Why is so much swapping happening?!? Who is swapping?!? can you send me the init.ora/SPFILE file?

2GB is a decent amount of RAM to start off with. Oracle needs about 1.5MB per user connection it is just SQL Plus connections and about 5MB per user if it Forms,etc.

Maybe your init.ora is not configured properly and that's why all the memory is used up. For a start, just reduce the SHARED_POOL_SIZE parameter to about 96M or 128M. Most people bumo this up to very high values. You don't need to.

The DB_CACHE_SIZE can be big (but keep it below 1280MB). Start with 256MB for DB_CACHE_SIZE, even if your application is huuuugggge ..as the developers say!

let us know what happens after these changes to the init.ora. I am quite sure your swapping will vanish.

Regards
anand

[Anand_31]

Hi there,

I think you need to investigate this further before you add any RAM. It is good that you can add RAM but maybe the problem is elsewhere!

Why is so much swapping happening?!? Who is swapping?!? can you send me the init.ora/SPFILE file?

2GB is a decent amount of RAM to start off with. Oracle needs about 1.5MB per user connection it is just SQL Plus connections and about 5MB per user if it Forms,etc.

Maybe your init.ora is not configured properly and that's why all the memory is used up. For a start, just reduce the SHARED_POOL_SIZE parameter to about 96M or 128M. Most people bumo this up to very high values. You don't need to.

The DB_CACHE_SIZE can be big (but keep it below 1280MB). Start with 256MB for DB_CACHE_SIZE, even if your application is huuuugggge ..as the developers say!

let us know what happens after these changes to the init.ora. I am quite sure your swapping will vanish.

Regards
anand

[Anand_31]

Hi there,

I think you need to investigate this further before you add any RAM. It is good that you can add RAM but maybe the problem is elsewhere!

Why is so much swapping happening?!? Who is swapping?!? can you send me the init.ora/SPFILE file?

2GB is a decent amount of RAM to start off with. Oracle needs about 1.5MB per user connection it is just SQL Plus connections and about 5MB per user if it Forms,etc.

Maybe your init.ora is not configured properly and that's why all the memory is used up. For a start, just reduce the SHARED_POOL_SIZE parameter to about 96M or 128M. Most people bumo this up to very high values. You don't need to.

The DB_CACHE_SIZE can be big (but keep it below 1280MB). Start with 256MB for DB_CACHE_SIZE, even if your application is huuuugggge ..as the developers say!

let us know what happens after these changes to the init.ora. I am quite sure your swapping will vanish.

Regards
anand

[Indira Aramandla]

Hi,

In many cases the error ORA-12500 is caused due to lack of resources in the Unix Box, if you are enable to connect to database and randomly you get the error your operating system is reached the maximum values for some resources. Otherwise, if you get the error in first connection the problem may be in the configuration of the system.

Finding the resource which is been reached is difficult, indicates some suggestion to solve the problems. You can look at Shmmax,Semaem
Semaem,semmns

Oracle requires that you have in between two to four times the amount of physical ram that is allocated by default as swap space. In this particular situation, you will need to create auxilary swap space to free up additional ram.

Creating auxilary swap space frees up physical ram allowing the system additional resources for successful connection attempts above five clients.

[Volker Borowski]

Hi,

check your Oracle-Configuration in addition.
Esp. processes and sessions can limit the number of concurrent connections.

Do you run dedicated or multi-threaded configuration ???

In not security-relevant, please attach listener.ora and init?????.ora.

Volker

[TWBSupport]

Anand -
Here's our init.ora. I'm not the DBA, I'm the Sys Admin, so if there are any questions as to why he set it up this way, I will have to ask him. Hope this can give you some usable information. thanks

[TWBSupport]

Here's the listener.ora

[TWBSupport]

Here's the spfile.. Thanks to all of you.

[TWBSupport]

Indira -
I do have a question for you. If the HP guys are telling me that hitting the SWAP is bad, but you are basically telling me with Oracle, that's the way it should be. I'm slightly confused. Why is it bad on one hand, but not the other?

[Steven E. Protter]

I would suggest that you use tnsping to validate the tnsnames.ora and listener.ora structure.

A subtle error in there might cause problenms.

You might want to consider relinking oracle after making changes to your system.

Lastly, are you up to date on HP patches. March 2003 or June 2003 is pretty stable and Oracle recommends staying current on this stuff.


I'm providing links to other threads based on this error, because frankly, I'm out of ideas:

http://search.hp.com/redirect.html?url=http%3A//forums.itrc.hp.com/cm/QuestionAnswer/1,,0x2a1b8ffa98a2d5118ff10090279cd0f9,00.html&qt=ORA-12500&hit=2

This one has some information posted by me on this issue:
http://search.hp.com/redirect.html?url=http%3A//forums.itrc.hp.com/cm/QuestionAnswer/1,,0xb61d5fe8b250d71190080090279cd0f9,00.html&qt=ORA-12500&hit=1

SEP