DBCA not able to detect RAC configuration

Sometime it may happen that, after invoking the DBCA for creating the database or ASM instance creation (prior to 11gR2), we do not see RAC option in the initial screen. 


This means, DBCA was unable to detect the cluster configuration.  I’ve seen couple of factors, which are responsible for this behavior

Missing information in inventory

This normally happens, when RDBMS software is installed prior to CRS install and then re-linked with RAC_ON option. So inventory entry will be similar to following

<HOME NAME=”OraDb10g_home2″ LOC=”/oracle/10gr2″ TYPE=”O” IDX=”2″/>

This entry points to a standalone configuration.  Expected entry for the cluster should be similar to following

<HOME NAME=”OraDb10g_home2″ LOC=”/oracle/10gr2″ TYPE=”O” IDX=”2″/>
   <NODE_LIST>
      <NODE NAME=”NODE01″/>
      <NODE NAME=”NODE02″/>
   </NODE_LIST>
</HOME>

This is can be fixed by manually changing the entries in inventory.xml file.

Get the inventory location (platform specific)

# cat /etc/oraInst.loc
inventory_loc=/oraInventory
inst_group=oinstall

Change /oraInventory/ContentsXML/ inventory.xml

Broken link to skgxn

skgxn  (system kernel generic interface node) is an Oracle API to provide the membership information to RAC  system. This is normally used by the third party cluster softwares.  If third party cluster software is used for example HPUX service guard, skgxn shared object file in ORACLE_HOME/lib will be pointing to vendor specific location (RAC default without third party cluster software is libskgxns.so)

libskgxn2.so ->  /opt/nmapi/nmapi2/lib/hpux64/libnmapi2.so

Now if this link is broken, then RAC will not get the membership information and it will think it is a standalone database.  To fix this problem,  fix the broken link or point it to RAC default.

Once these problems are fixed, DBCA will show us the RAC enabled welcome screen.

Advertisements
This entry was posted in Oracle Database Creation Assistant, Oracle Real Application Cluster and tagged . Bookmark the permalink.

2 Responses to DBCA not able to detect RAC configuration

  1. sudip says:

    It really helps me…good Post

  2. ifte says:

    Thanks a lot; helped me.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s