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

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
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
Luciano Carvalho
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.
Luciano Carvalho
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
Tim Sanko
Trusted Contributor

Re: Oracle problem - is there a log?

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