• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 637
  • Last Modified:

Oracle Kernel parameters

Hey what Oracle Kernel parameters do we need to know as an Oracle DBA. I really appreciate your help. Thanks in advance
0
hussainkhan22
Asked:
hussainkhan22
  • 6
  • 4
  • 2
  • +3
5 Solutions
 
slightwv (䄆 Netminder) Commented:
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
 
Chakravarthi AyyalaDatabase AdministratorCommented:
Do you mean kernel parameters for Oracle on Linux/Sun ?
0
Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

 
slightwv (䄆 Netminder) Commented:
Based on their previous questions it would be AIX.
0
 
hussainkhan22Author Commented:
Yes kernel parameters for oracle on linux/sol
0
 
slightwv (䄆 Netminder) Commented:
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
 
Joseph GanSystem AdminCommented:
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
 
slightwv (䄆 Netminder) Commented:
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
 
Joseph GanSystem AdminCommented:
That was in my notes. I was doing similar thing. Forgot which website I got from.
0
 
Fadi SODAH (aka madunix)Chief Information Security Officer, CISA, CISSP, CFR, ICATE, MCSE, CCNA, CCNP, CCIP, SCSC and SCECommented:
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
 
slightwv (䄆 Netminder) Commented:
@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
 
Fadi SODAH (aka madunix)Chief Information Security Officer, CISA, CISSP, CFR, ICATE, MCSE, CCNA, CCNP, CCIP, SCSC and SCECommented:
@slightwv
same as  oracle-base
0
 
Chakravarthi AyyalaDatabase AdministratorCommented:
In addition to all these, if you have big memory and using huge pages, those paraemters have to be set separately.
0
 
Chakravarthi AyyalaDatabase AdministratorCommented:
vm.nr_hugepages is the parameter for huge page setting.
0
 
Chakravarthi AyyalaDatabase AdministratorCommented:
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
 
slightwv (䄆 Netminder) Commented:
This question is likely derived from a previous question:
http://www.experts-exchange.com/Database/Oracle/Q_26618357.html
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 6
  • 4
  • 2
  • +3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now