General
cancel
Showing results for 
Search instead for 
Did you mean: 

need to run more oracle processes...

SOLVED
Go to solution
Jesper Andersson_1
Occasional Advisor

need to run more oracle processes...

Hi,
Hope anyone can help me??

I running a oracle db with about 8 instances (Sid), totally is there about 205 oracle processes the problem is even if I try to change kernel parameters can I not run more oracle processes than this, the parameters that I have tried to change is
maxuprc, semmns. How can make it possible for me to allow more oracle processes.

Please help!!!!
Force be with you
13 REPLIES
Steve Steel
Honored Contributor

Re: need to run more oracle processes...

hi

try nproc


Steve Steel
If you want truly to understand something, try to change it. (Kurt Lewin)
Clemens van Everdingen
Honored Contributor

Re: need to run more oracle processes...

Hi,

Do you get any messages in syslog when you try to run more oracle processes ?
Might give us a clue for which parameter to look at.

C.
The computer is a great invention, there are as many mistakes as ever, but they are nobody's fault !
Steve Steel
Honored Contributor

Re: need to run more oracle processes...

Hi


Forgot to mentio9n. Look at the init file for the db


processes = 50 # SMALL
# processes = 100 # MEDIUM
# processes = 200


steve Steel
If you want truly to understand something, try to change it. (Kurt Lewin)
Jesper Andersson_1
Occasional Advisor

Re: need to run more oracle processes...

Thanks, for you quick reply!!
But,
Sorry, I missed nproc a have set that to 1044 so belive that the nproc should not be any trouble....
Force be with you
Jesper Andersson_1
Occasional Advisor

Re: need to run more oracle processes...

I have change in the init file to 200 process.

# processes = 50 # SMALL
# processes = 100 # MEDIUM
processes = 200

/Jesper
Force be with you
Jesper Andersson_1
Occasional Advisor

Re: need to run more oracle processes...

When I check the syslog then I find the following :

Apr 8 11:02:13 sid : su : + tb root-oracle
Apr 8 11:04:03 sid vmunix: file: table is full
Apr 8 11:04:03 sid vmunix: file: table is full
Apr 8 11:19:04 sid above message repeats 4 times
_________________


(sid = our db server)
Force be with you
Volker Borowski
Honored Contributor

Re: need to run more oracle processes...

Hello Jesper,

if you run 8 databases, you need to check all 8 init-ora files, to see which one troubles.

Adjust "processes" to 10% more than the number of connections you need to establish to the corresponding database. Adjust "sessions" to 10% more than the corresponding "processes" parameter".

If you have monitoring scripts, that restart your application without a database shutdown without a resonable wait between drop and restart, you might need to double+10% these values.

In addition, shm and sem parameters of the UX-Kernel might need a bit increase and may be even MAXUSERS.

Hope this helps
Volker
Wodisch
Honored Contributor

Re: need to run more oracle processes...

Hi,

the parameter you'll have to change is "maxuprc" and limits the amount of processes that can be running concurrently under one account, but not neccessarily within one session! So eight instances times 50 processes each (background plus server plus listener) would be a value of at least 400, make it 800, then (and care about your init*ora parameter "processes", too).

HTH,
Wodisch
Jesper Andersson_1
Occasional Advisor

Re: need to run more oracle processes...

Maxuprc is set to 1000 and in each oracle init file have I tested to set up processes to 200 without luck..
Force be with you
T G Manikandan
Honored Contributor

Re: need to run more oracle processes...

Hello,
You have to increase the parameter 'nfile'
for which in turn you should increase your maxusers which inturn will increase nproc.

This should solve your problem

Thanks
G Manikandan
T G Manikandan
Honored Contributor
Solution

Re: need to run more oracle processes...

Bill Hassell
Honored Contributor

Re: need to run more oracle processes...

nproc = 1044 is VERY smal for so much Oracle activity. It should be 2000 minimum, perhaps 5000. And at the same time, nfile must also be doubled or tripled. You can verify how close to the limits you are with:

sar -v 1

The proc and file columns are the important ones, the first number is current and the second is max. If either parameter is within 80% of max, time to double the value(s).

You can check is maxuprc is large enough with:

ps -u oracle | wc -l

This is the total number of processes currently owned by oracle (and the value that maxuprc will limit).


Bill Hassell, sysadmin
Jesper Andersson_1
Occasional Advisor

Re: need to run more oracle processes...

Tanks all of you !!! It looks to work fine now when I have changed the kernel parameters nproc and nfile .

TANKS!!!!
Force be with you