Solved

Oracle Kernel parameters

Posted on 2010-11-17
16
625 Views
Last Modified: 2012-05-10
Hey what Oracle Kernel parameters do we need to know as an Oracle DBA. I really appreciate your help. Thanks in advance
0
Comment
Question by:hussainkhan22
  • 6
  • 4
  • 2
  • +3
16 Comments
 
LVL 76

Expert Comment

by:slightwv (䄆 Netminder)
Comment Utility
These can be found where?  Of course: The online docs.

You will need to check the installation guide for your specific OS.  This will have the important ones.
0
 
LVL 51

Accepted Solution

by:
HainKurt earned 100 total points
Comment Utility
0
 
LVL 8

Expert Comment

by:ReliableDBA
Comment Utility
Do you mean kernel parameters for Oracle on Linux/Sun ?
0
 
LVL 76

Expert Comment

by:slightwv (䄆 Netminder)
Comment Utility
Based on their previous questions it would be AIX.
0
 

Author Comment

by:hussainkhan22
Comment Utility
Yes kernel parameters for oracle on linux/sol
0
 
LVL 76

Assisted Solution

by:slightwv (䄆 Netminder)
slightwv (䄆 Netminder) earned 200 total points
Comment Utility
Have to even tried looking for the installation guides on the online docs?  It's really quite easy.

Go to:  http://www.oracle.com/pls/db112/portal.all_books

Look for:
Database Installation Guide for Linux
Database Installation Guide for Oracle Solaris

http://download.oracle.com/docs/cd/E11882_01/install.112/e17163/pre_install.htm#CIHBJIFJ

http://download.oracle.com/docs/cd/E11882_01/install.112/e16763/pre_install.htm#CHDCFJJE
0
 
LVL 16

Assisted Solution

by:Joseph Gan
Joseph Gan earned 100 total points
Comment Utility
For Enterprise Linux 4.5, the following lines should be appended to the "/etc/sysctl.conf" file.
kernel.shmall = 2097152
kernel.shmmax = 2147483648 # Smallest of -> (Half the size of the physical memory) or (4GB - 1 byte)
kernel.shmmni = 4096
# semaphores: semmsl, semmns, semopm, semmni
kernel.sem = 250 32000 100 128
net.ipv4.ip_local_port_range = 1024 65000
net.core.rmem_default=4194304
net.core.rmem_max=4194304
net.core.wmem_default=262144
net.core.wmem_max=262144
For Enterprise Linux 5.0, the following lines should be appended to the "/etc/sysctl.conf" file.
kernel.shmmni = 4096
# semaphores: semmsl, semmns, semopm, semmni
kernel.sem = 250 32000 100 128
net.ipv4.ip_local_port_range = 1024 65000
net.core.rmem_default=4194304
net.core.rmem_max=4194304
net.core.wmem_default=262144
net.core.wmem_max=262144
0
 
LVL 76

Assisted Solution

by:slightwv (䄆 Netminder)
slightwv (䄆 Netminder) earned 200 total points
Comment Utility
ganjos,

That appears to be a copy/paste from a website.  When you do this you need to paste the link of the site so the original author gets credit:

http://www.oracle-base.com/articles/11g/OracleDB11gR1InstallationOnEnterpriseLinux4and5.php
0
Highfive Gives IT Their Time Back

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

 
LVL 16

Expert Comment

by:Joseph Gan
Comment Utility
That was in my notes. I was doing similar thing. Forgot which website I got from.
0
 
LVL 25

Assisted Solution

by:madunix
madunix earned 100 total points
Comment Utility
http://ivan.kartik.sk/oracle/install_ora10gR2_redhat.html
kernel.shmall = 2097152
kernel.shmmax = 2147483648
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
fs.file-max = 65536
net.ipv4.ip_local_port_range = 1024 65000
net.core.rmem_default = 262144
net.core.rmem_max = 262144
net.core.wmem_default = 262144
net.core.wmem_max = 262144
0
 
LVL 76

Expert Comment

by:slightwv (䄆 Netminder)
Comment Utility
@madunix,

I'm on mobile right now so I can't verify this but is what you posted different than what ganjos posted previously?
0
 
LVL 25

Expert Comment

by:madunix
Comment Utility
@slightwv
same as  oracle-base
0
 
LVL 8

Expert Comment

by:ReliableDBA
Comment Utility
In addition to all these, if you have big memory and using huge pages, those paraemters have to be set separately.
0
 
LVL 8

Expert Comment

by:ReliableDBA
Comment Utility
vm.nr_hugepages is the parameter for huge page setting.
0
 
LVL 8

Expert Comment

by:ReliableDBA
Comment Utility
Hello hussainkhan22,
  Could you please answer the following questions?

1. How much RAM you have?
2. How much memory you want to allocate for Oracle?
3. Reason for asking Q 2 is to suggest you the values for parameters like shmmax accordingly.

 
0
 
LVL 76

Expert Comment

by:slightwv (䄆 Netminder)
Comment Utility
This question is likely derived from a previous question:
http://www.experts-exchange.com/Database/Oracle/Q_26618357.html
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime?  I'm talking things like: * Dropping columns * Shrinking allocated space * Removing chained blocks and restoring the PCTFREE * Re-or…
Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.
This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.

763 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now