Showing posts with label rac_on. Show all posts
Showing posts with label rac_on. Show all posts

Tuesday, June 23, 2009

check RAC Option in Oracle Binary


It's a simple thing for someone to check RAC is linked in the Oracle Binary.

when we need to convert Single database to RAC database... we may find Error

ORA-00439: feature not enabled: Real Application Clusters

and then we may resolve it by relink library (rac_on)

By the way, we can check Oracle binary before;)
cd $ORACLE_HOME/rdbms/lib
nm -r libknlopt.a | grep -c kcsm.o
returns 0, then RAC is not linked.
returns more than 0, then RAC is linked.

Example:
$ cd $ORACLE_HOME/rdbms/lib
$ nm -r libknlopt.a | grep -c kcsm.o
1
RAC is linked in the Oracle Binary
$ cd $ORACLE_HOME/rdbms/lib
$ nm -r libknlopt.a | grep -c kcsm.o
0
RAC is not linked in the Oracle Binary
shell script (one line)->
if [ -f $ORACLE_HOME/rdbms/lib/libknlopt.a ]; then C=`nm -r $ORACLE_HOME/rdbms/lib/libknlopt.a | grep -c kcsm.o` ; if [ $C -gt 0 ] ; then echo 'RAC is linked in $ORACLE' ; else echo 'RAC is not linked in $ORACLE' ;fi fi

That's step to check...