Oracle 9i on HP UX 11.0

[Mohanraj Ramasamy]

Hi ,

I am trying to do load test an application using Oracle 9i on HP-UX 11.o and it hangs when the no: of simultaeous user used for testing is increased to roughly around 20.
The same application has been load tested and is working fine on oracle 8.0i.

Is there a way to figure out quickly what could be the reason ?

-Renu

[Helen French]

Hi,

This may help you:

http://forums.itrc.hp.com/cm/QuestionAnswer/1,,0xa4bf4e49c5cdd5118ff40090279cd0f9,00.html

HTH,
Shiju

[Steven Sim Kok Leong]

Hi,

At the Oracle level,

Check your Oracle init file eg. init.ora whether you have limited the number of oracle processes to 20. If it is limited to 20, then increase it.

At the Unix level,

Check that your OS kernel parameters maxuprc and nproc has been set to a large enough value because both limits the number of concurrent Oracle server processes you have on your system.

Hope this helps. Regards.

Steven Sim Kok Leong

[Printaporn_1]

have you check log at background dump dest.
(bdump) there could be some ORA-XXXXX error.

[Ravi_8]

Hi,

In init.ora file increase the no of process(default it will be 50).

[Mohanraj Ramasamy]

Hi,

Thanks for all the answer but I am still having the same problem.

I have already increaased the no: of processes to 600 in init.ora file.ALso the value of nproc and maxuprc is 4096.
And there are no error log files in the bdump directory.

-Renu

[Sanjay_6]

Hi,

Try this link,

http://docs.oracle.com/HTML_Storage/a90347/ch1_admi.htm#92216

and look for max_users. It may help. Do you get any error message.

Hope this helps.

regds