Operating System - HP-UX
1748194 Members
4071 Online
108759 Solutions
New Discussion юеВ

Re: Oracle problem - is there a log?

 
Richard Woolley
Frequent Advisor

Oracle problem - is there a log?

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.

10 REPLIES 10
T G Manikandan
Honored Contributor

Re: Oracle problem - is there a log?

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
LucianoCarvalho
Respected Contributor

Re: Oracle problem - is there a log?

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.
LucianoCarvalho
Respected Contributor

Re: Oracle problem - is there a log?

sorry,

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

regards
T G Manikandan
Honored Contributor

Re: Oracle problem - is there a log?

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

T G Manikandan
Honored Contributor

Re: Oracle problem - is there a log?

You can also use

sar -v and check the proc-sz values

so that you can check whether the nproc values are crossed


Thanks
Richard Woolley
Frequent Advisor

Re: Oracle problem - is there a log?

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...
T G Manikandan
Honored Contributor

Re: Oracle problem - is there a log?

to prove do

#kmtune -l -q maxuprc

check the value

equate it with

#ps -ef|grep oracle|wc -l

Yogeeraj_1
Honored Contributor

Re: Oracle problem - is there a log?

hi,

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

hth
Yogeeraj
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)
Steven E. Protter
Exalted Contributor

Re: Oracle problem - is there a log?

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
Steven E Protter
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com