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.
Showing results for 
Search instead for 
Did you mean: 

Maxusers in Oracle 10G

Jorge Pons
Trusted Contributor

Maxusers in Oracle 10G


My problem is number of users to connect. with 220/225 users, is not possible to connect. I don´t know why. In HPUX 11.23, the kernel parameter maxusers not exists.
The environment:
- 1 RX5670 HPUX 11.23, 2 proc, 8Gb RAM. for DB ORACLE 10G. (Itanium2)
- 3 RP24xx HPUX 11.11 1 proc, 2Gb RAM. for IAS.

In DB, I created about 20 GB of Swap, and the result are the same.

Thanks in advanced

Honored Contributor

Re: Maxusers in Oracle 10G

I onder if its not to do with some other params like max_thhread_proc, try:
max_thread_proc 350
maxdsiz 0X50000000
maxdsiz_64bit 0X60000000
maxfiles 1024
maxfiles_lim 1300
maxssiz 0X8000000
maxssiz_64bit 0X9000000
maxswapchunks 8192
maxtsiz 0X40000000
maxtsiz_64bit 0X40000000
maxuprc 250
maxusers 512

All the best
Honored Contributor

Re: Maxusers in Oracle 10G


Most probably a problem with the database configuration itself. can you post the error you are getting?

also if possible, the output of "show parameter sessions" -> run at sqlplus level

No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)
Bill Hassell
Honored Contributor

Re: Maxusers in Oracle 10G

Are you running out of pty devices? Check the 3 kernel parameters: ntpy, nstrpty and nstrtel. They should all be bumped up to 300 or even 500 by using SAM. If you don't use SAM, you'll need to build the new kernel by hand but before rebooting, you'll need to also create the new device files using insf. SAM does all of this automatically.

Bill Hassell, sysadmin
Honored Contributor

Re: Maxusers in Oracle 10G

I agree with Bill and Yogeeraj, but believe if those params are set correctly that its more like as you are using IAS, evreybody is getting connection through the same account in wich case its more when the per user limits are reached the next cant connect itself...

All the best
Regular Advisor

Re: Maxusers in Oracle 10G

Hi Jorge,

Please verify what the current kernel setting is by running the following as root user:

/usr/sbin/kmtune -l