Urgent:Cannot increase maxusers value

[violin]

Hello ,

We're running Oracle 8.1.7 on HP-UX 11.0.
Today there are too many connections,so the database instance crushed.
After checked database alert file, the related error messages are:
Mon May 6 14:53:21 2002
Errors in file /u04/prodora/8.1.7/admin/bdump/ckpt_10328_prod.trc:
ORA-00600: internal error code, arguments: [kfhahws_01], [166], [], [], [], [], [], []
ORA-01110: data file 166: '/u03/proddata/igcd01.dbf'
ORA-27041: unable to open file
HP-UX Error: 23: File table overflow

We got HP-UX Error:23:File table overflow before,and tried to resolve this by increase maxusers value.

The value of maxusers now is 250, but today when I increase the value over 251 , I got the error message in sam monitor:
The parameter modification(s) you have made have resulted in at
least one parameter evaluating to a value which is greater
than its maximum allowable value. Parameter "msgseg", currently
set to "(MSGTQL*4)", has evaluated to "32800",which is greater
than its maximum allowable value of "32767".

I cannot set the value over than 252,
and I don't know how to solve it.

Please help me,the attachment is the setup value of kernel now.

Any suggestions are appreciate and
Best Regards,

Violin.

[Pete Randall]

Violin,

Using SAM, modify msgseg to use the value 32767 rather than the formula.

HTH,
Pete

[James R. Ferguson]

Hi:

You do not have to use the formula provided for 'nfile' which (in part) is based on the pseudo parameter 'maxusers'. Simply declare the value that is appropriate for you as the value of 'nfile'. The formula's used for many of the kernel parameters *are* useful to help maintain balanced relationships among parameters and hence internal kernel structures, but they are not a requirement for use.

Regards!

...JRF...

[Pete Randall]

I defer to James' more complete and detailed answer. Well done.

Pete

[Justo Exposito]

Hi,

Do you try the multithread server in Oracle?, perhaps this is better to you than the dedicated server.

With this you can reduce many of the kernel parameters like nfiles, nproc etc...

Regards,

Justo.

[Trevor Dyson · Accepted solution]

You could just increase nfile and forget about playing around with maxusers.

The current calculated value of nfile is 14258 according to your attachment so increase nfile directly in sam to something much larger.

After kernel rebuild and reboot then monitor nfile with:

sar -v 1

look for the 'file-sz' column

[harry d brown jr]

Violin,

You need to REPLACE the FORMULA by either typing in a hard value or modifying the multiplier.

Also, you should increase nfiles and ninode.

live free or die
harry

[Jim Butler]

Violin

You are on your way to big problems down the road, if you violate one or more of the kernel interdependencies by overriding the Kernel.

I recommend that you get the system at a quiet time, when you can reboot two or three times (I.E., an hour or so) and first - use Sam to create a kernel for you. In Sam - click Actions, apply tuned parameter set. Try the General OLTP database server system.

Failing that, here is a kernel set I use for Oracle 8i HPUX 11 - 4+ SIDS, 786Mb Ram, D250.
STRMSGSZ 65535
dbc_max_pct 35
default_disk_ir 1
max_thread_proc 256
maxdsiz 0x200000000
maxfiles 512
maxssiz 040000000
maxswapchunks 815
maxtsiz 0X0D000000
maxuprc (MAXUSERS*5)
maxusers 64
ncallout 2064
nflocks 1000
nkthread 2048
npty 96
nstrpty 60
semmni 600
semmns 1000
semmnu 256
semume 96
shmmax 0X200000000
shmmni 850
shmseg 400