topic Re: need to run more oracle processes... in Operating System - HP-UX

need to run more oracle processes...

Jesper Andersson_1 — Mon, 08 Apr 2002 07:43:40 GMT

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!!!!

Re: need to run more oracle processes...

Steve Steel — Mon, 08 Apr 2002 07:48:50 GMT

hi

try nproc

Steve Steel

Re: need to run more oracle processes...

Clemens van Everdingen — Mon, 08 Apr 2002 07:50:11 GMT

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.

Re: need to run more oracle processes...

Steve Steel — Mon, 08 Apr 2002 07:52:06 GMT

Hi

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

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

steve Steel

Re: need to run more oracle processes...

Jesper Andersson_1 — Mon, 08 Apr 2002 07:52:51 GMT

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....

Re: need to run more oracle processes...

Jesper Andersson_1 — Mon, 08 Apr 2002 07:55:28 GMT

I have change in the init file to 200 process.

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

/Jesper

Re: need to run more oracle processes...

Jesper Andersson_1 — Mon, 08 Apr 2002 08:03:05 GMT

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)

Re: need to run more oracle processes...

Volker Borowski — Mon, 08 Apr 2002 08:04:10 GMT

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

Re: need to run more oracle processes...

Wodisch — Mon, 08 Apr 2002 08:09:26 GMT

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

Re: need to run more oracle processes...

Jesper Andersson_1 — Mon, 08 Apr 2002 08:16:17 GMT

Maxuprc is set to 1000 and in each oracle init file have I tested to set up processes to 200 without luck..

Re: need to run more oracle processes...

T G Manikandan — Mon, 08 Apr 2002 08:18:14 GMT

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

Re: need to run more oracle processes...

T G Manikandan — Mon, 08 Apr 2002 09:28:16 GMT

vmunix: file: table is full

check these links
http://forums.itrc.hp.com/cm/QuestionAnswer/1,,0x7517cb60e503d6118ff40090279cd0f9,00.html
http://forums.itrc.hp.com/cm/QuestionAnswer/1,,0x22388ffa98a2d5118ff10090279cd0f9,00.html

Re: need to run more oracle processes...

Bill Hassell — Mon, 08 Apr 2002 13:04:52 GMT

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).

Re: need to run more oracle processes...

Jesper Andersson_1 — Mon, 08 Apr 2002 13:10:24 GMT

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

TANKS!!!!