(1) When you attempt to set the ‘Processes’ parameter to high value (for example> 14000), the instance startup fails with
ORA-00064: object is too large to allocate on this O/S ORA-00064: object is too large to allocate on this O / S.
Solution:
Change PROCESSES parameter.
or
The workaround to bypass this limit is to set the hidden parameter _ksmg_granule_size to 32M or reduce the value of processes parameter.
Example (using spfile): Example (using spfile):
SQL> alter system set “_ksmg_granule_size”=32M scope=spfile;
Another reason:
The initialization parameter DB_BLOCK_SIZE is set to a value that calls for more contiguous space than can be allocated on the operating system being used.
Action: Reduce the value of DB_BLOCK_SIZE so that the requested contiguous space is within the capacity of the operating system.
Another reason:
ORA-00064 error is possibly encountered on database startup when the parameter
OPEN_LINKS_PER_INSTNACE set to over 400 OPEN_LINKS_PER_INSTNACE set to over 400.