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
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