- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Replace kernel parameters oracle 8.1.7 with oracle...
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-27-2004 04:08 PM
тАО09-27-2004 04:08 PM
Replace kernel parameters oracle 8.1.7 with oracle 9.1.2
Now my database system running Oracle 8.1.7 with configuration as follows:
- OS: HPUX 11i
- Database: Oracle 8.1.7
- Memory: 2GB
- Swap: 4096 MB
However, database often be down with message from GlancePlus appears like this : "File table over flow".
I want to change some OS kernel parameter, especially nfile parameter because these are very low (attach file).
Now I don't know what values is suitable?
Can I replace kernel parameter as Oracle 9.1.2 ?
(My configuration is corresponding to Oracle 9.1.2)
Pls help me ASAP.
Thanks in advanced.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-27-2004 04:14 PM
тАО09-27-2004 04:14 PM
Re: Replace kernel parameters oracle 8.1.7 with oracle 9.1.2
The problem you may run into is that you haven't bumped up the parameters enough.
If you are raising nfile don't forget maxuprc
Thats the maximum processes for a single user. That can be an issue with ias and oracle.
Here is the 9.x kernel parameters from the metalink site.
KSI_ALLOC_MAX (NPROC*8)
MAX_THREAD_PROC 256
MAXDSIZ 1073741824 bytes
MAXDSIZ_64BIT 2147483648 bytes
MAXSSIZ 134217728 bytes
MAXSSIZ_64BIT 1073741824
MAXSWAPCHUNKS 16384
MAXUPRC ((NPROC*9)/10)
MSGMAP (MSGTQL+2)
MSGMNI NPROC
MSGSEG 32767
MSGTQL NPROC
NCALLOUT (NKTHREAD+16)
NCSIZE ((8*NPROC+2048)+VX_NCSIZE)
NFILE (15*NPROC+2048)
NFLOCKS 4096
NINODE (8*NPROC+2048)
NKTHREAD (((NPROC*7)/4)+16)
NPROC 4096
SEMMAP (SEMMNI+2)
SEMMNI 4096
SEMMNS (SEMMNI*2)
SEMMNU (NPROC - 4)
SEMVMX 32768
SHMMAX AvailMem
SHMMIN 1
SHMMNI 512
SHMSEG 32
VPS_CEILING 64
These are minnimums.
SEP
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-27-2004 04:28 PM
тАО09-27-2004 04:28 PM
Re: Replace kernel parameters oracle 8.1.7 with oracle 9.1.2
These kernel parameters above I have just seen from Metalink.
But, I don't know whether these is suitable with Oracle 8.1.7 ?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-27-2004 04:40 PM
тАО09-27-2004 04:40 PM
Re: Replace kernel parameters oracle 8.1.7 with oracle 9.1.2
we have a configuration similar to yours:
- OS: HPUX 11i
- Database: Oracle 8.1.7.4
- Memory: 4GB
our nfile is determined by the formula: (15*NPROC+2048)
giving us: 63788
hope this helps!
regards
Yogeeraj
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-27-2004 08:41 PM
тАО09-27-2004 08:41 PM
Re: Replace kernel parameters oracle 8.1.7 with oracle 9.1.2
Your nfile maybe low. I had also problems in the past with this parameter and had to increase it! Do the following command (with database and apps running) to see if you have to increase it:
#sar -v 10 10
On the file-sz column you will get how much open files you have.
Resuming, I setted my nfiles to 6000, maxuprc to 300, maxusers to 150 and nproc was setted to 1220 by the formula: 20+8*MAXUSERS
You should also set your shmmax to something like 2/3 of your physical memory, so you can increase it to 1610612736...
Best Regards,
Eric Antunes