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
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