need to run more oracle processes...

[Jesper Andersson_1]

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

[Steve Steel]

hi

try nproc


Steve Steel

[Clemens van Everdingen]

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.

[Steve Steel]

Hi


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


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


steve Steel

[Jesper Andersson_1]

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

[Jesper Andersson_1]

I have change in the init file to 200 process.

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

/Jesper

[Jesper Andersson_1]

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)

[Volker Borowski]

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]

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]

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