Monday, October 9, 2017

SRVCTL add database fails with osdbagrp error

I ran into below issue when trying to add a manually created RAC db to CRS. The issue seems to be caused by missing SS_ASM_GRP in config.c. I cloned the Database oracle home of a single node DB to RAC oracle home, as i was trying to avoid applying oneoff patches required on top for Oracle E-Business Suite. This seems to have caused missing ASM group entry in config.c

You can fix it by following below action plan.


$ srvctl add database -d EBSDB -o /u01/app/11.2.0/ebs -p +EBS/spfileEBSDB.ora -c RAC -a EBS
PRCR-1006 : Failed to add resource ora.ebsdb.db for ebsdb
PRCT-1011 : Failed to run "osdbagrp". Detailed error: null

$ cd $ORACLE_HOME/rdbms/lib
$ cp config.c config.c.30apr
$ vi config.c

#define SS_DBA_GRP "oinstall"
#define SS_OPER_GRP "oinstall"
#define SS_ASM_GRP ""

char *ss_dba_grp[] = {SS_DBA_GRP, SS_OPER_GRP, SS_ASM_GRP};

$ rm -f $ORACLE_HOME/rdbms/lib/config.o
$ make -f $ORACLE_HOME/rdbms/lib/ins_rdbms.mk $ORACLE_HOME/rdbms/lib/config.o
$ cd $ORACLE_HOME/srvm/lib
$ make -f ins_srvm.mk iosdbagrp

$ srvctl add database -d EBSDB -o /u01/app/11.2.0/ebs -p '+EBS/spfileEBSDB.ora' -c RAC -a EBS
$ srvctl add instance -d EBSDB -i EBSDB1 -n balla-rac1
$ srvctl add instance -d EBSDB -i EBSDB2 -n balla-rac2

$ srvctl start database -d EBSDB
$ srvctl status database -d EBSDB
Instance EBSDB1 is running on node balla-rac1
Instance EBSDB2 is running on node balla-rac2

No comments:

Post a Comment