Sunday, April 22, 2012

DBCA would not offer to create RAC Database...

Environment:
11gR2 RAC with ASM
10G software installed to accommodate 10g Databases along with 11g in the ASM.


Once installed 10g and applied patch 10.2.0.5.6, DBCA will not offer to create a database which is RAC enabled. Basically it still thinks that 10g software is standalone to that local node.



OLSNODES shows all 4 nodes active but they are Un-Pinned:

+ASM1:11.2.0:/opt/oradev> olsnodes -t
ndhdbd1 Unpinned
ndhdbd2 Unpinned
ndhdbd3 Unpinned

Try pinning them as root:

#>/u01/app/11.2.0/grid/bin/crsctl pin css -n node1

Run the above for all other nodes.

+ASM1:11.2.0:/opt/oradev> olsnodes -t
ndhdbd1 Pinned
ndhdbd2 Pinned
ndhdbd3 Pinned

Now try DBCA and it will offer to create a database which is RAC Enabled.



No comments:

Post a Comment