ORACLE KERNEL PARAMETERS

-
Oracle Kernel Parameters:
========================


We have different kernel parameters

 SHM means shared memory segments , which are being used by the SGA

shmax ->  It defines the maximum size of shared memory segment
shmin ->  It defines the minimum size of shared memory segment
shmni ->  It defines the maximum  number of shared memeory segments available on the system
shmall -> It defines the total amoumnt of shared memory allocated  on the system


Semaphore , it is a way of locking or applying flag on shared memory

semmsl -> number of semaphores per set
semmns -> total number of available semaphores
semopm -> number of operations can be performed per semaphore call



file_max -> defined number of files can be opened at once
ip_local_port_range -> defines the port range
rmem_default and rmem_max -> defines the min and max size of receive buffer
wmem_default and wmem_max -> defines the min and max size of send buffer



ASm_Parameters:
==============

INSTANCE_TYPE
ASM_DISKGROUP // ASM process will discover and mount the disks
ASM_DISKSTRING // This is directory path where AMS does the discovery in that location
ASM_POWER_LIMIT
AU_SIZE
COMPATIBLE.ASM
DISK_REAIR_TIME


ASM BACKGROUND PROCESS:
======================

ASMB -> Runs on ASM instance and performs AMS monitoring and share all the ASM informatuion
RBAL -> Coordinates rebalnce activity
ARBn -> it performs actuall rebalnce data extents
GMON -> Maintains disk member-ship
MARK -> it marks AU as stale  

Comments

Post a Comment

Popular posts from this blog

How to make CRS and ASM not to restart after server reboot

-
I have noticed that server rebooting is taking lot of time on a VM machine for every reboot, so I have decided to auto start of the crs and ASM service During this phase I have noticed an attribute called auto_start when I try to execute the below command crsctl stat res -p This AUTO_START attribute is there for several resources like ora.ASM ,ora.crs,ora.DATA_DG it has got 2 options restore(0) , never(2) and always (1) always (1)  Causes the resource to restart when the node restarts regardless of the resource’s state when the node stopped -restore (0)  Does not start the resource at restart time if it was in an offline state, such as STATE=OFFLINE, TARGET=OFFLINE, when the node stopped. The resource is restored to its state when the node went down. The resource is started only if it was online before and not otherwise. -never (2)  Oracle Clusterware never restarts the resource regardless of the resource’s state when the node is stopped. So I have dec...
Read more

How to repair ASM disk header

-
Image
What is ASM disk header corruption? ASM disk header corruption is a loss or damage to the disk header which contains the metadata essential for the operation and availability of an ASM disk group in Oracle. Imagine that you have an ASM disk corruption in any of the ASM diskgroups that have critical business data and the diskgroup has been configured as "EXTERNAL" redundancy, meaning that if one disk is inaccessible the whole diskgroup will be unavailable. Now what? Is your only option to restore it from backup by recreating the diskgroup or are there any other faster ways to recover the data? Here you need to find out whether it’s a complete loss of data in the ASM disk or is it just a header corruption. Hopefully for you, this is just a header corruption. Because, yes, there is a way out!  Below find the steps to restore from the ASM header corruption. Most of the data in the ASM disk header is of interest to that disk only. However, some information in the ASM disk header ...
Read more

How to replace ASM failed disk?

-
Oracle Automatic Storage Management (ASM) was introduced in Oracle 10g. ASM provides advance storage management features such as DISK I/O re-balancing, volume management and easy database file name management. It also can provide MIRRORING of data for high availability and redundancy in the event of a disk failure (Mirroring is optional). ASM guarantees that data extents (table,index row data etc.) in one disk are mirrored in another disk (normal redundancy) and in two disks (high redundancy). A few times I have faced ASM disk failures when redundancy (mirroring) was enabled and none of them resulted in an issue for an end user. ASM automatically detects the disk failure and services Oracle SQL requests by retrieving information from the mirrored (other) disk. Such a failure is handled gracefully and entirely managed by Oracle. I am very impressed by the fault tolerance capability in ASM. But soon the Oracle DBA must work with the system administrator to replaced the failed disk. If t...
Read more