Go Back   TechArena Community > Software > Operating Systems
Become a Member!
Forgot your username/password?
Tags Active Topics RSS Search Mark Forums Read

Sponsored Links



How to Increase the shmmax parameter with Oracle database online?

Operating Systems


Reply
 
Thread Tools Search this Thread
  #1  
Old 26-05-2011
Member
 
Join Date: May 2011
Posts: 53
How to Increase the shmmax parameter with Oracle database online?
  

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.

Reply With Quote
  #2  
Old 26-05-2011
Member
 
Join Date: Nov 2009
Posts: 824
Re: How to Increase the shmmax parameter with Oracle database online?

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.
Reply With Quote
  #3  
Old 26-05-2011
Member
 
Join Date: May 2011
Posts: 53
Re: How to Increase the shmmax parameter with Oracle database online?

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.
Reply With Quote
  #4  
Old 26-05-2011
Member
 
Join Date: Nov 2009
Posts: 824
Re: How to Increase the shmmax parameter with Oracle database online?

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.
Reply With Quote
  #5  
Old 26-05-2011
Member
 
Join Date: Apr 2009
Posts: 967
Re: How to Increase the shmmax parameter with Oracle database online?

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.
Reply With Quote
  #6  
Old 27-05-2011
Member
 
Join Date: May 2011
Posts: 53
Re: How to Increase the shmmax parameter with Oracle database online?

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.
Reply With Quote
Reply

  TechArena Community > Software > Operating Systems
Tags: , , , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "How to Increase the shmmax parameter with Oracle database online?"
Thread Thread Starter Forum Replies Last Post
Joins in oracle database Adriana_andros Software Development 5 11-02-2010 08:53 PM
Dynamic SQL in Oracle database Adriana_andros Software Development 5 11-02-2010 07:49 PM
How to increase size of oracle logs GeforceUser Software Development 3 23-04-2009 11:13 PM
Passing parameter of Oracle procedure in PHP Halina Software Development 3 22-04-2009 08:46 PM


All times are GMT +5.5. The time now is 01:31 AM.