oracle@rgpdb01$ srvctl stop instance -d RGPRD -i RGPRD2
PRCD-1315 : failed to stop instances for database RGPRD
PRCR-1014 : Failed to stop resource ora.rgprd.db
PRCR-1065 : Failed to stop resource ora.rgprd.db
CRS-2529: Unable to act on 'ora.rgprd.db' because that would require stopping or relocating 'ora.rgprd.apxrac.svc', but the force option was not specified
oracle@rgpdb01$
oracle@rgpdb01$ srvctl stop instance -d RGPRD -i RGPRD2
PRCD-1315 : failed to stop instances for database RGPRD
PRCR-1014 : Failed to stop resource ora.rgprd.db
PRCR-1065 : Failed to stop resource ora.rgprd.db
CRS-2529: Unable to act on 'ora.rgprd.db' because that would require stopping or relocating 'ora.rgprd.apxrac.svc', but the force option was not specified
oracle@rgpdb01$ srvctl status database -d RGPRD
Instance RGPRD1 is running on node rgpdb01
Instance RGPRD2 is not running on node rgpdb02
Solution:
Copy the file osdbagrp from GRID HOME to RDBMS HOME
Take backup of the existing osdbagrp file.
[oracle@ebsdb01 ~]$ cd /u01/app/oracle/product/12.1.0.2/dbhome_1/bin
[oracle@ebsdb01 bin]$ ls -lrt osdbagrp
-rwxr-xr-x 1 oracle oinstall 32287 Jan 23 13:33 osdbagrp
[oracle@ebsdb01 bin]$ mv osdbagrp osdbagrp.mod
[oracle@ebsdb01 bin]$ pwd
/u01/app/oracle/product/12.1.0.2/dbhome_1/bin
[oracle@ebsdb01 bin]$ ls -lrt osdbagrp
ls: cannot access osdbagrp: No such file or directory
Copy the file from GRID HOME to RDBMS HOME
[oracle@ebsdb01 bin]$ cp -rp /u01/app/12.1.0.2/grid/bin/osdbagrp .
[oracle@ebsdb01 bin]$ ls -lrt osdbagrp
-rwxr-xr-x 1 oracle oinstall 32318 Aug 4 18:28 osdbagrp
Try to add the database through srvctl
[oracle@ebsdb01 bin]$ srvctl add database -d ebstest -o /u01/app/oracle/product/12.1.0.2/dbhome_1 -p +DATA/EBSTEST/PARAMETERFILE/spfileebstest.ora -r primary -a DATA,RECO_EBST
[oracle@ebsdb01 bin]$
Alternate Solutions:
1. Regenerate the osdbgrp binary, as RDBMS software owner
Either relink the osdbagrp executable only (preferred):
$ cd $ORACLE_HOME/srvm/lib
$ make -f ins_srvm.mk iosdbagrp
or alternatively relink all executables, however this will require to shutdown all instances running from this ORACLE_HOME:
$ cd $ORACLE_HOME/bin
$ relink all
No comments:
Post a Comment