7 Replies Latest reply: Jun 5, 2008 11:31 AM by 534640 RSS

    ALTER SYSTEM SET processes=1000 generates ORA-00064: object is too large to

    FredS.
      Hi, we've imported an Oracle 8.1.7.4 db into Oracle10.2.0.3.0 and want to change the init params according to the 8.1.7.4. production db.

      When performing:
      =============
      ALTER SYSTEM SET processes=10000 SCOPE=SPFILE;

      We can't start the 10g DB: ORA-00064: object is too large to allocate on this O/S (1,5150880)

      When reducing the size to 500 there is no problem starting the db.

      Question: The node has the same configuration as the one on which the 8.1.7.4 is installed. The 8.1.7.4. does actually run with processes=10000. Can you give me a hint where to search? Should we alter extra parameter(s)?

      Node=Sun Sparc

      Best Regards,

      Fred