Oracle service name to hostname ...
undefine service_name
set linesize 200
col name for a14
col GOAL for a10
col NETWORK_NAME for a14
col HOST_NAME for a40
col INSTANCE_NAME for a12
SELECT a.inst_id,INSTANCE_NAME,service_id,HOST_NAME,name,network_name,creation_date,creation_date_hash,goal,dtp,aq_ha_notification,clb_goal
FROM GV$SERVICES a,GV$INSTANCE b
WHERE a.inst_id=b.inst_id
and name in ( upper ('&&service_name') ,lower('&&service_name') ) ;
undefine service_name
for Scan ip
from grid home ...
/u01/grid/11.2.0.3/grid/bin/srvctl config scan
/u01/app/grid/12.1.0/grid/bin/olsnodes -i -n -t -s -a
