Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: ORA-12500 on Digital Unix
A remote possibility would be a too-low limit on the D.U.
process params. Do the following, as I just did on one of
my smaller systems:
/usr/temp> sysconfig -q proc | grep max
max_proc_per_user = 64 max_threads_per_user = 256 max_per_proc_stack_size = 33554432 max_per_proc_data_size = 1073741824 max_per_proc_address_space = 4294967296open_max_soft = 4096
...and see if anything looks low. Watch out for maxusers -- its value affects other parameters in the proc subsystem as well as at least one parameter in the vfs subsystem.
Hth a little,
WJD