Script for stopping all Oracle RAC instances using awk command

ps -fu oracle | grep pmon | grep -v grep | sed -e 's/.*_//' | sort -u |awk '{print "srvctl stop instance -d " substr($1,1,length($1)-1) " -i " $1}'

How to find apps URL in R12

SQL> select home_url from icx_parameters;

HOME_URL
--------------------------------------------------------------------------------
http://ASDCC.domain.com:8000/OA_HTML/AppsLogin