Search This Blog

ORA-00064: object is too large to allocate on this O/S while trying to upgrade to 10.2.0.2 from 9.2.0.7 using DBUA

While User want to upgrade from Oracle 9i 9.0.2.0 to 10g 10.0.2.0
SQL> startup upgrade

ORA-00064: object is too large to allocate on this O/S 

3 Solutions follows :
1. # open oracle parameter file with editor and put following line
   PROCESSES <= 1500

Increase Oracle hidden parameter value of  "_ksmg_granule_size"
 Increase directly the value of '_ksmg_granule_size' parameter to 16M (16777216) or 32M (33554432)

open oracle parameter file with editor and put following line
       _ksmg_granule_size=16777216  or 33554432

 do the manual upgradation

   OR 

  Increase SGA size bigger than 1024M to affect granule size

 open oracle parameter file with editor and put following line
        sga_max_size = 1025M

 Continue the upgradation using DBUA or manually.


  OR

 run DBUA with -initParam flag.

 $ dbua -initParam "_ksmg_granule_size"=16777216 or 33554432

Launch your Online Business with a $5.99 .COM!