Simpler Navigation for Servers and Operating Systems - Please Update Your Bookmarks
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
If you have bookmarked forums or discussion boards in Servers and Operating Systems, we suggest you check and update them as needed.
cancel
Showing results for 
Search instead for 
Did you mean: 

Oracle 9i on HP UX 11.0

Mohanraj Ramasamy
Occasional Visitor

Oracle 9i on HP UX 11.0

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
6 REPLIES
Helen French
Honored Contributor

Re: Oracle 9i on HP UX 11.0

Hi,

This may help you:

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

HTH,
Shiju

Life is a promise, fulfill it!
Steven Sim Kok Leong
Honored Contributor

Re: Oracle 9i on HP UX 11.0

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
Email: steven@beepz.com. Homepage: https://www.beepz.com
Printaporn_1
Esteemed Contributor

Re: Oracle 9i on HP UX 11.0

have you check log at background dump dest.
(bdump) there could be some ORA-XXXXX error.
enjoy any little thing in my life
Ravi_8
Honored Contributor

Re: Oracle 9i on HP UX 11.0

Hi,

In init.ora file increase the no of process(default it will be 50).
never give up
Mohanraj Ramasamy
Occasional Visitor

Re: Oracle 9i on HP UX 11.0

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
Honored Contributor

Re: Oracle 9i on HP UX 11.0

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