Oracle internals, debugging and undocumented features
Creating 188.8.131.52 using DBCA
November 11, 2010Posted by on
DBCA needs to include sizes in G Bytes for Fast Recovery Area.Mb are too small these days..
If you pick Automatic Memory Management DBCA will stop you from using more memory than it is size of tmpfs /dev/shm.That is a good feature but
although I specified correct amount of memory database creation failed.After looking logs at cfgtools/dbca I found that pfile was set to use for about few gigabyte higher. It seems that dbca will add 2 Gb extra.
Also DBCA will not let you to create more than two controlfiles. I even tried using custom template.Same result.
After install I noticed that in 11.2 GSD is disabled by default and the service will show as target:offline, status:offline.
The crsctl command has cluster option so you can stop / start all cluster using crsctl command e.g. crsctl stop cluster -all