Today I found one funny thing while installing Oracle RAC 11gR2.
1) Cluster installation was completed.
2) Oracle DB software got installed successfully on both nodes.
When I was creating DB using DBCA(With SGA size 200GB)....immediately after reaching 2% it is hanging. i tried many ways to trouble shoot. no error found in any where...at last i raised P1 SR as well...no solution....finally just for trial purpose i changed SGA to 50GB. and tried again....now it went successfully.
So now my question is there any such restriction on SGA while create DB through DBCA...? Seems to be very very funny but i left with no clue...Any comments please...?
hmmmmm...i forgot version details...
11GR2 on HP UX...and ASM storage device...
Do you really mean 200GB? Not MB? The SGA size may depend on database options you choose, RAC require additional memory. 200MB may be not enought for all components to fit.
When you do upgrade, 570MB is recommended for shared_pool, 128MB for java, + db buffer cashe. So about 1GB to see is common thing.