- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: Swap, memory, kernal config? - ORA-12500 error
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-02-2003 09:48 PM
тАО09-02-2003 09:48 PM
Re: Swap, memory, kernal config? - ORA-12500 error
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-02-2003 09:50 PM
тАО09-02-2003 09:50 PM
Re: Swap, memory, kernal config? - ORA-12500 error
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-02-2003 09:51 PM
тАО09-02-2003 09:51 PM
Re: Swap, memory, kernal config? - ORA-12500 error
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-02-2003 11:39 PM
тАО09-02-2003 11:39 PM
Re: Swap, memory, kernal config? - ORA-12500 error
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-03-2003 02:44 AM
тАО09-03-2003 02:44 AM
Re: Swap, memory, kernal config? - ORA-12500 error
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-03-2003 04:13 AM
тАО09-03-2003 04:13 AM
Re: Swap, memory, kernal config? - ORA-12500 error
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-03-2003 04:21 AM
тАО09-03-2003 04:21 AM
Re: Swap, memory, kernal config? - ORA-12500 error
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-03-2003 04:23 AM
тАО09-03-2003 04:23 AM
Re: Swap, memory, kernal config? - ORA-12500 error
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-03-2003 05:23 AM
тАО09-03-2003 05:23 AM
Re: Swap, memory, kernal config? - ORA-12500 error
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?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-03-2003 05:34 AM
тАО09-03-2003 05:34 AM
Re: Swap, memory, kernal config? - ORA-12500 error
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
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com