Tales From A Lazy Fat DBA

Den of an Oracle DB Performance freak & a fan of PostgreSQL & Cassandra …. \,,/

  • Likes

    • 149,221
  • Archives

  • Categories

  • Subscribe

  • Advertisements
  • Prashant Dixit is the FatDBA

  • Follow Tales From A Lazy Fat DBA on WordPress.com
  • My Twitter Feeds

  • Disclaimer!

    FatDBA or Oracle ‘Ant’ is an independent web-blog/site.The experiences, Test cases, views, and opinions expressed in this website are my own and does not reflect the views or opinions of my employer.

    This site is independent of and does not represent Oracle Corporation in any way. Oracle does not officially sponsor, approve, or endorse this site or its content.
    Product and company names mentioned in this website may be the trademarks of their respective owners.

OS Kernel Parameters Explained (Oracle Installations)

Posted by FatDBA on July 22, 2012

During Manual Oracle Database Installation on Linux/Unix Platforms we need to perform some changes to Kernel Values. Below are the Kernel parameters needed to be change before installation begins:

If you have not used the “oracle-validated” package to perform all prerequisites, you will need to manually perform the following setup tasks.

To check existing Kernel parameters settings use below string to verify:
# cat /proc/sys/kernel/shmmni
4096

To check Semaphores Values:
[oracle@localhost orcl]$ ipcs -ls

—— Semaphore Limits ——–
max number of arrays = 128
max semaphores per array = 250
max semaphores system wide = 32000
max ops per semop call = 100
semaphore max value = 32767

kernel.shmmax = 2147483648
Meaning: This parameter defines the maximum size in bytes of a single shared memory segment that a Linux process can allocate in its virtual address space.Since the SGA is comprised of shared memory, SHMMAX can potentially limit the size of the SGA. SHMMAX should be slightly larger than the SGA size. If SHMMAX is too small, you can get error messages similar to this one:

ORA-27123: unable to attach to shared memory segment

kernel.shmall = 2097152
Meaning: This parameter sets the total amount of shared memory pages that can be used system wide.

kernel.shmmni = 4096
Meaning: This parameter sets the system wide maximum number of shared memory segments. Oracle recommends SHMMNI to be at least 4096 for Oracle 10g.

# semaphores: semmsl, semmns, semopm, semmni
kernel.sem=250 32000 100 128

semmsl: This parameter defines the maximum number of semaphores per semaphore set.
semmns: This parameter defines the total number of semaphores (not semaphore sets) for the entire Linux system.
semopm: This parameter defines the maximum number of semaphore operations that can be performed per semop(2) system call (semaphore call).
semmni: This parameter defines the maximum number of semaphore sets for the entire Linux system.

Advertisements

One Response to “OS Kernel Parameters Explained (Oracle Installations)”

  1. We’re a group of volunteers and starting a brand new scheme in our community. Your web site provided us with valuable info to work on. You have done an impressive activity and our entire neighborhood might be grateful to you.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

 
%d bloggers like this: