Swaminathan K
asked on
Oracle database installation
Hi Team,
While installing oracle database 11gr2 , we need to configure the below settings in the Linux server , I would like to know why these parameters are set and what role they play in regard to oracle database
Using any text editor, create or edit the /etc/sysctl.conf file, and add or edit lines similar to the following:
Note:
Include lines only for the kernel parameter values to change. For the semaphore parameters (kernel.sem), you must specify all four values. However, if any of the current values are larger than the minimum value, then specify the larger value.
fs.aio-max-nr = 1048576
fs.file-max = 6815744
kernel.shmall = 2097152
kernel.shmmax = 536870912
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
net.ipv4.ip_local_port_ran ge = 9000 65500
net.core.rmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048576
While installing oracle database 11gr2 , we need to configure the below settings in the Linux server , I would like to know why these parameters are set and what role they play in regard to oracle database
Using any text editor, create or edit the /etc/sysctl.conf file, and add or edit lines similar to the following:
Note:
Include lines only for the kernel parameter values to change. For the semaphore parameters (kernel.sem), you must specify all four values. However, if any of the current values are larger than the minimum value, then specify the larger value.
fs.aio-max-nr = 1048576
fs.file-max = 6815744
kernel.shmall = 2097152
kernel.shmmax = 536870912
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
net.ipv4.ip_local_port_ran
net.core.rmem_default = 262144
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048576
These settings are for the kernel and resource allocation network to imporve the performance of the database server , not the database.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Your question, "I would like to know why these parameters are set and what role they play in regard to oracle database"...
To know the specific reason why Oracle suggests these be set can only be answered by Oracle.
You can look up docs for each parameter + guess... still... best to open a support ticket with Oracle for the real answer.
To know the specific reason why Oracle suggests these be set can only be answered by Oracle.
You can look up docs for each parameter + guess... still... best to open a support ticket with Oracle for the real answer.
Oracle databases and the Linux O/S are both very configurable systems. Different values can be set to optimize your combination of: server hardware resources, Oracle version, database size, number of user connections etc. The Linux values that Oracle recommends are minimum values for these various Linux settings that Oracle has learned are required for good performance of Oracle on Linux.
Johnsone gave you some good brief descriptions on some of these. To get best performance from your Oracle system, I suggest that it may be much more helpful to focus on the Oracle spfile parameters (especially SGA_TARGET) and on the SQL statements that get executed frequently in your application (do they need different or additional indexes, etc.) than to focus on these Linux system settings.
Johnsone gave you some good brief descriptions on some of these. To get best performance from your Oracle system, I suggest that it may be much more helpful to focus on the Oracle spfile parameters (especially SGA_TARGET) and on the SQL statements that get executed frequently in your application (do they need different or additional indexes, etc.) than to focus on these Linux system settings.
Also, the Oracle installation documentation does give brief descriptions. Try this link. That is the Linux installation guide for 11r2. If you read through that section, there are some basic descriptions.
The Oracle 19 documentation, here, has some better descriptions of the kernel parameters. The Oracle version doesn't matter, what the kernel parameters do doesn't change with the Oracle version.
The Oracle 19 documentation, here, has some better descriptions of the kernel parameters. The Oracle version doesn't matter, what the kernel parameters do doesn't change with the Oracle version.