32bit Windows 2008,oracle Instance launch error ORA-00064

Environment: Windows 32bit,oracle DB 10.2.0.1 32bit Standalone, 32GB of physical memory

Problem: Instance start error: Ora-00064:object is too large to allocate on this O/S (1,4004280)

The phenomenon is as follows:

H:\oracle\product\10.2.0\db_1\bin>sqlplus/as sysdbasql*plus:release 10.2.0.1.0-production on Sunday May 25 14:40:15 20 14Copyright (c) 1982, 2005, Oracle.  

Problem Analysis:
Instance unable to enter the Nomount state, it is certain that some initialization parameters have problems, so check the alert log to initialize the parameters of the modification record, found the following command:

Alter system set processes=2000 Scope=spfile;

So try to build pfile:

H:\oracle\product\10.2.0\db_1\bin>set Nls_lang=american_america. Zhs16gbkh:\oracle\product\10.2.0\db_1\bin>sqlplus/as sysdbasql*plus:release 10.2.0.1.0-production on Sun APR 25 15 : 00:45 2014Copyright (c) 1982, 2005, Oracle.  All rights reserved. Connected to an idle instance. sql> create pfile= ' H:\pfile20140525.ora ' from spfile= ' H:\oracle\product\10.2.0\db_1\dbs\spfileorcl.ora '; File created. Modify the processes in H:\pfile20140525.ora to 1500 to start:sql> startup Nomount pfile= ' H:\pfile20140525.ora ' in the Pfile ; ORACLE instance started. Total System Global area  612368384 bytesfixed size                  1250428 bytesvariable size             234883972 bytesdatabase Buffers          369098752 Bytesredo buffers                

This confirms that the problem is caused by the processes setting too large. Subsequent modifications to the spfile in processes are no longer described in 1500.

Summarize:

1. This case raises a question:
What is the maximum setting for the Oracle db initialization parameter processes under the 32bit Windows platform? I have not found the answer to this question from MOS.

Ora-00064:object is Too Large to Allocate in this o/s (Doc ID 1232463.1) article says you can view restrictions with the ulimit-a command, but the Windows platform does not have this command.

2. In this case, the 32bit OS is not only limited to Oracle's SGA size, but also limits Oracle's processes parameters.

32bit Windows 2008,oracle Instance launch error ORA-00064