Search This Blog

Thursday, September 23, 2010

DBCA doesn't give an option to create a RAC database

This can happen with 10gr2, 11gr1 databases on 11gr2 cluster
Solution: Pin the cluster nodes using the following method.

List the nodes: $GRID_HOME/bin/olsnodes -t -n
Pin the nodes: $GRID_HOME/bin/olsnodes pin css -n node1 node2 node3

"DBCA could not startup the ASM instance configured on this node. To processd with database creation using ASM you need the ASM instance to be up and running. Do you want to recreate the ASM instance on this node?"

On 11gr2 cluster, 10.2.0.4, 11.1.0.6 and 11.1.0.7 dbca can not locate ASM files and result in ASM instance not being recongized.

Solution: Patch 8288940 is available for 10.2.0.4, 11.1.0.6 and 11.1.0.7 as a .jar file as it is platform independent.  The fix will be included in the 10.2.0.5 patchset