topic Re: Maxusers in Oracle 10G in Operating System - HP-UX

Maxusers in Oracle 10G

Jorge Pons — Wed, 30 Jun 2004 06:55:31 GMT

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

Re: Maxusers in Oracle 10G

Victor BERRIDGE — Wed, 30 Jun 2004 07:02:12 GMT

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

Re: Maxusers in Oracle 10G

Yogeeraj_1 — Wed, 30 Jun 2004 07:02:44 GMT

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

Re: Maxusers in Oracle 10G

Bill Hassell — Wed, 30 Jun 2004 07:02:47 GMT

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.

Re: Maxusers in Oracle 10G

Victor BERRIDGE — Wed, 30 Jun 2004 07:13:55 GMT

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

Re: Maxusers in Oracle 10G

Edgar_8 — Thu, 01 Jul 2004 01:47:04 GMT

Hi Jorge,

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

/usr/sbin/kmtune -l

Regards