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