cancel
Showing results for 
Search instead for 
Did you mean: 

Maxusers in Oracle 10G

Jorge Pons
Trusted Contributor

Maxusers in Oracle 10G

HI

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

Jor
5 REPLIES
Victor BERRIDGE
Honored Contributor

Re: Maxusers in Oracle 10G

Hi,
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
Victor
Yogeeraj_1
Honored Contributor

Re: Maxusers in Oracle 10G

hi,

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

regards
Yogeeraj
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
Victor BERRIDGE
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
Victor
Edgar_8
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

Regards