When i install oracle 12cr2 on sles12 sp2 before run fix file scrips run…sh
(cmd: # /sbin/sysctl -a | grep kernelshmmax)
first value → shmmax = 3 294 967 296 after run scripts
second value → shmmax 3 959 529 472
after restart server then value is showing the first value and return old value that is first value(shmmax = 3 294 967 296)
so is it problem for continuos works oracle server because of decrease value
thanks…
efsal,
It appears that in the past few days you have not received a response to your
posting. That concerns us, and has triggered this automated reply.
These forums are peer-to-peer, best effort, volunteer run and that if your issue
is urgent or not getting a response, you might try one of the following options:
- Visit http://www.suse.com/support and search the knowledgebase and/or check all
the other support options available. - Open a service request: https://www.suse.com/support
- You could also try posting your message again. Make sure it is posted in the
correct newsgroup. (http://forums.suse.com)
Be sure to read the forum FAQ about what to expect in the way of responses:
http://forums.suse.com/faq.php
If this is a reply to a duplicate posting or otherwise posted in error, please
ignore and accept our apologies and rest assured we will issue a stern reprimand
to our posting bot…
Good luck!
Your SUSE Forums Team
http://forums.suse.com
Hi efsal,
[QUOTE=efsal;38156]When i install oracle 12cr2 on sles12 sp2 before run fix file scrips run…sh
(cmd: # /sbin/sysctl -a | grep kernelshmmax)
first value → shmmax = 3 294 967 296 after run scripts
second value → shmmax 3 959 529 472
after restart server then value is showing the first value and return old value that is first value(shmmax = 3 294 967 296)
so is it problem for continuos works oracle server because of decrease value
thanks…[/QUOTE]
have you tried setting the value via /etc/sysctl.conf? That should make it persist reboots.
Regards,
J
[QUOTE=jmozdzen;38227]Hi efsal,
have you tried setting the value via /etc/sysctl.conf? That should make it persist reboots.
Regards,
J[/QUOTE]
I did it for limits.so and it worked. But i didn’t think any that for memory params and i will try to it again.
But i think, Those values coming from /etc/init.d/oracle files. it sould be needs to change this file.
At the same time those value can changed to the new value.
Thanks.
Hello Efsal,
if you install the orarun package from the SuSE repos for SLES12 you have to configure the SHMMAX and SHMALL parameters
from /etc/sysconfig/oracle. The runfix did not do this for you because this is orarun SUSE spezial.
To set right parameter you need to compute the correct values. It is absolute important to set these parameter to the size of the SGA or maximal to your Memory.
https://community.oracle.com/thread/3828422
Hope that helps.
ps. HugePages is a very cool feature for oracle db.
*Till