ORA-00064: object is too large to allocate on this O/S (1,18576200)

SOLUTION:



Increase 'maxuproc' limit to a higher value (work with system administrator to accomplish this) and try again to startup the database with PROCESSES set to MAX.

If action from point 1 still result in ORA-00064 error, increase the following parameter at database level:

_ksmg_granule_size=33554432


This parameter needs to be set in PFILE/SPFILE manually.