Shell Programming and Scripting

 crsctl status res -n dev-oragrid-ux01| grep -E "ora.*.db"

NAME=ora.cmdbut.boms10.world.svc
NAME=ora.cmdbut.boms_cmdbut_01.world.svc
NAME=ora.cmdbut.cmdbut_01.svc
NAME=ora.cmdbut.db
NAME=ora.lms_dry.db
NAME=ora.mckdwut.db
NAME=ora.miutl1ut.db
NAME=ora.p3fi_dev.db
NAME=ora.personut.db
NAME=ora.sgraphut.db
NAME=ora.sgraphut.sgraphutxdb.svc

NAME=ora.cmdbut.db
NAME=ora.lms_dry.db
NAME=ora.mckdwut.db
NAME=ora.miutl1ut.db
NAME=ora.p3fi_dev.db
NAME=ora.personut.db
NAME=ora.sgraphut.db

grep -E "ora.*\.db$"

for service in `crsctl status res -n $host| grep -E "ora\.$database\.(.+)\.svc" |

 crsctl status res -n dev-oragrid-ux01| grep -E "ora.cmdbut.(.+)\.svc"

grep -E "ora\.$database\.(boms10.world|boms_cmdbut_01.world|cmdbut_01)\.svc" |

for database in `crsctl status res -n $host| grep -E "ora.*\.db" | awk -F"." '{print $(NF-1)}'`
do
{
for service in `crsctl status res -n $host| grep -E "ora\.$database\.(.+)\.svc" | awk -F"." '{print $(NF-1)}'`
do
{
echo "Checking service $service on Database $database"
}
done
}
done

.svc" | awk -F"." '{print $(NF-1)}'

grep -E "ora\.$database\.(.+)\.svc" | awk -F"." '{print $(NF-1)}'`

awk -F"." -vDB=$database 'match ($0, "ora\."DB"\..*\.svc) {sub ("^.*\."DB"\.",""); sub (/\.svc$/,"");print}'

srvctl config database | 
  while read _db; do
    srvctl status service  -d "$_db"
  done