topic Re: Oracle problem - is there a log? in Operating System - HP-UX

Oracle problem - is there a log?

Richard Woolley — Fri, 25 Apr 2003 10:20:59 GMT

Oracle has reported the following message:
--------------------
Cause: An error occured when creating a new process.
Action: Check errno. Perhaps a system limit on the number of processes has been exceeded.
----------------------

Is there any log that i can check to see if the host tried to exceed nproc (which is set at 9605)?

cheers,

mark.

Re: Oracle problem - is there a log?

T G Manikandan — Fri, 25 Apr 2003 10:25:32 GMT

I think the parameter you need to look at is

maxuprc-->maximum number of processes per user.

Probably oracle user has exceeded the no. of processes.

Just check /var/adm/syslog/syslog.log file for any errors.

If that is the case you will have to increase maxuprc

Thanks

Re: Oracle problem - is there a log?

LucianoCarvalho — Fri, 25 Apr 2003 10:29:20 GMT

Hi Mark,

You can check the file /var/adm/syslog/syslog.log. I the limit of fil table was exceeded, there will be a message like:
vmunix: file table overflow.
This indicates that you have to configure a new value for the nfile kernel parameter.

regards.

Re: Oracle problem - is there a log?

LucianoCarvalho — Fri, 25 Apr 2003 10:30:57 GMT

sorry,

the message will be.
vmunix: process table overflow
and the parameters would be: nproc and maxuprc.

regards

Re: Oracle problem - is there a log?

T G Manikandan — Fri, 25 Apr 2003 10:37:04 GMT

From the root

Just do a
#kmtune -l -q maxuprc

check the value

equate it with

#ps -ef|grep oracle|wc -l

If they are equal then you should increase maxuprc

Re: Oracle problem - is there a log?

T G Manikandan — Fri, 25 Apr 2003 10:42:20 GMT

You can also use

sar -v and check the proc-sz values

so that you can check whether the nproc values are crossed

Thanks

Re: Oracle problem - is there a log?

Richard Woolley — Fri, 25 Apr 2003 11:31:48 GMT

there is no mention in the syslog.log

Is there any other way i can prove that the limit has been hit and caused this error.

Like another log file?

Also since this, the operation has been attempted twice more with no problems...

Re: Oracle problem - is there a log?

T G Manikandan — Fri, 25 Apr 2003 11:37:38 GMT

to prove do

#kmtune -l -q maxuprc

check the value

equate it with

#ps -ef|grep oracle|wc -l

Re: Oracle problem - is there a log?

Yogeeraj_1 — Fri, 25 Apr 2003 12:36:02 GMT

hi,

if you have glance plus, you can also monitor the system state tables for further information online.

hth
Yogeeraj

Re: Oracle problem - is there a log?

Steven E. Protter — Fri, 25 Apr 2003 13:29:47 GMT

I'm attaching my background monitor script. It collects data, runs background and I've used it for years to deal with oracle issues.

You can change the collection period by modifying the script.

SEP

Re: Oracle problem - is there a log?

Tim Sanko — Fri, 25 Apr 2003 17:35:39 GMT

First I would examine my load with sar -v.

Then I would check to see how many processes are on the system owned by oracle.

I have my nproc at
MAXUSERS = 12000
(((10*MAXUSERS)/3)+128)

I suspect that it is nfile not nproc.

my nfile is ((15*NPROC)+2048).