How to Increase the shmmax parameter with Oracle database online?

[TEJORATH]

I hope you all have read the title properly guys I really need to know what can be the exact solution for this problem, as I am really trying my level best to get some solutions for it so that’s why I need some urgent solution for it so please do reply as soon as possible to me I am waiting for your response. Well I have tried some editing stuff and executing the command in the command prompt but that really did not help me at all .so that’s why I am asking you all to help me here suggest me some quick solutions for it.

[Ernesto4]

Try editing the command named /etc/sysctl.conf kernel.shmmax=3112311231 that will help and onece you have done with the editing stuff then what you have to do is execute the flowing command called as sysctl -p /etc/sysctl.conf, that will bring a lot of benefit for you so that’s the perfect solution for you in this situation so work on them accordingly and in case if you are having any problem then do let me know about it. I will try and work on something else.

[TEJORATH]

Yes I have tried this method and I forgot to mention about the same in the above description so I am very much sorry about it well I did try with the command that you had given but unfortunately for me it did not work well so that’s what I want to say here hope you all have understand the situation in which I am in right now. So suggest me something else so that I can get some quick solutions to solve my problem, I know you will help me out of these.

[Ernesto4]

Ok seems to be some problem with the shared memory and see what the heck is going out there now you must be wondering how to check out the shared memory? So for checking the shared memory you will have to see to it that you run this following command cat /proc/sys/kernel/shmmax and having done that you will have to echo a number on the /proc/sys/kernel/shmmax "echo number > /proc/sys/kernel/shmmax. So do try it and let me know if it works out now.

[mesterio]

Yes I completely agree with t he above user yes the particular command is correct but after trying out with the command prompt i.e after running the command cat /proc/sys/kernel/shmmax you can either echo the number or you can also try out one more thing and that is ‘sysctl -w kernel.shmmax=number’ put the number directly in the command that has been specified there so I hope you all have got the point that I am trying to say here, you can work out with this method as well as a kind of alternative option. This commands can be used for testing.

[TEJORATH]

Hey thanks that really did worked out for me I checked the shared memory and guess what I identified the problem so loads of thanks for you all thanks for helping me out in this situation sometimes coding the stuffs does take a hell lot of time for me so appreciate that you all did help me here. I am happy with the results that i have got here. So thanks for the help that you shared here. I appreciate your efforts for the same.